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'),',','|')

2 REPLIES 2
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'),',','|')

Helpful resources

Announcements
firstImage

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

Power Platform 2019 Release Wave 2 Plan

Power Platform 2019 Release Wave 2 Plan

Features releasing from October 2019 through March 2020.

thirdimage

Flow Community User Group Member Badge

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

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 Flow Community Video Gallery!

Top Kudoed Authors
Users Online
Currently online: 209 members 5,078 guests
Please welcome our newest community members: