Skip to main content

Notifications

Power Automate - General Discussion
Unanswered

Display CSV Table in Approval flow markdown

(0) ShareShare
ReportReport
Posted on by 11

Hi folks,

 

I am trying to display info from csv output in the body of the Approvals action. (I have to use Approvals and not Send an email with options as I need to track comments aprovers and response times etc.)

Is there a way to split the csv back output in to items, rather than as a single string?

 

Here's what I have:

 

csvoutput.PNG

 

 

1. is the straight CSV output (and this would be perfect if I could split dog & cat onto their own rows...(imagine a list of 25 employees here) like this:
dog

cat

 

2. was my attempt at using the output from Create HTML Table     😞

3. was my attempt at using a string variable with a <br/> tag to split the items.

 

I have also tried using the double spaces for new lines - all to no avail in markdown.

 

Any workarounds would be much appreciated.

 

My select action looks like this for moment
selectapproval.png

 

 

 

  • efialttes Profile Picture
    efialttes 14,756 on at
    Re: Display CSV Table in Approval flow markdown
    Hi
    Let's imagine you assign the string "dog cat" to a variable called 'currentCSVoutput' and lets assume also the separator between elements is a single space, lets assume finally no element contains spaces
    If so, you can use the following expression to convert it into an array:
    split(variables('currentCSVoutput'),' ')
    Once you have an array you should be able to represent it as you are looking for
    Hope this helps
  • lvdp Profile Picture
    lvdp 11 on at
    Re: Display CSV Table in Approval flow markdown

    Thanks for the link, but I'm stuck on the step where I need to split the CSV output into a table. At present the csv out put puts dog and cat (rows in the source spreadsheet) into a string.

     

    dog cat

     

    What I need is to list them each on separate rows (not necessarily in a table - a list is fine) - how do I split the output to put a line wrap in so the display as:

     

    dog

    cat

     

     

  • efialttes Profile Picture
    efialttes 14,756 on at
    Re: Display CSV Table in Approval flow markdown

    Good news!

     

    According to official Microsoft documentation, Power Automate Approvals support markdown syntax features, including tables:

    https://docs.microsoft.com/en-us/power-automate/approvals-markdown-support#tables

     

    Hope this helps

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,304

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,703

Leaderboard