cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
devaaron
Helper III
Helper III

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

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.

 

NamesCityTest
John DoeNew YorkX=12345;Y=67890;
Jane DoeSeoulX=19273;Y=06948;
Mary JaneKuala LumpurX=06847;Y=58672;
Peter JohnsonAucklandX=37465;Y=29486;

 

Please advise.

1 ACCEPTED SOLUTION

Accepted Solutions
abm
Super User III
Super User III

Hi @devaaron 

 

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

 

image.png

 

Above expressions are as follows:

 

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

 



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blogPower Automate Video Tutorials

View solution in original post

5 REPLIES 5
abm
Super User III
Super User III

Hi @devaaron 

 

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

 

image.png

 

Above expressions are as follows:

 

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

 



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blogPower Automate Video Tutorials

View solution in original post

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

abm
Super User III
Super User III

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.



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blogPower Automate Video Tutorials

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

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

Helpful resources

Announcements
Process Advisor

Introducing Process Advisor

Check out the new Process Advisor community forum board!

MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

V3_PVA CAmpaign Carousel.png

Community Challenge - Giveaways!

Participate in the Power Virtual Agents Community Challenge

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Users online (3,715)