Unanswered

Add a link to a filtered view of a SharePoint list to an Approval (showing all previous requests from a requestor)

(0) Share

Report

Posted on by KBeale

312

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).

link to filtered view of list.png

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!

Categories:

Building flows

I have the same question (0)

All responses (7)

Answers (0)

v-bacao-msft on at

Like (1)

Report

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:

Use markdown to format Power Automate approvals - Power Automate | Microsoft Docs

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.

Best Regards,

Was this reply helpful? Yes No
KBeale 312 on at

Like (0)

Report

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!

Was this reply helpful? Yes No
v-bacao-msft on at

Like (0)

Report

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:

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

Best Regards,

Was this reply helpful? Yes No
KBeale 312 on at

Like (0)

Report

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! ;))

Was this reply helpful? Yes No
v-bacao-msft on at

Like (1)

Report

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.

Best Regards,

Was this reply helpful? Yes No
KBeale 312 on at

Like (2)

Report

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!

Was this reply helpful? Yes No
CuriosityKing on at

Like (0)

Report

Hi Kbeale,

did you find a solution in the end?

Thank you!

Was this reply helpful? Yes No