Building a flow that parse through a SharePoint list

[Anonymous]

Hello,

I am fairly new to Power Automate. I was wondering if it was possible to build a flow that would parse through a SharePoint list looking for two or more items to have the same custom reference ID (not the unique ID generated by SP) and then looking if all of those entries have a specific status, approved in this case. In other words, I need the flow to check for entries with the same identifier and check if all of those entries have a specific status (approved). Is that possible? If so, how?

[v-jefferni · Accepted solution]

Hi @Anonymous ,

Based on your description, I have made a test, but there are no mistakes.

Test SharePoint list:

Here is flow:

You could set query criteria in “Filter Query” of “Get items” action.

Result:

The last Compose action is just used for displaying the result, you can use the outputs of Apply to each wherever you need.

Best regards,