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 / Create a simple table ...
Power Automate
Answered

Create a simple table from a sharepoint list

(0) ShareShare
ReportReport
Posted on by 23

Hello,

 

I am new in using Power Automate and have to say it is very helpful and beneficial to our organization.

 

I just one have question and would like to know if it is possible.

 

So I sharepoint list / Powerapps that has these data

 

- Requestor (the one who submitted a form through Powerapps)

- Request item 1 

- Quantity 1 

- Request item 2 

- Quantity 2

and the columns go until Request 5 and quantity 5

 

I am trying to fire an email to the requestor as confirmation that his request has been received like this:

 

"Hello (user),

 

Your request has been received and for your reference, here is the summary:

 

**Insert table where the above data can be found which I have no idea how**"

 

Can somebody help how is this possible? Thank you very much in advance.

Categories:
I have the same question (0)
  • abm abm Profile Picture
    32,985 Most Valuable Professional on at

    Hi @julleus21 

     

    Here it is

     

    image.png

     

    Thanks

  • julleus21 Profile Picture
    23 on at

    Hello @abm ,

     

    Thanks for your quick response and help. Seems like it gives the capability to create a table, but how can I update the row? 

     

    The table should be like this

     

    RequestQty
    Request 1Qty 1
    Request 2Qty 2
    Request 3Qty 3
    Request 4Qty 4
    Request 5Qty 5

     

    In the sharepoint list, it is only under in 1 column which looks like this

    IDRequestorRequest 1Qty 1Request 2Qty 2Request 3Qty 3

     

    Sorry if I am not able to explain myself but hope you get the idea.

     

    Thanks.

     

  • Verified answer
    abm abm Profile Picture
    32,985 Most Valuable Professional on at

    Hi @julleus21 

     

    Basically you are trying to split the list item rows into multiple rows with Request and Qty. Only way you could achieve is construct a compose with HTML syntax and dynamic mappings of your SharePoint list item results. Append the compose output to a string and finally map the new string value which contains the HTML table and dynamic values in your mail body.

     

    Please see this blog using Join.

     

    https://sympmarc.com/2019/07/25/building-nice-html-output-for-tables-in-microsoft-flow-emails/

     

     

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!

Congratulations to the March Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Haque Profile Picture

Haque 594

#2
Valantis Profile Picture

Valantis 328

#3
David_MA Profile Picture

David_MA 281 Super User 2026 Season 1

Last 30 days Overall leaderboard