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

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

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

New Ideas Forum MPA.jpg

A new place to submit your Ideas for Power Automate

Announcing a new way to share your feedback with the Power Automate Team.

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

Super User 2 - 2022 Congratulations 768x460.png

Welcome Super Users

The Super User program for 2022- Season 2 has kicked off!

Users online (3,925)