Showing results for 
Search instead for 
Did you mean: 
Regular Visitor

Get all items and filtering them

I have a list where the flow should be triggered when RUN column is YES.

After that, it should get all BODY column items of the current list where PushNotificationID column value equal to the current item PushNotificationID column value and mail to a specific user.


I need to send the output in json.


For ex: Created a item(5th item) where RUN column is YES. Now the flow triggers and I want the BODY column of 2nd,4th and 5th items as PushNotificationID is same as the current item and it should be mailed in JSON format.


Thanks and let me know if you have any queries. 




Community Support
Community Support

Re: Get all items and filtering them

Hi @rajanetha,


I am afraid I need more explanation about "PushNotificationID column value equal to the current item PushNotificationID column value".

I want to know what the "the current item" refers to. Is "current item PushNotificationID column value" another column?

Could you provide more information about your screening of items?

Also, depending on your description, your Flow may be created like this:

  Use When an item is created as trigger, set Condition, and only execute the following action when the value of Run column is equal to "yes".

  Use Get items to filter and get the corresponding items. (I need you to provide specific filters to provide specific configuration).

  Use Select to get all the values of the specified column.

  Configure Compose to store the output of Select action, as the body of the mail, the output of select is the data in JSON format.

  You could also consider using attachments to store these contents in a JSON file.


Please provide more details about filtering items and which should be helpful for me to share a further suggestion.


Best Regards,


Community Support Team _ Barry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources


New Ranks and Rank Icons released on April 21!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power Automate Community!


Now Live: Power Virtual Agents Community!

We are excited to announce the launch of Power Virtual Agents Community. Check it out now!


New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!


Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!


Community Summit North America

The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Users online (7,037)