Power Platform Community Forum Thread Details

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:

If I submit 2 records at a time, both records are assigned Bulk-1.
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:

Trigger the flow when new records are added to the SharePoint list.
Filter records by Bulk ID.
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:

Building flows

Hi @Sooram_Niharika

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:

https://learn.microsoft.com/en-us/sharepoint/dev/business-apps/power-automate/guidance/working-with-get-items-and-get-files#filter-queries

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