PowerAutomate Extracting out Numbers from Excel with ; Between Them

(0) Share

Report

Posted on by koneill2020

All, I am trying to in my Power Automate extract out from an Excel file this string format: 1;3;4;5;7;8;9;10;11;12;48;50 What is the best way to extract this out so that ideally in my SharePoint list it appears as:

Note: I will have may rows like this with a different set of up to 10 numbers separated by ; in the Excel file I’m getting. In my Power Automate - I've tried the following with little success:

1) Initalized the field called Choose as a String.

2) Set it as such then using a Compose Action split via the ; as such split(variables('Choose'),';')

Then I have an Apply to each on when I’m updating the list:

What happens is either the content in my list appears as [“”] or as such: ["1","3","4","5","7","10","11","12","48","50",""]

Note: in my SharePoint list I do have the data type set as a multiline text field to account for the format.

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

grantjenkins 11,063 Moderator on at

Like (1)

Report
After splitting the data, you can join it with a new line and carriage return. See expression below for the Compose Choose.

join(split(variables('Choose'), ';'), decodeUriComponent('%0D%0A'))

Full flow for this example below:

Was this reply helpful? Yes No
koneill2020 on at

Like (0)

Report

@grantjenkins - Very awesome many many thanks! Worked great.

Was this reply helpful? Yes No