Answered

How to send a email with patched contents

(0) Share

Report

Posted on by MelvinGRM

Hi,

I made a form in powerapps, when i hit on send button in the app the contents will be send to a sp list. Now i'm looking for a way to sending it also to my email. Is there a way to do that in the same code? I'm using this code on the 'on select':

ForAll(Gallery1.AllItems;
 Patch(Uitgeleend;
 Defaults(Uitgeleend); 
 {Title:Titel; 
 categorie:Categorie.Value;
 barcode:Barcode;
 project:Textcart.Text;
 datumretour:Datepick.SelectedDate; 
 aantal: Value (quant.Text)
 }
 )
)

;;Clear(MyCollection)
;;Navigate(Uitleen)

Thanks!

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

Sort by

rubin_boer 4,843 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
hi @MelvinGRM yes you can do that, if you want to send an email for every record do the following:

Add the Office365Outlook connector

Alter code as follows

ForAll(Gallery1.AllItems; Patch(Uitgeleend; Defaults(Uitgeleend); {Title:Titel; categorie:Categorie.Value; barcode:Barcode; project:Textcart.Text; datumretour:Datepick.SelectedDate; aantal: Value (quant.Text) } ); Office365Outlook.SendEmailV2( "your Email", "your Subject", Title:Titel categorie:Categorie.Value barcode:Barcode project:Textcart.Text datumretour:Datepick.SelectedDate aantal: Value (quant.Text) ) )

Was this reply helpful? Yes No
MelvinGRM 84 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi, thanks for your help! I copied the code and pasted it in the editor and it gives an error: unexpected signs. the formula contains ParenClose while Colon is expected.

The code:

ForAll(Gallery1.AllItems; Patch(Uitgeleend; Defaults(Uitgeleend); {Title:Titel; categorie:Categorie.Value; barcode:Barcode; project:Textcart.Text; datumretour:Datepick.SelectedDate; aantal: Value (quant.Text) } ); Office365Outlook.SendEmailV2( "mymail@work.com"; "Test"; Title:Titel categorie:Categorie.Value barcode:Barcode project:Textcart.Text datumretour:Datepick.SelectedDate aantal: Value (quant.Text) ) ) ;;Clear(MyCollection) ;;Navigate(Uitleen)
What did i wrong? Thanks!

Was this reply helpful? Yes No
Verified answer

WarrenBelz 155,752 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @MelvinGRM ,

Two things - firstly the Patch will work a lot faster if done as below. Also the Body of the email needs to be a Text String - I have added line breaks as well

Patch( Uitgeleend; ForAll( Gallery1.AllItems; { Title: Titel; categorie: Categorie.Value; barcode: Barcode; project: Textcart.Text; datumretour:Datepick.SelectedDate; aantal: Value(quant.Text) } ) ); ForAll( Gallery1.AllItems; Office365Outlook.SendEmailV2( "mymail@work.com"; "Test"; "Title:" & Titel & " categorie:" & Categorie.Value & " barcode:" & Barcode & " project:" & Textcart.Text & " datumretour:" & Text(Datepick.SelectedDate, "dd/mm/yyyy") & " aantal:" & quant.Text & " " ) ) );; Clear(MyCollection);; Navigate(Uitleen)

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.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No
MelvinGRM 84 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @WarrenBelz thanks for the code and your tip for patching.

When i use your code it gives an error: invalid argument type (table) a record value is expected instead

What did i wrong?
thanks!

Was this reply helpful? Yes No
WarrenBelz 155,752 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @MelvinGRM ,

I simply used your code assuming it had valid values - my only change was the ForAll/Patch reversal (for speed) and the text structure in the body of the email. Which element is causing the error ?

Was this reply helpful? Yes No
MelvinGRM 84 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @WarrenBelz,

i changed the patch code back and it works. Thanks!
The code that i use:

ForAll(Gallery1.AllItems; Patch(Uitgeleend; Defaults(Uitgeleend); {Title:Titel; categorie:Categorie.Value; barcode:Barcode; project:Textcart.Text; datumretour:Datepick.SelectedDate; aantal: Value (quant.Text) } );; ForAll( Gallery1.AllItems; Office365Outlook.SendEmailV2( "mail@mail.com"; "Test"; "Title:" & Titel & " categorie:" & categorie.Value & " barcode:" & barcode & " project:" & Textcart.Text & " datumretour:" & Text(Datepick.SelectedDate; "dd/mm/yyyy") & " aantal:" & quant.Text & " " ) ) );; Clear(MyCollection);; Navigate(Uitleen)

If i patch two or more items in one gallery, i get separated emails. Is there a way to send al those information in one email?

Thanks!

Was this reply helpful? Yes No