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.
Check out the new Process Advisor community forum board!
Check out new user group experience and if you are a leader please create your group
Participate in the Power Virtual Agents Community Challenge
Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.