web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

Welcome to the Power Platform Communities
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Split Text and get the...
Power Automate
Unanswered

Split Text and get them in different/seperate columns in data table.

(0) ShareShare
ReportReport
Posted on by suryasriram

Hello,

My question is in the image i have uploaded(list),1) i want to split the the number and the text and get them into two separate columns in a data table. The split action is not splitting the text correctly and getting them as a continuous list, which i do not want to happen. 2) Please let me know how to split the text in a way that only the number and text should be separate. tried using the space delimiter on split text action but it's splitting the text too. Please Help.

PAD.png

Kind Regards,

Surya

Categories:
General topics
I have the same question (0)
  • Nived_Nambiar Profile Picture
    Nived_Nambiar 18,136 Super User 2026 Season 1 on at

    Hi @suryasriram 

     

    see the below demo flow which helps to extract the values and put in seperate columns.

    Assume the datatable has the following structure

    Nived_Nambiar_0-1717410772616.png

     

    Column 2 and Column 3 should store number and state name respectively.

     

    Now see how the flow is designed.

     

    1. For demo purposes, I have created a datatable variable NewVar by using set variable action as shown below

    Nived_Nambiar_1-1717410835757.png

     

    2. Use another set variable action to set the row index variable initializing to zero

    Nived_Nambiar_2-1717410875395.png

     

    3. Loop through each row of datatable using for each 

    Nived_Nambiar_3-1717410899327.png

     

    Inside the loop, follow the below steps

     

    3.1- Use parse text action to get the number component from the column1 as shown below

    Nived_Nambiar_4-1717410955121.png

     

    Nived_Nambiar_5-1717410976947.png

     

    3.2- Use Replace Text action to replace the number component from column 1 value and store in new variable.

    Nived_Nambiar_6-1717411020060.png

     

    3.3- use set variable to update the column2 with number_1 and column3 with State_name as shown below

    Nived_Nambiar_7-1717411059124.png

     

    Nived_Nambiar_8-1717411076180.png

     

    3.4- use increment variable to increment rowindex

    Nived_Nambiar_9-1717411103938.png

     

     

    At the end see the datatable as shown below

    Nived_Nambiar_10-1717411124510.png

     

     

    Hope this helps !

    Thanks & Regards,

    Nived N 🚀

    LinkedIn: Nived N's LinkedIn
    YouTube: Nived N's YouTube Channel
    Blog: Nived Nambiar's Blogs

    🔍 Found my answer helpful? Please consider marking it as the solution!
    Your appreciation keeps me motivated. Thank you! 🙌

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Welcome to the Power Platform Communities

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the February Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Haque Profile Picture

Haque 283

#2
David_MA Profile Picture

David_MA 256 Super User 2026 Season 1

#3
Expiscornovus Profile Picture

Expiscornovus 225 Most Valuable Professional

Last 30 days Overall leaderboard

Featured topics

Share your ideas and struggles with building Power Automate flows!
Survey: Power Automate mobile app
How to Ask for Help with Your Power Automate Workflow
Flows are not visible for users who sign in with their personal accounts
Start and wait for an approval action
Restore a deleted flow
List of actions cheat sheet for Power Automate Desktop
Question for everyone : How are you using Create Text GPT in AI Builder?
Welcome to the Power Automate forum!

Product updates

Microsoft Power Platform Community release plans