I'm working on a approval request where I need to be able include all previous requests from the requestor. I would like to include a link to a filtered view of a list (which is populated when someone fills out the Form which triggers the flow). I can add a link to a filtered view based as shown below, but it's not very useful if I have to set up the view manually (as I did here for testing).
Does anyone have any advice on how to automatically pull a filtered view based on the requestor (or in other words, show all items where value in a column in the list corresponds to the responder's email address from the form)?
Another method to achieve the same thing would also work, but I've tried using an HTML table, and it doesn't seem possible to get it into the body of an approval in a helpful format (as it is with an email) (Here's my post and the thread on that topic) and the client is not satisfied with adding it as an attachment.
Thanks in advance!
Hi @KBeale ,
First of all, in Approval email, we can only use markdown to format the email body, and HTML tags have no effect here.
Please refer to this document to get the details:
In addition, regarding the thread you mentioned, it seems to create an HTML file first, and then add it as an attachment to the Approval email. Approver needs to download the HTML file to view the filtered view.
Hope that makes sense.
Thank you for getting back to me @v-bacao-msft!
And yes, re: the other thread, that was exactly the problem, I could make and attach an HTLM file with the data I needed, but the approver would then need to download it. Since the client wasn't satisfied with that solution (it's not very intuitive or user-friendly for the approver) I was hoping to get the information in the table into the body of the approval OR link out to the same info in the form of a filtered view of a list.
Is there any way to use markdown to format the output of a Create HTML Table action so it presents correctly in the body of an approval? It wasn't clear to me how I would do so from the article you shared (thank you!), but this is all new to me, so hopefully I'm missing something. Thanks so much for your time!
Hi @KBeale ,
If you want to insert a table in the approval email body, you need to get the data first, and then present the data in the specified format, please check this link:
It looked like those instructions show how to format a specific set of items into a table? What I need, is a way to automatically format dynamic content (in this case the output from the Create an HTLM Table action, which uses a query, and will be different for each approval request) into a table. Is there a way to use markdown to do this? Thanks again @v-bacao-msft (And again, sorry if I'm missing something! ;))
Hi @KBeale ,
If so, I am afraid that relying on the existing functions in Power Automate will not be able to achieve such a demand.
Thank you! Now I can at least stop searching.. I'm working with our SharePoint team to see if we can find a way to automatically generate links to filtered views of a list, which I could then add to the approval. I'll post the solution here if we come up with a workaround!
Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.
Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!
Check out the community blog page where you can find valuable learning material from community and product team members!