cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
jcarter13
New Member

How to remove form responses that are blank

I have a MS Form in a flow such as below. However, there is a lot of branching logic within the Form. So, I don't want all available options to show up in my PDF/email of the form responses, because they were not answered, due to the branching logic of the form. Is there a way to somehow either (1) not include form responses that are blank/empty/null OR (2) create flow that only takes fields with an answer?

jcarter13_1-1644417091994.png

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
v-LilyW-msft
Community Support
Community Support

Hi @jcarter13 

If you want to judge whether to show this question according to the value of response, you can try to use IF function. I set up a simple flow, you can refer to following screenshots.

This is my test Form:

vLilyWmsft_2-1644555697040.png

Suppose I want to decide whether this question is displayed or not based on whether question 2 and question 3 have a value.

Flow in details:

vLilyWmsft_0-1644556054117.png

Expression1:

if(empty(outputs('Compose_1')),null,concat('Reason for liking?:',outputs('Compose_1')))

Expression2:

if(empty(outputs('Compose_2')),null,concat('Reason for dislike?:',outputs('Compose_2')))
vLilyWmsft_2-1644556199251.png
vLilyWmsft_5-1644556665109.png

When a new Form is submitted like below:

vLilyWmsft_0-1644555572622.png

I will receive an email without question 3.

vLilyWmsft_4-1644556308169.png

Best Regards,

Community Support Team _ Lily
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

1 REPLY 1
v-LilyW-msft
Community Support
Community Support

Hi @jcarter13 

If you want to judge whether to show this question according to the value of response, you can try to use IF function. I set up a simple flow, you can refer to following screenshots.

This is my test Form:

vLilyWmsft_2-1644555697040.png

Suppose I want to decide whether this question is displayed or not based on whether question 2 and question 3 have a value.

Flow in details:

vLilyWmsft_0-1644556054117.png

Expression1:

if(empty(outputs('Compose_1')),null,concat('Reason for liking?:',outputs('Compose_1')))

Expression2:

if(empty(outputs('Compose_2')),null,concat('Reason for dislike?:',outputs('Compose_2')))
vLilyWmsft_2-1644556199251.png
vLilyWmsft_5-1644556665109.png

When a new Form is submitted like below:

vLilyWmsft_0-1644555572622.png

I will receive an email without question 3.

vLilyWmsft_4-1644556308169.png

Best Regards,

Community Support Team _ Lily
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Users online (3,964)