cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Frequent Visitor

Create a simple table from a sharepoint list

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.

1 ACCEPTED SOLUTION

Accepted Solutions
Super User III
Super User III

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/

 

 



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog

Power Automate Video Tutorials

View solution in original post

3 REPLIES 3
Super User III
Super User III

Hi @julleus21 

 

Here it is

 

image.png

 

Thanks



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog

Power Automate Video Tutorials
Frequent Visitor

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.

 

Super User III
Super User III

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/

 

 



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog

Power Automate Video Tutorials

View solution in original post

Helpful resources

Announcements
PP Bootcamp Carousel

Global Power Platform Bootcamp

Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.

secondImage

Power Platform Community Conference On Demand

Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!

MPA Community Blog

Power Automate Community Blog

Check out the community blog page where you can find valuable learning material from community and product team members!

Users online (7,907)