Answered

When sending email in power app, I'm unable to capture the text values from the app in email

(0) Share

Report

Posted on by itchel123

I have a power app that connects to a SharePoint list and Outlook. I've created the app as a blank canvas app. I'm able to save the values from the app back into the SharePoint list. Now, I would like to send an email with those values included. The app sends an email as expected, however, the value from txtPhone.Text is not captured in the email. What am I doing wrong? Below is the code.

SubmitForm(Form); Office365Outlook.SendEmailV2( "my email address", "my Subject", "Test: "&txtPhone.Text ); Navigate( ThankYouScreen, ScreenTransition.Fade )

Categories:

Building Power Apps

I have the same question (0)

All responses (8)

Answers (1)

Verified answer

Fredrik_A 3,403 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

The txtPhone.text value will be reset after the "SubmitForm", try sending the email first, and then submitting 😃

Was this reply helpful? Yes No
Fredrik_A 3,403 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Or you can save the last submit in the OnSuccess of your form, such as:

Set(varLastItemSubmitted, Self.LastSubmit)

Was this reply helpful? Yes No
itchel123 46 on at

Like (0)

Report
Copy link

Link copied!

Hi @StretchFredrik ,
I'm new to Power Apps so I'm still learning how to navigate the app. Where is the OnSuccess in my form? Do I need to create the variable first before setting it? If so, where? Is Self.LastSubmit the name of the submit button?

Was this reply helpful? Yes No
Fredrik_A 3,403 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

You don't need to create the variable, just put it such as the image 😃

You can then get the phonenumber using varLastItemSubmitted.ColumnName

Was this reply helpful? Yes No
itchel123 46 on at

Like (0)

Report
Copy link

Link copied!

Thank you.

I have multiple columns that will need to be included in the email. Would this solution work for multiple fields?

Was this reply helpful? Yes No
Fredrik_A 3,403 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Yes, just use varLastItemSubmitted.ColumnName for each of the fields needed 😃

Was this reply helpful? Yes No
itchel123 46 on at

Like (0)

Report
Copy link

Link copied!

When you say, "You can then get the phonenumber using varLastItemSubmitted.ColumnName, does this mean that the code will be like below?

SubmitForm(Form); Office365Outlook.SendEmailV2( "my email address", "my Subject", "Test: "&varLastItemSubmitted.ColumnName); Navigate( ThankYouScreen, ScreenTransition.Fade )

Was this reply helpful? Yes No
Fredrik_A 3,403 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

You need to replace .ColumnName with your actual name in your datasource that holds the PhoneNumber for example.

So you could write for example varLastItemSubmitted.Title to get the title of the item.

Was this reply helpful? Yes No