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'),','),';#')