You’re offline. This is a read only version of the page.
Announcements
6
Hello,
I recently saw a thread related to converting a sting to array which helped me a lot. However, i am not able to use that solution in this situation without creating duplicate values.
I have a list of rows in an excel table and
in each row, i have a field with multiple string values separated by ";"
what i need to do is for each row, convert this field strings to array and then
create a SharePoint list item and populate a multiple choice field using those arrays
when I use Append to array option, it works, however flow keeps appending the arrays for all rows in the table and populate them in the SharePoint record.
Can you please advise?
I am able to use the split() function in compose to get following:
I am not sure how to take this output and populate the multiple choice field when creating a list item.
Thanks in advance for your help.
Hi @rmodi
Declare a variable array data type.
Split your choice value using split() expression.
Append the array using the following format:
{
"Value":item()
}
Finally map the array value under the SharePoint Create Item action step.
Thanks
Share
Report
All responses (
Answers (
