Formatting an HTML table attached to an approval

Like (0) Share

Report

Posted on 28 Aug 2020 19:09:41 by KBeale

312

I'm working on an approval where I need to send all previous requests from the requestor to the approver. I'm resigned to the fact that I can't pull data from a list and get it into a table and then into the body of the approval in a useful format 😞 but I'm wondering if there's any way to improve the formatting of an attached table. A screenshot of how it looks now is below. I've tried various options using the Format table action and gotten nowhere. Even adding borders would be a big improvement. Any advice? Thanks in advance!

Screen Shot 2020-08-28 at 10.05.02.png

I have the same question (0)

All responses (9)

Answers (1)

CFernandes 8,305 Most Valuable Professional on 16 Sep 2020 at 09:55:39

Like (1)

Report

Re: Formatting an HTML table attached to an approval

@KBeale I am glad that my inputs helped! 🙂

Was this reply helpful? Yes No
KBeale 312 on 16 Sep 2020 at 09:30:47

Like (0)

Report

Re: Formatting an HTML table attached to an approval

Thanks! And done! 🙂

Was this reply helpful? Yes No
Verified answer

CFernandes 8,305 Most Valuable Professional on 16 Sep 2020 at 09:09:41

Like (2)

Report
Re: Formatting an HTML table attached to an approval

@KBeale

A very easy way to add borders to the HTML will be to add a compose action and put in the formula

replace(body('Create_HTML_table'),'<table>','<table border="1">')

On a side it will be great to Have HTML support in the Approval action, Please Upvote the idea https://powerusers.microsoft.com/t5/Power-Automate-Ideas/Approval-Email-HTML-Instead-of-Markdown/idi-p/291703

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

Was this reply helpful? Yes No
KBeale 312 on 16 Sep 2020 at 08:13:29

Like (0)

Report

Re: Formatting an HTML table attached to an approval

What I would like to do is provide the approver with all previous requests from the requestor who fills out the form that triggers my flow. Responses to the form populate a list, which I pull the previous responses from. I'm adding them to an html table, which I then attached to the approval. I've included the relevant steps in screenshots below. I would love to include the information in the HTML table in the body of the approval, but there doesn't seem to be a way to do that in an approval (unlike in an email), so I'm hoping to at least make the attached table look a bit better. Thanks for your help!

Was this reply helpful? Yes No
PrasadAthalye on 15 Sep 2020 at 15:26:58

Like (0)

Report

Re: Formatting an HTML table attached to an approval

Are you looking for creating a new file using that content that you would like to attach to approval action?

Was this reply helpful? Yes No
KBeale 312 on 15 Sep 2020 at 14:47:46

Like (0)

Report

Re: Formatting an HTML table attached to an approval

I'm using it to create the table itself (screenshot of that section below), but there doesn't seem to be a way to format it as an attachment 😞 I tried the format HTLM table action, but it only seems to work when the table is in the body, which isn't an option in approvals as it is in emails.

Was this reply helpful? Yes No
PrasadAthalye on 15 Sep 2020 at 14:34:48

Like (0)

Report

Re: Formatting an HTML table attached to an approval

Thanks for the clarification. Can you please check if following helps to meet the requirement? There is a Create HTML Table option in compose...

Please like and mark this as answer if it helps to resolve your issue.

Was this reply helpful? Yes No
KBeale 312 on 15 Sep 2020 at 11:34:10

Like (0)

Report

Re: Formatting an HTML table attached to an approval

Thank you for replying, but I need to send a table with dynamic content (depending on who responds to the form that's my trigger) pulled from a list (markdown in the body only works if I know the values in advance.) Unfortunately, it seems that the only way to get that kind of an HTML table into an approval is to send it as an attachment 😞 Sorry if I wasn't clear in my initial post and please do let me know if you have any insight on formatting an HTML table sent as an attachment to an approval!

Was this reply helpful? Yes No
PrasadAthalye on 11 Sep 2020 at 00:42:18

Like (0)

Report

Re: Formatting an HTML table attached to an approval

I think you will find the answer in the below link. It explains how to use markup language in power automate html formatting...
https://docs.microsoft.com/en-us/power-automate/approvals-markdown-support

For example.. Below is how my table looks.

Please mark this as an answer if this resolves your issue.

Was this reply helpful? Yes No