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.
|John Doe||New York||X=12345;Y=67890;|
|Mary Jane||Kuala Lumpur||X=06847;Y=58672;|
Solved! Go to Solution.
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.
Learn how to create your own user groups today!
Check out the new Power Platform Community Connections gallery!
Congratulations, the new Super User Season 2 for 2021 has started!
Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.
Explore the latest tools,training sessions,technical expertise, networking and more.