cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
sjehanzeb
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
sjehanzeb
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
v-bacao-msft
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.
sjehanzeb
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
MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

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

secondImage

Are Your Ready?

Test your skills now with the Cloud Skill Challenge.

Top Solution Authors
Users online (85,173)