cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
azanetell
Level: Powered On

Send Email with form values from completed from

So I found this subject on here a few times but not having the same issue I am. I have a request form in Powerapps. I want it to send an email with what the user input after the form is submitted successfully.

 

I have the submit button on select set to submitform. The form submits successfully and the data appears in my Sharepoint list no problem there.

Button1_Onselect.png

I have the “OnSuccess” coded to send an email via MS flow. The email sends fine but any text in “edit” fields do not come through on the email. If it is a “view” form they come through just fine.

How do you send an edit form values via an email?

email.pngForm1_On success.png

1 ACCEPTED SOLUTION

Accepted Solutions
MikeLockwood
Level 8

Re: Send Email with form values from completed from

I believe in your OnSuccess function you should be using Form.LastSubmitted.FieldName instead of the DataCard to get the value out and passed to Flow.  Sometimes, depending on how you have your Form setup on submission resets the Form to New so grabbing the DataCard value would be grabbing an empty value.

Thanks,
Mike L.

View solution in original post

6 REPLIES 6
MikeLockwood
Level 8

Re: Send Email with form values from completed from

I believe in your OnSuccess function you should be using Form.LastSubmitted.FieldName instead of the DataCard to get the value out and passed to Flow.  Sometimes, depending on how you have your Form setup on submission resets the Form to New so grabbing the DataCard value would be grabbing an empty value.

Thanks,
Mike L.

View solution in original post

azanetell
Level: Powered On

Re: Send Email with form values from completed from

Yes! It worked! I knew it had to be something simple like that.

Do you know if there is a place to see all of the 'item' actions like this? I can find a list of all of the formulas but I knew it had to be something like this but I dont know where to find a list of things like this to know they exist.

Thanks again!

MikeLockwood
Level 8

Re: Send Email with form values from completed from

I think this is the page you are looking for.  It lists all the properties.

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/reference-properties

Thanks,
Mike L.
azanetell
Level: Powered On

Re: Send Email with form values from completed from

yes thanks again!

One more scenario for this. I have a multi select drop down and I cant seem to figure out what controls it wants to display the values. For my single selection drop downs .value works fine. For this one I have tried:

 

  • Form1.LastSubmit.'field name'.Value
  • Form1.LastSubmit.'field name'.selected.Value
  • Form1.LastSubmit.'field name'.item.selected
  • Form1.LastSubmit.'field name'.text
  • Form1.LastSubmit.'field name'.viewValue
  • Form1.LastSubmit.'field name'.value.text
  • Form1.LastSubmit.'field name'.selected.value.text

It gives "invalid argument type" for all of these. I looked through the controls in the link you posted but cant seem to find the right one. Any suggestions?

MikeLockwood
Level 8

Re: Send Email with form values from completed from

I think you want SelectedItems on the ComboBox.

 

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/controls/control-combo-box

Thanks,
Mike L.
azanetell
Level: Powered On

Re: Send Email with form values from completed from

I think I solved my own question. I just used Concat((Form1.LastSubmit.'Additional persons to notify'.Email,Email &"; ") and I tested it and it worked!

 

Thank you so much for all of your help on my project!

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

Top Kudoed Authors
Users Online
Currently online: 186 members 4,469 guests
Please welcome our newest community members: