Answered

How to split column value and create two new column for excel using Power Automate?

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi,

Currently I am trying to split a column from excel file called "Test". Within the column "Test", there are values of string contain something like this - "X=12345;Y=67890;" I would like to split X and Y into two separate table of its own value inside excel. How can I achieve this using Power Automate to create the flow? The table below look something similar to what I am trying to achieve.

Names	City	Test
John Doe	New York	X=12345;Y=67890;
Jane Doe	Seoul	X=19273;Y=06948;
Mary Jane	Kuala Lumpur	X=06847;Y=58672;
Peter Johnson	Auckland	X=37465;Y=29486;

Please advise.

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (1)

Verified answer

abm abm 32,981 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

Hi @Anonymous

You need to use the split expression to split the values.

Above expressions are as follows:

split(outputs('Compose'),';')[0]

split(outputs('Compose'),';')[1]

Thanks

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @abm

Once you have Compose the split function, how do you create two new column to put those values into it?

Best regards
devaaron

Was this reply helpful? Yes No
abm abm 32,981 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

You need to have two columns before hand in your Excel sheet. Once the flow reads each row then you can use the update row action, for this you need an identifier as one of your columns.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Is it possible to create a new column using Power Automate Flow instead of having to create two new column before hand?

Was this reply helpful? Yes No
GeoffRen Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Take a look at the 'Add a Key Column` action.

Was this reply helpful? Yes No