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

Multiple Approvers with timeout

Hello,

 

I am looking into an approval mechanism for my organization. I've researched quite a few things without any luck. 

 

TLDR; Approval of SharePoint documents, with one or more dynamic approvers, without timing out, and having individuals see other's responses prior to making their own.

 

Long version; I have a SP Document Library. I have created a Flow that can be triggered when a document is ready to be approved. This prompts the user for individuals that need to approve the document and if it has to go through one or two step approval. From @RezaDorrani's excellent videos (https://www.youtube.com/playlist?list=PLTyFh-qDKAiFUGTtwSwFT79Y7_jq_Aipe), I have created a Flow that includes: dynamics approvers, state machine, timeouts, and log history. The issue comes in when I try to look at approvals. My goal would be to send an approval, have the individuals look at history, review other's responses, and not have it timeout. I have a column in SP that updates the individuals that have not responded when the Flow times out after 29 days 😆. The Flow will rerun with the approvers in this column and keep the log history in another column. 

 

I have played around with Flow approvals, Adaptive Cards, and Actionable Messages. In each case, there doesn't seem to be a full solution. Something as simple as this would work, but triggered by Flow.

lokeshpatel_3-1633548023803.png

 

 

Flow Approvals:

Spoiler
Flow approvals shows responses of others but if there is no action in 30 days, the Flow will not record responses of others. Example of a Flow that timed out after 1 minute, but the Flow cannot add responses from approval to SP. It will also not record individuals that have responded in the output of the approval step; therefore I cannot only send the unresponsive individuals the approval again.
lokeshpatel_1-1633546932846.png

 

Adaptive cards:

 

Spoiler
I looked into adaptive cards. This might be slightly above my head so here are my thoughts. There is a new feature called Universal Action Model that displays information in Outlook and Teams but uses a bot (similar to approvals mixed with PVA). It also refreshes the content at the time of display. I tried to execute this using the adaptivecard.io designer but couldn't get V1.4 to work. I also tried to use Bot Framework Composer but was lost as well. 

https://docs.microsoft.com/en-us/adaptive-cards/authoring-cards/universal-action-model

Actionable Messages:

Spoiler
With actionable messages, you have something similar to adaptive cards and refresh with autoInvokeAction. https://docs.microsoft.com/en-us/outlook/actionable-messages/auto-invoke
I would have to invoke SP Web API. I am unfamiliar with it, so unsure if it would work. It seems like Adaptive cards is here to replace this functionality however. 

Any suggestions would be helpful! Thanks in advance!

 

1 ACCEPTED SOLUTION

Accepted Solutions
lokeshpatel
Frequent Visitor

@Cam

 

What I ended up doing was going into the dataverse and adjusting the line item of the approval. If there is no response within 29 days, I "cancel" that line item. This will update the adaptive cards on all system. If you need more details, please let me know!

View solution in original post

4 REPLIES 4
Pathosray
Frequent Visitor

I don't know if this can help but I found this video that explain how to avoid Flow's timeout.

https://www.youtube.com/watch?v=1EyuQjW8u_E

Cam
Kudo Collector
Kudo Collector

hello @lokeshpatel 

 

adaptive card v1.4 are now rendering properly in teams, when sent from Power Automate via the Flow Bot

(using the 'Post Adaptive Card and Wait for a Response' action)

 

I've not yet found a good way to update the adaptive card after the flow times out 😐
but hopefully you find a way, now that v1.4 is available in teams.

lokeshpatel
Frequent Visitor

@Cam

 

What I ended up doing was going into the dataverse and adjusting the line item of the approval. If there is no response within 29 days, I "cancel" that line item. This will update the adaptive cards on all system. If you need more details, please let me know!

hello @lokeshpatel 

 

I'm also using the the dataverse update method for cancelling approvals that have timed out.

it works quiet well 🙂

Cam_0-1642554490528.png

 

 

I'm stuck on what to do about adaptive cards though.

i assume that adaptive cards are not stored in the dataverse... so i'm unsure what to do here.

Cam_1-1642554617976.png

 

 

do you have any idea's on how to update an adaptive card that has timed out?

 

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!

Top Solution Authors
Top Kudoed Authors
Users online (1,875)