Unanswered

Missing body of email, kind of

(0) Share

Report

Posted on by R Bakker

725

Hi everyone, thanks to your previous help I have put together an app that sends a purchase list from a spreadsheet data source by email and also saves that order to another sheet in the same workbook. Which was initially working well. I had one button to send the email and another to save to my data source. However when I incorporated the two functions into the same button, it sometimes does not work properly every time. It would send the email with subject and my signature but not the actual list, nor would it be saved to my data source.

Could I be asking it to do to much at once?

Data source OneDrive Excel

Categories:

Building Power Apps

I have the same question (0)

All responses (10)

Answers (0)

Sort by

mdevaney 29,991 Moderator on at

Like (0)

Report
Copy link

Link copied!

@Corissandageri
Please supply the code you put in one button. This will hold the answer to your issue.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

@Corissandageri Congratulations for being able to come so far with your project. Could you please attach a picture of the formula that you are using on the button that sends an email and saves the order? Thanks!

Was this reply helpful? Yes No
R Bakker 725 on at

Like (0)

Report
Copy link

Link copied!

I separated them this morning, so that's why I have two screen shots.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

If you were patching before sending the email, then a lot of the stuff is getting reset so the email would leave those as empty.

When you put the two button formulas together, put the email before forAll(patch...)).

Also if you could attach a picture with two formulas together that would also be helpful!

Was this reply helpful? Yes No
R Bakker 725 on at

Like (0)

Report
Copy link

Link copied!
Sorry, not a picture, but this is how I had it when it was all on the one button.
Gmail.SendEmailV2(Dropdown_EmailCustom.Selected.Result, {Subject:"Order fom OP Columbia, P.O "& OrderNumberCustom,Body:"Hello "& Char(32)& Dropdown2Custom.Selected.Result & " "& CanIPleaseCustom & " " & Concat(Purchaselist1,"Qty: " & Dropdown3.Selected.Result &" Code: " & Label6 & " Description: " & Label8 &" ") &" "& Notes1Custom & " "& " "& "Kind regards"& " "& "Ron Bakker" & " "&" "& "PRODUCTION SUPPORT COORDINATOR" & " "& "O P Columbia" & " "& "271 South Highway"& " "& "Whitianga 3510"& " "& "Phone: 07 866 2486"& " "& "Mob: xxxx xxx xx" });ForAll(Purchaselist1,Patch(Table4,Defaults(Table4),{SupplierO:Supplier,CodeO:Code,Description02O:Description02, QuantityO: Dropdown3.Selected.Result,DateOrderedO:Today(), OrderNumO:GalleryOrderN2.Text, ProductNotesO:Notes1Custom.Text}));Reset(ComboBox2);Reset(Dropdown_EmailCustom);Reset(Dropdown2Custom);Reset(Dropdown_SupCustom);Reset(CanIPleaseCustom);Reset(Notes1Custom)

Was this reply helpful? Yes No
R Bakker 725 on at

Like (0)

Report
Copy link

Link copied!

Here is what it looks like when it works properly. When it goes wrong, the actual list is absent in the email but everything else in the email is fine.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Can you attach a picture of the email without the list please?

Was this reply helpful? Yes No
R Bakker 725 on at

Like (0)

Report
Copy link

Link copied!

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
@Corissandageri Let's try saving the list inside a variable and then use that variable in the email body.

Set(ListDetails, Concat(Purchaselist1,"Qty: " & Dropdown3.Selected.Result &" Code: " & Label6 & " Description: " & Label8 &" ")); Gmail.SendEmailV2(Dropdown_EmailCustom.Selected.Result, {Subject:"Order fom OP Columbia, P.O "& OrderNumberCustom,Body:"Hello "& Char(32)& Dropdown2Custom.Selected.Result & " "& CanIPleaseCustom & " " & ListDetails &" "& Notes1Custom & " "& " "& "Kind regards"& " "& "Ron Bakker" & " "&" "& "PRODUCTION SUPPORT COORDINATOR" & " "& "O P Columbia" & " "& "271 South Highway"& " "& "Whitianga 3510"& " "& "Phone: 07 866 2486"& " "& "Mob: xxxx xxx xx" }); ForAll(Purchaselist1,Patch(Table4,Defaults(Table4),{SupplierO:Supplier,CodeO:Code,Description02O:Description02, QuantityO: Dropdown3.Selected.Result,DateOrderedO:Today(), OrderNumO:GalleryOrderN2.Text, ProductNotesO:Notes1Custom.Text})); Reset(ComboBox2); Reset(Dropdown_EmailCustom); Reset(Dropdown2Custom); Reset(Dropdown_SupCustom); Reset(CanIPleaseCustom); Reset(Notes1Custom)

I don't why your code is not working. I have one suggestion that is not the best but it should work. You can separate the code in two buttons like you showed me. But you can hide the Track Order button and instead do "Select(Button4)" at the end of email button.

Gmail.SendEmailV2(Dropdown_EmailCustom.Selected.Result, {Subject:"Order fom OP Columbia, P.O "& OrderNumberCustom,Body:"Hello "& Char(32)& Dropdown2Custom.Selected.Result & " "& CanIPleaseCustom & " " & Concat(Purchaselist1,"Qty: " & Dropdown3.Selected.Result &" Code: " & Label6 & " Description: " & Label8 &" ") &" "& Notes1Custom & " "& " "& "Kind regards"& " "& "Ron Bakker" & " "&" "& "PRODUCTION SUPPORT COORDINATOR" & " "& "O P Columbia" & " "& "271 South Highway"& " "& "Whitianga 3510"& " "& "Phone: 07 866 2486"& " "& "Mob: xxxx xxx xx" }); Select(Button4);

Hopefully one of them will work!

Was this reply helpful? Yes No
R Bakker 725 on at

Like (0)

Report
Copy link

Link copied!

Thank you I will try this next week.

Was this reply helpful? Yes No