Create HTML Table from SharePoint List using Cloudflows - CloudFronts

Create HTML Table from SharePoint List using Cloudflows

Posted On August 6, 2021 by Rilsina Pegado Posted in 

Introduction:

In this blog we are going to see how we can create an HTML Table from SharePoint List.

Here is an example of SharePoint List.

Communication site 
Site contents 
Edit 
+ New 
Home Documents 
Edit in grid view 
Pages 
Share 
My List 
Export v Automate v Integrate v 
My List 
Name •v, 
- Dave Rodrigues 
- John Samson 
Cliff Dsouza 
- Shanice Peter 
- Rhea Aaron 
Skills 
Power Platform 
0365 CE 
power 31 
Field Service 
Customer Service 
Add column v

Solution:

You can trigger the flow as per your requirment.

Also, in this example I am retrieving all items in the list, there are filter options avaliable.

Use action: Get Items

Get items 
• Site Address 
List Name 
Limit Entries to Folder 
Include Nested Items 
harepoint.com/ 
My List 
Select a folder, or leave blank for the whole list 
Return entries contained in sub-folders (default true) 
Show advanced options v

We will first initialize an array variable and then append all list values to array variable in loop.

{x} 
Initialize variable 
• Name 
• Type 
Value 
Apply to each 
Table Content 
Array 
Enter initial value 
Select an output from evious st 
value x 
{x} 
Append to array variable 
O 
Name 
• Value 
Table Content 
"Name":" 
"Job Title•:•'

Finally we create an HTML Table from the Array.

Create HTML table 
• From 
• Columns 
Table Content x 
Automatic 
Hide advanced options A

Conclusion: As per your requirment, you can populate the values in document instead of creating HTML table. Send the HTML table or Word Document in Email.


Share Story :

Secured By miniOrange