Email functionality question

(0) Share

Report

Posted on by DerrickH

196

Hello,

I am a relatively new user to power apps and I have a question about the functionality and capability of PowerApps, etc.

I have created a simple inspection within power apps and I'm wondering what the best way to go about getting certain information from that completed inspection to a specific person via automation. My thought process is this...I would like to be able to send specific results from the submitted inspection based on a certain selected field in the inspection. Is it possible to send the specific results to a specified email upon a user selecting an icon which submits the form? If so, how might I start to build this work flow and what would the steps involved be?

Categories:

Building Power Apps

I have the same question (0)

All responses (43)

Answers (4)

WarrenBelz 153,079 Most Valuable Professional on at

Like (0)

Report

Hi @DerrickH ,

A broad question, but certainly easily achievable directly from Power Apps. The Outlook function Office365Outlook.SendEmailV2 needs the To: Subject: and Body as the parameters and you need to include the record either as a string or (if you want some formatting) a HTML text.

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.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No
DerrickH 196 on at

Like (0)

Report

@WarrenBelz

Thank you for the response. What information would you need to narrow down the solution? Also, I hate to ask for baby steps here but how might I go about achieving this? Are you familiar with any videos (such as youtube) I could watch to familiarize myself with this process?

Was this reply helpful? Yes No
Verified answer

WarrenBelz 153,079 Most Valuable Professional on at

Like (1)

Report
@DerrickH ,

It is not that complex - if for instance you had OnSuccess of your Form

Set(gblRecord, Self.LastSubmit)

and OnSelect of your Gallery

Set(gblRecord, ThisItem); Navigate( . . . . )

then you would have the entire record you want in a Variable - then

Office365Outlook.SendEmailV2( "YourToAddress", "YourSubject", "YourIntroHere FieldHeading1" gblRecord.YourFirstField & " FieldHeading2" & gblRecord.YourSecondField & . . . . . . )

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.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No
DerrickH 196 on at

Like (0)

Report

@WarrenBelz

Great information......although what if I only wanted certain information from the form sent? For example, I will use "Column" as form controls, so if a user selects a "yes" value in Column D, then upon the yes value being selected, I would then only want the submitted information from Column A,B & C sent via email. If it matters, the column order I am speaking about is random and the information I need sent is more than 3 columns as well.

Was this reply helpful? Yes No
WarrenBelz 153,079 Most Valuable Professional on at

Like (0)

Report

@DerrickH ,

You can choose whatever columns you want from the current record as per the structure example I posted.

Was this reply helpful? Yes No
DerrickH 196 on at

Like (0)

Report

@WarrenBelz

I'm having a bit of trouble understanding exactly what needs to be in the formula for a few of the specific columns. One column I need data from is a dropdown list of choices, the other is list of choices which i've changed to a radio style selection. Here is my formula so far.

SubmitForm(InspectionForm);
Office365Outlook.SendEmailV2(
"Test@Test.com",
"Bad Order Submission",
"Submission Information for Bad Order Car ID" & gblRecord.ID & " Type of Inspection" & gblRecord.'Type of Inspection' & " Rail Car Status" & gblRecord.'Rail Car Status'{Importance:"High"})

The "Type of Inspection" is a dropdown list of choices and the "Rail Car Status" is a Radio list.

Also, I need to make this email conditional upon a column being selected. For example, a column named "Bad Order Car" which is a Radio List.....if a user selects "Yes", upon submission of the form...an email is sent. If a user selects "No", an email is not sent. Is this possible?

Was this reply helpful? Yes No
Verified answer

WarrenBelz 153,079 Most Valuable Professional on at

Like (1)

Report

Hi @DerrickH ,

This blog of mine may assit your here - you would need .Value on your choice columns. As for the condition, you jsut need an If() statement before the send mail script.

Was this reply helpful? Yes No
DerrickH 196 on at

Like (0)

Report

@WarrenBelz

Great article, I wish I could've come across this earlier! Last question about the email section if you don't mind.....how do you put a "space" in between the field heading and the corresponding result? For example, my field heading is "Location" and when I get the email from the submission, its laid out where is says "LocationDallas" instead of "Location Dallas". Do you happen to have a blog or some other documentation I could review on this subject as well?

Was this reply helpful? Yes No
WarrenBelz 153,079 Most Valuable Professional on at

Like (0)

Report
Hi @DerrickH ,

For a single space, just add it in the code

Rail Car Status " & gblRecord.'Rail Car Status'

for more than one space, add non-breaking spaces

Rail Car Status   " & gblRecord.'Rail Car Status'

Was this reply helpful? Yes No
DerrickH 196 on at

Like (0)

Report

@WarrenBelz …thank you Sir, I really appreciate all of your help this far!

Was this reply helpful? Yes No