cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

Check on empty choice field Form

I am using a Form with questions where you could select an answer (option button).

I am writing these answers in a Sharepoint list with Flow.

 

Now my problem is when someone update one answer, Flow is writing an empty string in the SP list for all other answers.

 

How could i check if an selection is made? What is the default value from selection in Form? for sure it isn't null.

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Support
Community Support

Re: Check on empty choice field Form

Hi @GeorgeClooney ,

 

Please modify the Condition to below then yourproblem could be solved:

empty(outputs('Compose'))

1.png 

Please let me know if your problem could be solved.

Best regards,

Alice       

 

Community Support Team _ Alice Zhang
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

9 REPLIES 9
Highlighted
Super User III
Super User III

Re: Check on empty choice field Form

@GeorgeClooney 

You can use an expression and check for a null value - see my screen shot below.  My option column is titled OptionCol.  My expression is in the comments area.

NullOption.jpg

 

You could also use a similar expression when doing the create or update item in SharePoint - use an if expression and check for null values in the expression window for each column.

 

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Scott
Highlighted
Frequent Visitor

Re: Check on empty choice field Form

Thank you for your answer Scott,

 

Could you please tell me how i get the name of the option column from the MS Form response?

Highlighted
Super User III
Super User III

Re: Check on empty choice field Form

@GeorgeClooney :

You'll reference all values form the Form via Dynamic properties - see my screen shot below.

One correction - I forgot that this was coming from Forms.  To check for a null value, use two single quotes '' rather than the null operator.

NullFormOption.jpg

 

If you are still having issues, please post a screen shot of your Flow.

 

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Scott
Highlighted
Community Support
Community Support

Re: Check on empty choice field Form

Hi @GeorgeClooney ,

 

You could also add a Compose under the "Get response details" action, and insert the choice field dynamic content in the Compose action.

1.png

Best regards,

Alice       

 

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

Highlighted
Frequent Visitor

Re: Check on empty choice field Form

Hi Alice,

 

It isn't still working. The condition is always true when the first part is true. Herewith a screenshot of the specific Form option question and a screenshot of my flow.

 

Thank you for your support.

 

Form questionForm questionFlowFlow

Highlighted
Super User II
Super User II

Re: Check on empty choice field Form

Hey, what if you use length() to count the length of the form input? i.e. length(body('Compose')) is greater than 0

Highlighted
Frequent Visitor

Re: Check on empty choice field Form

Sorry Gristy isn't working. Getting the following message

 

Error MessageError Message

 

 

Highlighted
Community Support
Community Support

Re: Check on empty choice field Form

Hi @GeorgeClooney ,

 

Please modify the Condition to below then yourproblem could be solved:

empty(outputs('Compose'))

1.png 

Please let me know if your problem could be solved.

Best regards,

Alice       

 

Community Support Team _ Alice Zhang
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

Highlighted
Frequent Visitor

Re: Check on empty choice field Form

Hi Alice,

 

Thank you very much for your support!

 

have a great day

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

Tech Marathon

Maratón de Soluciones de Negocio Microsoft

Una semana de contenido con +100 sesiones educativas, consultorios, +10 workshops Premium, Hackaton, EXPO, Networking Hall y mucho más!

Users online (6,499)