Forum Discussion
Power automate split variables into array output issue
- 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'),','),';#')
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'),','),';#')
SvenSieverding, thank you!!
I had only been taught to do the variables as an array, but changing it to a string was so much easier.
The flow now works properly, and when it pushes to the Sharepoint List, the destination column now shows each individual selection:
Thank you for taking the time to assist me with this and teach me something new!