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

Report
All responses (
Answers (