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:
  • abm abm Profile Picture
    33,004 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
    33,004 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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Leaderboard > Power Automate

#1
Mohsin Ali Profile Picture

Mohsin Ali 389

#2
11manish Profile Picture

11manish 345 Super User 2026 Season 2

#3
M Bilal Khan Profile Picture

M Bilal Khan 308

Last 30 days Overall leaderboard