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.