cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
sjehanzeb
Level: Powered On

Get Items from Sharepoint and Create a Markdown Table

Hi

I have a multi-step approval process which records each activity of approval process on a sharepoint list. 

I want to share that list with every other approver so he/she knows that happened earlier on this request. I am able to get the list of activity through getItems but showing in the approval markdown language gets tricky. i tried create html table and create csv but the output is not readable. Can this array be converted to Markdown table

 

flow1.PNGCreate SCV

1 ACCEPTED SOLUTION

Accepted Solutions
sjehanzeb
Level: Powered On

Re: Get Items from Sharepoint and Create a Markdown Table

Found a solution myself. html table didn't work as I needed the markdown table for approvals

 

1. Create CSV table without headers and with an additioal delimeter i.e. | seperately value

flow1.PNG

 

2. Included header in the markdown format in approvals details

flow2.jpg

 

3. use replace command to change commas to delimiter i.e. |

replace(body('Create_CSV_table'),',','|')

View solution in original post

3 REPLIES 3
Community Support Team
Community Support Team

Re: Get Items from Sharepoint and Create a Markdown Table

 

Hi @sjehanzeb ,

 

Unfortunately, as far as I know, Mark down table in Approval email needs to manually populate the data for configuration and follow the specified format.

I am afraid there is no suitable method to achieve this through the output of Create CSV tale.

As an alternative, please try to create an HTML table using Send an email with options action and populate the HTML table directly in the email body.

Please take a try.

 

Best Regards,

Community Support Team _ Barry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
sjehanzeb
Level: Powered On

Re: Get Items from Sharepoint and Create a Markdown Table

Found a solution myself. html table didn't work as I needed the markdown table for approvals

 

1. Create CSV table without headers and with an additioal delimeter i.e. | seperately value

flow1.PNG

 

2. Included header in the markdown format in approvals details

flow2.jpg

 

3. use replace command to change commas to delimiter i.e. |

replace(body('Create_CSV_table'),',','|')

View solution in original post

Veelox_Incident
Level: Powered On

Re: Get Items from Sharepoint and Create a Markdown Table

Hi sjehanzeb,

 

This has helped tremendously but for some reason, the table fails to show my date value.  Any advice?  It works if I leave the | off the last line of the table.

 

I found the issue. My table needed a | at the beginning as well so that it could complete it.  It was whatever my first field was that didn't populate correctly.

 

THANKS AGAIN!

 

 

EDIT: Now It's pushing everything over one column.  So I can't get it to line up.  Any suggestions?

Helpful resources

Announcements
firstImage

Power Platform Online Conference

Speakers, submit your sessions now! Call for speakers ends Feb. 10!

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

firstImage

Incoming: New and improved badges!

We've given our badges an overhaul and also added some brand new ones!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

Top Solution Authors
Top Kudoed Authors (Last 30 Days)
Users online (5,584)