cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

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
Advocate IV
Advocate IV

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
Advocate IV
Advocate IV

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

Anonymous
Not applicable

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!

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.
Anonymous
Not applicable

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?

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.
Anonymous
Not applicable

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
PA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are Your Ready?

Test your skills now with the Cloud Skill Challenge.

Top Solution Authors
Top Kudoed Authors
Users online (84,039)