Power Platform Community Forum Thread Details

Hello,

I'm a bit new. I created a supply order Power App for my team. Each order submitted goes into a SharePoint list that, although it might create multiple items depending on how many supplies and type of supplies someone order, are identified by a unique OrderID.

Here's an example of the SharePoint list:

ID	OrderID	OrderedBY	Part Number	Product	QTY Ordered
1	1	John Doe	601	Gloves L	1
2	1	John Doe	300	Safety Glasses CLR	1
3	2	Jane Doe	602	Gloves XL	2
4	2	Jane Doe	302	Safety Glasses GRY	1
5	2	Jane Doe	200	Glass Cleaner	1

I'd like to create a flow that gets only the latest OrderID whenever someone submits their cart on the app, creates a spreadsheet for just that OrderID, and sends an Email with that CSV file attached and title of the email says "John Doe's Supply Order Request"

I get lost in Get Items. Would love some help please.

Thank you,

Gioroy20

Categories:

Building flows