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
Super User

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
Super User

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

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
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

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.

Microsoft Ignite 768x460.png

Find your focus

Explore the latest tools,training sessions,technical expertise, networking and more.

Top Solution Authors
Top Kudoed Authors
Users online (1,664)