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

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Single Column to Table...
Power Automate
Suggested Answer

Single Column to Table in power Automate

(2) ShareShare
ReportReport
Posted on by 100
Hi All,
 
I been struggling to find a proper solution to make a single column value into a table and each value have its own row.
 
 
sample:
 
As you can see that the column now has all countries name, I want to convert this value into a table and each country have its own row. 
 
Is there a possibility to make that happen in power automate?
 
Seek your guidance please.
 
Location
Auckland,Bangalore,Bangkok,Beijing,Guangzhou,,Ho Chi Minh City,Hong Kong,Jakarta,Kuala Lumpur,Melbourne,Mumbai,Pasay,Phnom Pehn,Seoul,Shanghai,Singapore,Sydney,Taipei,Tokyo
Categories:
I have the same question (0)
  • Haki500 Profile Picture
    100 on at
    Hi Mike,
     
    Thanks for your response. Let me try and get back to you.
  • Suggested answer
    Michael E. Gernaey Profile Picture
    53,685 Super User 2025 Season 2 on at
    Hi,
     
    In what Back end are you looking to create it in?
     
    You can call SharePoint via HTTP to create a List and (even just use the Title Column which is there) or create a List with a Location
    Then use a simple expression
     
     
    Or you can call the API via HTTP for Dataverse and create a table and same with SQL Etc.
     
    Without knowing which one I am going to skip that part but tell you its totally doable.
     
    Now, once you create the Table and the Column the rest is simple
     
    1. Add an Apply to each action
    2. In the input put the expression split(your string, ',');
    This will create an Array that you will loop through
    then inside the Apply to Each
    Add a Create Item for SharePoint or Dataverse or SQL 
     
    Its totally doable and easy.
     
     
     

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

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
David_MA Profile Picture

David_MA 245 Super User 2025 Season 2

#2
Expiscornovus Profile Picture

Expiscornovus 207 Most Valuable Professional

#3
trice602 Profile Picture

trice602 185 Super User 2025 Season 2

Last 30 days Overall leaderboard