Extract IDs as Array in Power Automate
I want to share a solution that I recently discovered in Power Automate Flow and Logic Apps. It’s a simple yet powerful technique that can help you extract IDs
I want to share a solution that I recently discovered in Power Automate Flow and Logic Apps. It’s a simple yet powerful technique that can help you extract IDs from a JSON object and convert them into an array of numbers. In my case, I needed this array to use as parameters for another Power Automate Flow action. So, if you’re facing a similar challenge, read on to learn how to solve it.
In other words, I needed something like this:
https://never-stop-learning.de/extract-ids-as-array-power-automate/
Extract IDs as Array
Extract IDs as Array in Power Automate is an action in the Power Automate platform that allows users to extract a set of records from a data source and return an array of their IDs. This action enables users to quickly pull a set of records from a database, Excel sheet, or other data source, and then use the array of IDs to perform additional actions such as sending an email or creating a task. This action can be used in a variety of scenarios, such as extracting a set of contacts from a database and then sending them an email.
More links on about Power Platform/Power Automate
More results from powerusers.microsoft.com
6 key moments in this video
Feb 2, 2022 — Enter the whole array in the 'From' field, and select which value you want to return in the 'Map' field. Power Automate select values from array.
Aug 8, 2022 — Here's how you can select an element from an array based on certain condition in Power Automate Flow.