Run Flow on Multiple List Items in SharePoint Online List?

[jmckee13]

I have a news list that I want to create an HTML email that I can select let's say 5 to 10 items in a list and run a Flow workflow that would build an HTML email and distribute it.  Can I run Flow on multiple list items?  Any thoughts on connectors or examples of someone who has done something like this?

[v-yamao-msft · Accepted solution]

Hi @jmckee13,

How do you want to trigger the flow? Do you want to trigger the flow by selecting an item in SharePoint list using trigger For a selected item? Or do you want to Get items from the list then filter the returned items?

If it is the first scenario, I am afraid that it might be not possible to trigger the flow with multiple selected items. It seems that only one item can be selected. If you need this feature, please consider submitting a request on Flow Ideas Forum:

https://powerusers.microsoft.com/t5/Flow-Ideas/idb-p/FlowIdeas

If it is the second scenario, you flow could be triggered by a Button, then the action Get items. In the action Get items, using the Odata filter query to filter items. Then the action Create HTML table, sending an email with the multiple items at a time.

Please take the following screenshot for a reference.

The following docs could be your reference:

Using Filter Expressions in OData URIs

Build flows with HTML Tables

Best regards,

Mabel Mao

[GabrielStJohn]

Hey, @jmckee13!

Thank you for posting on the Flow Community Forum! It appears as though @v-yamao-msft would like some more information in order to further assist you properly with your issue. Please share any additional information that was requested in order to decrease the amount of time that it will take for you to be assisted!

Thank you for being an active member of the Flow Community!

-Gabriel
Flow Community Manager