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

Announcements

News and Announcements icon
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)
  • Suggested answer
    Michael E. Gernaey Profile Picture
    53,960 Moderator 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.
     
     
     
  • Haki500 Profile Picture
    100 on at
    Hi Mike,
     
    Thanks for your response. Let me try and get back to 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

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!

Leaderboard > Power Automate

#1
Haque Profile Picture

Haque 308

#2
David_MA Profile Picture

David_MA 256 Super User 2026 Season 1

#3
Expiscornovus Profile Picture

Expiscornovus 226 Most Valuable Professional

Last 30 days Overall leaderboard