Unanswered

Parse JSON

(0) Share

Report

Posted on by Broly123

209

Hello! Im creating a shopping cart app on power apps and I want to send the shopping cart orders that I have stored in a gallery as an email. I created a collection and created a flow from automation. The flow works up until I added the email step. Any help would be greatly appreciated

Collect(
 colShoppingCart,
 {
 ID: ThisItem.' $ITEM_ID',
 Description: ThisItem.Description,
 Price: ThisItem.Price,
 Qty: Slider1.Value
 }
)

flow code.PNG

Categories:

Building Power Apps

All responses (3)

Answers (0)

Sort by

madlad 2,637 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!

To begin, just for future reference, the Power Automate Community might be better for this sort of question.

However,

instead of Apply to each to format the data, try the Create HTML Table connector, which will display your data nicely, and then the result of that can be put directly in the email.

Hope this helps!
Broly123 209 on at

Like
a
(0)

Report
Copy link

Link copied!

@madlad Sounds like a better solution! My data source is excel. When creating the steps, Do I go from Power APPS --> "Excel Online (Business) Get Worksheets -> Create HTML Table?

@TheRobRush
madlad 2,637 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

I think so, it depends on exactly what you're getting from excel, but it will definitely be one of the excel connector actions. However, if your data is coming straight from excel, you could also just include the file as a attachment if you wanted, whatever suits your needs best.