Answered

Unable to display user input in the email notification

(0) Share

Report

Posted on by Community Power Pla...

I am using SharePoint list for the Office 365 connection to sending a confirmation email to the user once a new request is submitted.

Email works fine but unable to display the entries to the email body.

If(
!Form1.Valid, SubmitForm(Form1),
SubmitForm(Form1);
Navigate('Thank you');
Notify(
"Submitted new record.",
NotificationType.Success
),
Office365.SendEmail(
User().Email,
"Intake Form - Submission Confirmation : " & DataCardValue1.Text,
"Hi " & Left(
User().FullName,
Find(
" ",
User().FullName
) - 1
) & "," & " 
Thank you for your submission." & " " & "We will review and respond no later than two (2) business days. " & " Please feel free to reach out to @abc@XYZ.com if you have any questions. " & " Thanks!" & " -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------" & " Project Name : " & DataCardValue1.Text & " PR # : " & DataCardValue3.Text & " Business Group : " & DataCardValue12.Text & " Third Party Supplier : " & DataCardValue7.Text & " Brief Description : " & DataCardValue8.Text & " Notes : " & DataCardValue10.Text & " ",
{
IsHtml: true,
Importance: "Normal",
Cc: "SP@XYZ.com"
}
)
);

Categories:

Building Power Apps

I have the same question (0)

All responses (9)

Answers (2)

Verified answer

yashag2255 24,769 Super User 2024 Season 1 on at

Like (1)

Report

Hi @Anonymous

This is happening because once the form is submitted, the data is wiped out of the controls. To get this content in the email, can you try to update your expression as:

If(
!Form1.Valid, SubmitForm(Form1),
SubmitForm(Form1);
Navigate('Thank you');
Notify(
"Submitted new record.",
NotificationType.Success
),
Office365.SendEmail(
User().Email,
"Intake Form - Submission Confirmation : " & Form1.LastSubmit.ColumnName,
"Hi " & Left(
User().FullName,
Find(
" ",
User().FullName
) - 1
) & "," & " 
Thank you for your submission." & " " & "We will review and respond no later than two (2) business days. " & " Please feel free to reach out to @abc@XYZ.com if you have any questions. " & " Thanks!" & " -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------" & " Project Name : " & Form1.LastSubmit.ProjectName & " PR # : " & Form1.LastSubmit.PR& " Business Group : " & Form1.LastSubmit.BusinessGroup& " Third Party Supplier : " & Form1.LastSubmit.ThirdPartySupplier & " Brief Description : " & Form1.LastSubmit.Description& " Notes : " & Form1.LastSubmit.Notes& " ",
{
IsHtml: true,
Importance: "Normal",
Cc: "SP@XYZ.com"
}
)
);

Here, the highlighted parts need to be replaced with Form1.LastSubmit.<column you want to fetch>

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

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

Like (0)

Report

Thanks so much, Yash. The suggested solution worked and I can see user input in the email.

I have a follow-up question.

Do you think using Flow is a good option instead of sending directly from PowerApps office 365 logic?

I have also tried keeping this entire email notification logic on Success instead of On Select Submit button, however getting some different error when tried changing the logic on Select. Not sure, if this is the right way to do. Please advise.

Was this reply helpful? Yes No
yashag2255 24,769 Super User 2024 Season 1 on at

Like (1)

Report

Hey @Anonymous

It depends on the usecase/ senario entirely. You can directly send the email through powerapps if there are no customizations to this email body. In case, you have such a requirement where you want to perform some operations based on user inputs, then using a flow would be better.

When you tried to use this on "OnSuccess" property, what was the error that you got? I carried out a test on my side and I am able to use the same expression on the OnSuccess property with the LastSubmit attributes.

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

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

Like (0)

Report

I found another issue with this. When the form is in edit mode, I am getting user input in the email, but the same logic doesn't work once I published. Please help with this issue.

Was this reply helpful? Yes No
yashag2255 24,769 Super User 2024 Season 1 on at

Like (0)

Report

Hey @Anonymous

Are you trying to save record in New form mode or Edit Form mode? I thing here is, you need to initialize the form state using NewForm() and EditForm(). Please share more details about the implementation, so that we might be able to help you better.

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

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

Like (0)

Report

Yash @yashag2255 ,
I have just one form New and I have used below code On Success

Form1;NewForm(Form1);
Navigate(
'Thank you',
ScreenTransition.Fade
)

And, I have set default mode to New.

Is there anything else I am missing?

Capture.PNG

Was this reply helpful? Yes No
Verified answer

yashag2255 24,769 Super User 2024 Season 1 on at

Like (1)

Report

Hi @Anonymous

Can you try to change the configs as:

OnSuccess: Navigate(
'Thank you',
ScreenTransition.Fade
)

Screen -> OnVisible -> NewForm(Form1) //This gets triggered when someone navigates to this page from other page or the page is refreshed.

Or, else you can create a button to initialize the form as:

Button -> OnSelect -> NewForm(Form1)

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

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

Like (0)

Report

Thanks Yash.
It worked.

Now, i can see the user input in the notification email.

The only other issue i can see is that email is coming from Reqester email id to the requester
Is there a way we can change From email id to something static mail id like ABC@XYZ.COM ?

Was this reply helpful? Yes No
yashag2255 24,769 Super User 2024 Season 1 on at

Like (0)

Report

Hey @Anonymous

You can only set the From address if you either have permission to send email on behalf of other user or if you have a Shared Mailbox. You can then set the From property in the SendEmail action.

Refer: https://docs.microsoft.com/en-us/connectors/office365/#send-an-email

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

Was this reply helpful? Yes No