cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
julleus21
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
abm
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 blogPower Automate Video Tutorials

View solution in original post

3 REPLIES 3
abm
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 blogPower Automate Video Tutorials
julleus21
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.

 

abm
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 blogPower Automate Video Tutorials

View solution in original post

Helpful resources

Announcements
MPA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

V3_PVA CAmpaign Carousel.png

Community Challenge - Giveaways!

Participate in the Power Virtual Agents Community Challenge

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

R2 (Green) 768 x 460px.png

Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.

Users online (1,803)