Answered

Get Items from Sharepoint and Create a Markdown Table

(0) Share

Report

Posted on by Jehanzeb

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 SCV

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (1)

v-bacao-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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,

Was this reply helpful? Yes No
Verified answer

Jehanzeb 15 on at

Like (1)

Report
Copy link

Link copied!

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

2. Included header in the markdown format in approvals details

3. use replace command to change commas to delimiter i.e. |
replace(body('Create_CSV_table'),',','|')

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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?

Was this reply helpful? Yes No