Re: Lookup a value in power automate
I'd suggest using a Filter array on the locations array in your JSON.
In my example I've assumed you are looping over each of the rows in your Excel file.
See my example below. I'll go into each of the actions.
Compose just contains a sample of your data you retrieve from HTTP. And Parse JSON gets me nice properties I can refer to. You can skip these steps as you already have your data.
List rows present in a table gets my Excel data.
My Excel data for this example has the following:
Next, I use an Apply to each to iterate over each of the rows from Excel. I then have a Filter array that takes in the locations array from my Parse JSON action and filter on url is equal to Location (from the current row)
This will return a filtered array of objects where the url matched. We can then use a Condition to check if the length of the Filter array is greater than 1, and apply the appropriate actions for true or false.
The expression to get the length of the array is:
length(body('Filter_array'))
If you then wanted to extract out the group Id from the Filter array you could use a first expression as we assume it's only returned a single result, but still an array.
first(body('Filter_array'))?['groupId']
Hope that helps and is what you were after.
