0

I am rather new to Power Automate, and despite my best research efforts (including quite a bit of work with ChatGPT), I can't seem to find a solution for my problem. I am trying to set up a Power Automate flow to split an Excel row into multiple rows by delimiter. I know this is easy to do in Power Query/on Excel itself, but I'm really stuck here.

I made a test file to work through this issue, and it looks like this:

Column A Test
Name 1 Cat;Dog;Mouse
Name 2 Deer;Elk;Moose

Here is what I want the final result to look like:

Column A Test
Name 1 Cat
Name 1 Dog
Name 1 Mouse
Name 2 Deer
Name 2 Elk
Name 2 Moose

This is the current flow I have in Power Automate:

Full Flow

  1. Manually trigger a flow

2. Initialize Variable

3. List rows present in a table

4. Apply to each > body/value = (outputs('List_rows_present_in_a_table')?['body/value']

4.1 Compose (Nested within above "Apply to each") > Inputs: split(items('Apply_to_each')?['Test'], ';')

4.2 Apply to each 1 (Nested within above "Apply to each", after "Compose") > Select An Output From Previous Steps: outputs('Compose')

4.2.1 Add a row into a table (Nested within "Apply to each 1") > Selected the file and specific table from my OneDrive, no advanced parameters set.

According to ChatGPT, I should be seeing more options for 4.2.1. I am not. Currently, the flow runs, but all it does it create blank rows in my table. If anyone could help, I would greatly appreciate it! :)

Improve this question
4
  • 1
    You need to show us a screenshot of your flow. We can’t possibly tell you where you’re go wrong when you haven’t even shown us how you’re filling the table. Commented Nov 25, 2023 at 20:29
  • Just to add, this would be inefficient to do this like you have in PowerAutomate. I would suggest looking at OfficeScript to do this and then have PowerAutomate call that script on the needed file. See stackoverflow.com/questions/70111620/… to get you going. Commented Nov 27, 2023 at 6:34
  • I added photos! And I had thought about going with a script. Problem is that I have to turn off autosave to make the doc macro-enabled, and company policy is to keep autosave on whenever possible. Commented Nov 28, 2023 at 13:38
  • This set-up allows you to split a column to multiple rows without loops community.powerplatform.com/galleries/gallery-posts/… Commented Nov 4, 2024 at 2:20
Related questions
1
Power Automate to automatically refresh Excel and send emails without manual interaction
1
MS Power Automate lookup value(s) from an excel file and return a column
0
Power Automate Excel sheet name
Load 2 more related questions Show fewer related questions

0

Reset to default

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.