Forum Discussion

Vroomkiwi's avatar
Vroomkiwi
Copper Contributor
Jun 23, 2023

Power automate split variables into array output issue

Hi all,  I'm still newish to Power Automate and am having an issue with a flow's output. The form question being pulled from is multiple choice, so I want it to show as individual selected items in...
  • SvenSieverding's avatar
    Jun 23, 2023

    Hi Vroomkiwi 

    i am not sure what exactly you mean by "SharePoint register column".

    But i think your variable "varInjury" needs to be of type "string", not "array" and you should use the "Append to string variable" action instead of the "Append to array variable" action.

    Then you can pass a string that looks like this "Strain/sprain;#Dislocation;#Burn/scald" to your register.
    Right now you are likely passing an array that gets serialized to  ["Strain/sprain;#","Dislocation;#","Burn/scald;#"] and that looks like the problem.

    Best Regards,
    Sven

    PS:
    You don't need that loop and the "varInjury" variable.
    You are already using the "split" function to split your string into an array by the delimiter "," .

    Then you can use the "join" function to join that array back to a string using the delimiter ";#"

    join(split(outputs('Compose_-_format_Injury'),','),';#')




Resources