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.
Background
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 https://powerusers.microsoft.com/t5/Building-Flows/Filter-null-values-from-a-Forms-Array/td-p/254699...
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.
User | Count |
---|---|
85 | |
38 | |
23 | |
20 | |
16 |
User | Count |
---|---|
127 | |
48 | |
46 | |
27 | |
25 |