web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

Welcome to the Power Platform Communities
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Get all items and filt...
Power Automate
Unanswered

Get all items and filtering them

(0) ShareShare
ReportReport
Posted on by rajanetha

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. 

 

Flow.PNG

 

Categories:
Building flows
I have the same question (0)
  • v-bacao-msft Profile Picture
    v-bacao-msft Microsoft Employee on at

    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.

    4.PNG5.PNG

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

     

    Best Regards,

    Barry

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Welcome to the Power Platform Communities

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the February Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
David_MA Profile Picture

David_MA 77 Super User 2026 Season 1

#2
Haque Profile Picture

Haque 68

#3
Expiscornovus Profile Picture

Expiscornovus 56 Most Valuable Professional

Last 30 days Overall leaderboard

Featured topics

Share your ideas and struggles with building Power Automate flows!
Survey: Power Automate mobile app
How to Ask for Help with Your Power Automate Workflow
Flows are not visible for users who sign in with their personal accounts
Start and wait for an approval action
Restore a deleted flow
List of actions cheat sheet for Power Automate Desktop
Question for everyone : How are you using Create Text GPT in AI Builder?
Welcome to the Power Automate forum!

Product updates

Microsoft Power Platform Community release plans