Create an array from excel with cells that contain comma separated values

(0) Share

Report

Posted on by schwibach

2 Moderator

Hello,

I would like to take this input from excel

and create this output in a SP list

1. manual trigger,

2. get rows from table

3. Apply to each (for every row)

4. ???

I know that 'Split' will give me an array from a string, and I can separate the content with commas.

But I don't know how to turn each of those elements into a "row" that reference in the 'Create items'-action.

5. Apply to each (for every "e-mail"-"Klassen"-combination)

6. "Create Item" (Sharepoint) inside the "Apply to each loop"

Thank you for any help you could give me to crack this.

Cheers,

Andreas

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (1)

Verified answer

Ellis Karim 11,681 Super User 2025 Season 2 on at

Like (1)

Report
Here is one approach to the problem, where we read the rows from the Excel file:
and create items in a SharePoint list:

The split expression:

split(items('Apply_to_each')?['Klassen'],',')

Below, we read the first row from the Excel file, split the Klassen string in individual classes - which is stored as an array:
Then for each class in the array (starting with 5a) we create a SharePoint list item record:
The Excel file is processed and the list items are created in SharePoint:
Hope this helps.
Ellis

Was this reply helpful? Yes No
schwibach 2 Moderator on at

Like (0)

Report

I have one more question if I may.
How did you do the screenshot of all the fields displaying the code in Power Automate?
I can only show one by hovering over it and it goes away when I try to do a screenshot.
How do you display all of them and get to do a screenshot? That would be immensely helpful.

Was this reply helpful? Yes No
Ellis Karim 11,681 Super User 2025 Season 2 on at

Like (1)

Report

Ahh! That's my secret!
I'm actually planning to provide some staff training on the Power Platform and for that I will need to produce some visual training materials. Visuals really help people to understand, absorb and retain the information - especially if Power Automate is something you only need to work with occasionally.

I have been experimenting with some simple tools and image editing software: PowerPoint, SnagIT and an image editor (eg. Paint.Net). Answering queries here on this platform helps me learn and practice new skills too.

Capturing the hover-over text is a problem and there is no magic solution. I hover over an action, capture the hover-over text (Print Screen or use SnagIT), then paste it into the image editor and crop, paste it into the main image of the flow. There is no easy way to do this. SnagIT was sometimes able to capture the hover-over text - but it's not very reliable for this. So for every hover over text, you will need to capture them one by one.

Ellis

Was this reply helpful? Yes No
schwibach 2 Moderator on at

Like (0)

Report

Thank you for the explanation.
And anothe thank you for taking the time to copy the screenshots together. It really is very helpful.

Was this reply helpful? Yes No