cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
lvdp
Level: Powered On

Display CSV Table in Approval flow markdown

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

 

 

 

3 REPLIES 3
Highlighted
Dual Super User
Dual Super User

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



Each time you click on any of our inspiring answers 'Thumb up' icon...
...an ewok scapes from the stormtroopers.

Be grateful, Thumbs up! Save the Galaxy for free!


Escribo sobre Power Automate en:
https://medium.com/anyone-can-automate/

Proud to be a Flownaut!



lvdp
Level: Powered On

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

 

 

Dual Super User
Dual Super User

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


Each time you click on any of our inspiring answers 'Thumb up' icon...
...an ewok scapes from the stormtroopers.

Be grateful, Thumbs up! Save the Galaxy for free!


Escribo sobre Power Automate en:
https://medium.com/anyone-can-automate/

Proud to be a Flownaut!



Helpful resources

Announcements
firstImage

Incoming: New and improved badges!

Look out for new contribution recognition badges coming SOON!

firstImage

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

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

Users online (5,571)