Sending a confirmation email after Power Apps form submission without unanswered optional questions

(2) Share

Report

Posted on by CU18020215-0

Hi everyone,

I'm currently creating a form using Power Apps and would like it to send a confirmation email to the end user after successfully submitting the form. I believe this is better done through Power Automate?

In the email, I would like for it to only include the questions and answers the user fills in. So if the user does not fill in an optional question, it shouldn't be included in the confirmation email.

I was wondering if it was possible to omit unanswered questions and how would one achieve it?

Thank you!

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (0)

David_MA 12,982 Super User 2025 Season 2 on at

Like (1)

Report

Since you ask if we think this is better done with Power Automate, my answer would be no but you and others may disagree. Since you want to e-mail the answers, I assume your form records the name of the person who submits the form.

If so, enable these options in the form settings:

This will provide you the ability to provide a customized message and allow the submitter to receive a copy of their responses. After the last question in the form, the person will be presented with this option:

However, doing this with Power Automate is also certainly possible. To handle putting only answered questions in the e-mail you can use an if(empty(... expression to check if the question has been answered. If it evaluates false, return the answer to the question, and if it evaluates true you could return '' (blank) or some other value of your choice such as 'not answered'. For example: if(empty(outputs('Get_response_details')?['body/Question1']), 'not answered', outputs('Get_response_details')?['body/Question1'])

Sorry, just noticed this will not apply as you're asking about a Power Apps form rather than Microsoft Forms.

Was this reply helpful? Yes No
Suggested answer

AllanMouraDev 142 Super User 2025 Season 2 on at

Like (0)

Report

You can send an email in your app by using Office 365 connection, like this example:

Office365Outlook.SendEmail(
emaillist (you can send to how many you want, just separate them usin ; );
"Email Topic";
"Email Body where you're going to send the data you want" ;
{
Importance: "Normal"
}
);

Was this reply helpful? Yes No
Suggested answer

Michael E. Gernaey 53,369 Super User 2025 Season 2 on at

Like (1)

Report

Hi,

Since you are looking at Power Automate, a pseudo flow would look like this. You essentially want them to see their answers., If I might also mention, they can save them themselves and review them later in addition to anything you send them.

Ok

1. You need to add the When a Form is Submitted Trigger

2. Now this part is up to you a little, because its about the format. Since the Form is designed by you, you would know what Questions exist. So you could simply create a flow that checks each Value to see if its ull and if its null do NOT output anything.

But format wise, do you care if its a HTML Table format, or do you care if its just a single string, or with carriage returns but not an html Table etc.

Example 1. This shows all the answers just carriage returned. Doesn't care if its answered or not. Its near 100% the same as example 2, except it doesn't show unanswered

I removed my email, but you can see some items have "rows": but not data

Now let's make sure that we see it in another form, that you asked about.

Now if you look at the Get Response details, you can see that it creates a simple JSON that has the ID's that represent the question and the answer. The issue being that you see a GUID (the answer ID), not the string

{

  "responder": "Michael@gernaey.com",

  "submitDate": "2/19/2025 7:39:39 PM",

  "raf78f0e382484a8fa9f1d36096350ea7": "OK",

  "r43276c9ec1e04775bcf6d90329fc3e74": "",

  "r94402850cc3a418f878b0f01beeedd91": ""

}

Just as a little more details.

I added another question, but in the UI itself, Its in slot 3, but it shows up in slot 4, which means whenever you add more questions, they go on the end of the json (so in order of being added to the form, NOT in the actual order it is ON the Form itself)

{

  "responder": "Michael@gernaey.com",

  "submitDate": "2/19/2025 7:51:52 PM",

  "raf78f0e382484a8fa9f1d36096350ea7": "OK",

  "r43276c9ec1e04775bcf6d90329fc3e74": "",

  "r94402850cc3a418f878b0f01beeedd91": "",

  "r7bcb4181a0d2463a8a45deb121d61378": "dfdf"

}

So, the order of the Questions, in this JSON answers are always based on the order they were added to the Screen which is important.

You are going to need to look at using as Compose method, to do something like use Coalesce function to check if its value is null/blank/"" etc and passing nothing back for that question.,

Was this reply helpful? Yes No