Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

Flow failing due to null/empty values from multiselects in MS Forms

Hi. Happy New Year.

I am having an issue with a flow that is failing whilst trying to get multiselect data that also contains null values (multi selects) from an MS Form into a Sharepoint list in an array.



I have created a resource request form using MS Forms. You can request up to 3 resources in the one form. For each resource that is being requested, there is a multiselect to capture vetting requirements.

‘Vetting Array post 1’ one is fairly straghtforward – I just convert the string into an array.

However, ‘Compose Vetting post 2’  (and ‘Compose Vetting post 3’) are more complicated (for me anyway!) as either of these could contain null/empty values.

What I would like is to have a flow that would process the multi select data into Sharepoint in an array where data exists and ignore the multiselects that have null values.

I have already referenced the article


and used the comments provided by @AlanPs1 


I modified the 'if' statement to create the following for ‘Compose Vetting post 2’:





If there is only one resource, the workflow completes successfully (including create item)









However, when I add an additional resource (‘Compose Vetting Post 2’), the output is still in a ‘String’ format:





As a result, ‘create item’ also fails.







How am I able to convert this output into an array?

Any help would be greatly appreciated.


Helpful resources

UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Top Solution Authors
Users online (1,367)