Handling empty or null values in multi-choice field

[Anonymous]

hi,

Thanks to Reza Dorrani, i finally succeeded in pulling data from a multi choice field on a form and creating the item in a SharePoint list. It works fine as long as the user makes choices but it fails on the select step with this error if the no choices are made:

"The 'from' property value in the 'select' action inputs is of type 'Null'. The value must be an array.". 

My sleect statement has this: { “Value” :“ item()“ }

Does anyone know how to solve this error? The multi choice field is not required. 

thanks,

cynthia

[v-LilyW-msft]

Hi @Anonymous 

You can add a judgment condition, if the multiple answers question has value, create an item with multiple choices in Choice column, otherwise, create an item without value in Choice column.

Please refer to below screenshots to see if it helps.

Hope the content above may help you.

Best Regards

If my reply helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Thanks @v-LilyW-msft. Since the form has numerous multi-choice fields I was hoping to avoid having to use a condition for testing as that would mean having a condition test for every multi-choice field, but if there is no other way then that's what i'll have to do. 

Do you know if there is any way to test for null in either the compose or select statement:

Just trying to keep the flow as simple as possible.

thanks again,

cynthia

[Anonymous · Accepted solution]

i found an easy solution to this:

instead of just using the outpiut from the compose action in the select action, use this:

if(equals(outputs('Compose'), null), json('[]'), outputs('Compose'))

this will evaluate the compose outputs to see if they are null. if they are, the value will be replaced with json('[]') which is valid

[v-LilyW-msft]

Hi @Anonymous 

Glad you found a solution.
If your problem has been solved, you could go ahead and mark your post as solved by clicking “Accept as Solution” so that this thread will be marked for other users to easily identify!

Best Regards.

[molinax]

Gold!