Order confirmation email from PowerApps/SharePoint

[sudosaurus]

Hello,

I have built this Power App where I have an order form that patches values to a SharePoint list.

Currently I have a workflow that sends an email when a new item is created which contains an order reference number.

Ideally we'd like to include a table in the email with details of which items have been selected.

In the example above, we'd only want to show the products 'size/s' that have been selected along with their 'Quantity' value.

Just not sure how this can be dynamically generated based on whichever random items have been selected.

Any help/pointers would be great.

Thanks.

[edgonzales]

@sudosaurus  

Hey there - So, when you patch to the SP list, is it one line item per list item with a common order number or something between the rows?

Since your trigger is when an item is created, is it then sending a single email for each line on the order?

If both of those are true, then you'll probably need to find a different trigger so you're essentially only triggering once per order, rather than once per order/line.

As far as sending a table, that part is pretty easy once we figure the trigger out....we would add a step to "List Items" filtering on the appropriate order number, then maybe a "Select" to only get the columns you're interested in. Follow that with "Create HTML Table", maybe some formatting, and then send the email. 

Keep us posted,

-Ed

If you liked this reply, please give it a thumbs up! If this reply has answered your question or resolved your challenge, please consider marking it as a Solution. This helps other users find it more easily via search.