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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Filter Specific Bulk I...
Power Automate
Answered

Filter Specific Bulk IDs for Email Attachment in Power Automate Flow

(0) ShareShare
ReportReport
Posted on by 2

Hello,

I am working on a Power Apps and Power Automate solution where bulk data submissions are made to SharePoint. For every bulk submission, a unique Bulk ID is generated in the backend.

For example:

  1. If I submit 2 records at a time, both records are assigned Bulk-1.
  2. If I submit another 4 records later, they are assigned Bulk-2.

My requirement is to build a Power Automate flow to:

  • Filter records based on their specific Bulk ID.
  • Attach the records in an email and send only the filtered records belonging to that specific Bulk ID.

Issue:
I have created a flow to fetch and send these records via email. However, instead of fetching and sending records for only the current Bulk ID, it is retrieving and sending all the Bulk IDs available in the SharePoint list.

Steps I Followed in the Flow:

  1. Trigger the flow when new records are added to the SharePoint list.
  2. Filter records by Bulk ID.
  3. Create an attachment and send an email.

Could someone guide me on how to ensure the flow filters records accurately for the current Bulk ID being submitted?

Thank you!

Categories:
I have the same question (0)
  • Verified answer
    MarkRahn Profile Picture
    1,351 Super User 2026 Season 1 on at
     
    You will need to use the Filter Query parameter for the "Get Items" Action for SharePoint. If you don't see "Filter Query", click on "Show All" next to Advanced parameters for the Action.
     
    For the "Get Items" Action, I added a Filter Query of:
                   Bulk_x0020_ID eq @{triggerBody()?['Bulk_x0020_ID']}
     
    You have to reference your fields by their internal names so if you named your field "Bulk ID" it would be "Bulk_x0020_ID" where "_x0020_" represents the space. You can see where I selected the Trigger Input above what SharePoint thinks the internal name of the field is. This is an easy way to get the internal name for using "Filter Query".
     
    For the example I did, the "Bulk ID" field is a Number. If your "Bulk ID" field is a string, you would put single quotes around it like this:
    Bulk_x0020_ID eq '@{triggerBody()?['Bulk_x0020_ID']}'
     
    You would use a "For each" Action to process each item that is returned.
     
    Other things to keep in mind is that if your List is going to grow large (>1000 items), you will want to add an Index on the "Bulk ID" field. This ensures that SharePoint will be able to find your items quicker.
     
    For more information on using Filter Query, here is a link to the MS Learn site:
     
    This community is supported by individuals freely devoting their time to answer questions and provide support. They do it to let you know you are not alone. This is a community.

    If someone has been able to answer your questions or solve your problem, please click Does this answer your question. This will help others who have the same question find a solution quickly via the forum search.

    If someone was able to provide you with more information that moved you closer to a solution, throw them a Like. It might make their day. 😊


    Thanks
    -Mark

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

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!

Leaderboard > Power Automate

#1
David_MA Profile Picture

David_MA 262 Super User 2026 Season 1

#2
Haque Profile Picture

Haque 227

#3
Expiscornovus Profile Picture

Expiscornovus 225 Most Valuable Professional

Last 30 days Overall leaderboard