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
Process Advisor

Introducing Process Advisor

Check out the new Process Advisor community forum board!

MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Users online (45,700)