shopping cart app - send email with chart's items

(1) Share

Report

Posted on by gennarodp

294

Hello,

i am new with Power Apps, and this is my first post.

I have realised following a video, a shopping cart app.

I have realised a button "SEND ORDER", that copy the items of chart(Collection) in a sharepoint list.

But, i would like also that, send email with all items of single transaction.

This is my Button Formula to save data in a sharepoint list:

IfError(ForAll (ShoppingCart; Patch ('Tools Order';Defaults ('Tools Order'); {Title:Article; Description:Description;'OrderedQty':OrderedQty}));Notify("Something is wrong";NotificationType.Error);Notify("Order sended";NotificationType.Success))

How can i modify it to send also email with all items in table of single transaction ?

Thank you all

Categories:

Building Power Apps

All responses (16)

Answers (2)

Sort by

flugaoveltem 217 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @gennarodp
You need to create a Power Automate flow to do that.
Your flow should look like this:

In the button formula trigger a flow start.
gennarodp 294 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello, thank you very much for your answer.

Can you explain me better this flow ?

What formula button should i use ?

What variables should i use in flow ?

Thank you very much
Thank you.
flugaoveltem 217 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello @gennarodp
Create a new flow from template and select Powerapp Button.
Add a new step Send email notification,
In each field inside the step add ask to powerapps content.
Inside the app, select a button and add Action -> Power Automate

When added, it will ask you three inputs
gennarodp 294 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello, thank you very much.

is it work also with send email v2 or only with email notification?

how can i edit formula’s button of power app to reach this flow ?

thank you
flugaoveltem 217 on at

Like
a
(0)

Report
Copy link

Link copied!

Yes, you can use v2 version.

When added, it will ask you three inputs
gennarodp 294 on at

Like
a
(0)

Report
Copy link

Link copied!

How can i modify email field, to insert email address ?

Is The table, automaticly setted in the body of email ?

thanks
WarrenBelz 156,740 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @gennarodp ,'

You should not need a Flow - firstly add the Office365Outlook connector to your data source and then this should work

IfError( ForAll( ShoppingCart as aCart; Patch( 'Tools Order'; Defaults ('Tools Order'); { Title:aCart.Article; Description:aCart.Description; 'OrderedQty':aCart.OrderedQty } ) ); Notify( "Something is wrong"; NotificationType.Error ); Notify( "Order sent"; NotificationType.Success );; Office365SendEmailV2( User().Email; "Your order sent"; "<table>" & Concat( ShoppingCart; "<tr> <td>" & Article & "</td> <td>" & Description & "</td> <td>" & OrderedQty & "</td> </tr>" ) & "</Table>" ) )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.
gennarodp 294 on at

Like
a
(0)

Report
Copy link

Link copied!

@WarrenBelz thank you very very much.

In what part of formula Can i i add email address of the person that receive this email ?

Thank you
gennarodp 294 on at

Like
a
(0)

Report
Copy link

Link copied!

I have resolved email field. All ok. Thank you !

It's work.

It is possible set a table in email body ?

Now, the output is in the following form:

Article 1
Description 1
Qty1
Article 2
Description 2
Qty2
Article 3
Description 3
Qty3

But in my email's body the edges of the table are not visible. How can i make them marked ?
How can i enter the name of each column ?

Thank you very much, and happy new year !!
WarrenBelz 156,740 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

@gennarodp ,

Where I have put User() .Email - this is good for testing as the result will come back to you.

Also put whatever you need in the Subject where I have "Your order sent"

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.