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

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
efialttes
Super User
Super User

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

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

 

 

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
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

Power Automate Designer Feedback_carousel.jpg

Help make Flow Design easier

Are you new to designing flows? What is your biggest struggle with Power Automate Designer? Help us make it more user friendly!

Users online (1,834)