cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Frequent Visitor

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

 

Create SCVCreate SCV

1 ACCEPTED SOLUTION

Accepted Solutions
Frequent Visitor

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
Community Support

 

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.
Frequent Visitor

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

Anonymous
Not applicable

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
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

MPA Community Blog

Power Automate Community Blog

Check out the community blog page where you can find valuable learning material from community and product team members!

Top Solution Authors
Top Kudoed Authors
Users online (8,864)