Answered

MS Forms to Flow - Multiple optional questions

(0) Share

Report

Posted on by lcotter

Hi,

I am using forms to create a uniform ordering form for my job. Each question is optional and I am having trouble getting my excel sheets to only list the data for the questions with responses.

I've been using a thread at Solved: MS Forms File Upload - Multiple optional questions - Power Platform Community (microsoft.com) as a reference, but I'm not sure how the OP ended up setting up the conditional

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (2)

Sort by

Verified answer

NiloferA on at

Like (0)

Report
Copy link

Link copied!

Hello @lcotter ,

The Thread you are referring is actually instructing on how you can add parallel branches for each of the question and set the condition to check if the field is empty or not and based on Yes or No you can have the rest of the actions setup.

The expression in the Condition can be like this - empty(Your field here) is equal to true (type true in expression and then press enter)

Please hit Kudos or Accept this Reply as Solution if it resolved your problem.

Was this reply helpful? Yes No
lcotter 10 on at

Like (0)

Report
Copy link

Link copied!

@NiloferA Thank you for responding so soon and for the help. Just as a followup, would you mind explaining more in detail how to put in the first part of the condition to make sure it's connected with the question I want to check in the form?

Was this reply helpful? Yes No
Verified answer

NiloferA on at

Like (0)

Report
Copy link

Link copied!

Hello @lcotter ,

After adding the condition, click on the left side of the condition, Dynamic Content Popup will open up. Click on Expression, then type in empty(), then place your cursor between the parentheses go back to Dynamic Content, select your question and then click on ok.

You can share a screenshot of what you are doing here so I can help you better.

Was this reply helpful? Yes No
lcotter 10 on at

Like (0)

Report
Copy link

Link copied!

@NiloferA Thank you so much for explaining the left side of the condition! It worked perfectly 🙂

Was this reply helpful? Yes No
NiloferA on at

Like (0)

Report
Copy link

Link copied!

Hello @lcotter ,

That's great! Please Accept the Reply as a Solution to close this thread and help others find it! 🙂

Was this reply helpful? Yes No