cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
sudosaurus
Post Prodigy
Post Prodigy

[RESOLVED] Flow running multiple times for when bulk items added to SharePoint list

Hello,

 

I have a flow that does the following:

- Bulk items are added to a SharePoint list in Quick Edit mode.

- The Get items action grabs these new items from the list.
- The next item is "Apply to each" which references the value from "Get items from Customers list".
- The next action is "Get file content" which refers to a .docx template word document with Quick part references in it

- The next action is "Create file" which creates a new word document in the "Saved Documents" folder based on the template in "Get file content".
- Update file properties action then updates the properties of the newly created word document with the field data from the "Customer list".

sudosaurus_3-1613742007484.png


The trigger point for the flow is using the Quick Edit action on the "Customers" SharePoint list and pasting in 6 rows of data from a spreadsheet. When each item updates it triggers a workflow.

However I have noticed that if one of these workflows runs, it still generates 6 documents based on each of the rows in the "Customer" list even though there are 6 running workflows.

sudosaurus_0-1613741802535.jpeg


sudosaurus_1-1613741818027.jpeg

 

sudosaurus_2-1613741947493.png

Any idea what is going wrong here? Logically I would expect a workflow to run for each item added.

 

1 ACCEPTED SOLUTION

Accepted Solutions
sudosaurus
Post Prodigy
Post Prodigy

I've solved this by changing the trigger to: "When an item is created".

 

For some reason this stops the creation of multiple workflows and now only one is run.

View solution in original post

1 REPLY 1
sudosaurus
Post Prodigy
Post Prodigy

I've solved this by changing the trigger to: "When an item is created".

 

For some reason this stops the creation of multiple workflows and now only one is run.

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Users online (3,915)