Forum Discussion

NDCOPC's avatar
NDCOPC
Copper Contributor
Aug 02, 2023

MSFlow sending multiple emails from SharePoint list

I've built a flow that is nearly perfect!   Just for background:   I've got a PowerApp that lets our end users make a Stationery Order, and exports the end users order to a SharePoint List. That ...
Microsoft Flow
PowerApps
sharepoint
Rob_Elliott's avatar
Rob_Elliott
Bronze Contributor
Aug 02, 2023

NDCOPC as you've realised, the initial problem is that the flow will trigger for each individual item ordered - i.e. each time an item added to the list. So in your Power App you need to be generating a unique order number, patching that order number to a column in the list for each item ordered then using the Power Apps (v2) trigger with the unique order number as an input parameter. Then you can use the SharePoint get items action from your list with a filter query using the order number. That will get all the items with that order number, then your Select, create html table and other actions will run as you intend.

 

I hope to have some time this afternoon to demonstrate this and I'll post back here asap.

 

Rob
Los Gallardos
Microsoft Power Automate Community Super User.
Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)

Resources