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 / Create a table with on...
Power Automate
Unanswered

Create a table with one column with rows of multiple sharepointlist column value

(0) ShareShare
ReportReport
Posted on by 62

I would like to create one column excel table in which its rows are different column value of a sharepoint list

Categories:
I have the same question (0)
  • grantjenkins Profile Picture
    11,063 Moderator on at

    @PowerApps999 Are you able to be a bit more specific - maybe provide an example of what you want the output to look like. Including the column type (single line of text, choice, etc. and if choice do you have multiple choices).

     

    Also, do you already have an Excel file with a Table and you just want to add the rows of data, or do you need to create a new Excel file, create the Table and add the rows as part of the flow?

     

    Also, how many rows of data are you expecting to be added to the Table?

  • PowerApps999 Profile Picture
    62 on at

    @grantjenkins 

    Below is my sharepoint list which has separate columns 

     

     

    PowerApps999_0-1697955639587.png

    I would like to bring the above columns value to the excel below from F7 to F15 as 7 rows in a single column. This excel is generated as new excel (where the single column should be made) from a template excel when the flow is triggered

     

    PowerApps999_1-1697955736968.png

     

  • Verified answer
    PowerApps999 Profile Picture
    62 on at

    Found out on how to do it. First change it to a table and add a column to map the row location. Use 'Update a row' function for excel business and type in the table name, column name of the mapping column and its key value. An option for provide information then appears and enter there the desired column name where we need to the row to be updated in array format.

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
Michael E. Gernaey Profile Picture

Michael E. Gernaey 522 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 364 Moderator

#3
abm abm Profile Picture

abm abm 243 Most Valuable Professional

Last 30 days Overall leaderboard