Power Automate Sequential Approvals 

I really hope Microsoft addresses this and adds a simple action. Watching the video multiple times to learn what tables you're touching and guessing the expressions used, it still takes 13 additional actions and a premium license just to create a 2 stage approval manually in Flow. This makes me want to go back to creating a task list in SharePoint and use Adaptive Cards instead. I have some many users that just need some basic approvals but get frustrated when I say "sorry, as a site admin you have no power to reassign or cancel or manage in-progress approval tasks. And they time out after 29 days".

Thanks for the feedback. I'll try to remember when recording next videos 😜

@@pbehler Just as an inspiration: We have an special admin (Approval Admin) which we include in every approval workflow we create - so in case someone is out of office and the approval needs to be reassigned, we use this user (login & reasign).

Good luck! :)

All these new tables look like the back end for the promised functionality from MS doesn't it.

They do, indeed. And the functionality was meant to arrive in July. There's still some time left, so I keep my fingers crossed.

Exactly. It returns information about the owner.

What exactly is unclear?

@@TomaszPoszytek I figured it out :) Had to experiment a bit and rewatch several of your videos plus some other videos on the Approval dataverse structure (thanks for that) An interesting scenario that I implemented in the end was that I only create the initial Approval request via the standard action for the Step 1 approvers and then I manually create steps/approval requests for step 2/3 etc. Thus, only the initial approvers get an email + teams notification and not everyone in the approval sequence. One watchout there is to check whether each approver added via the Dataverse table has access to the security group. But all worked out in the end pretty well. I also prefer not to use Wait for approval task but put a trigger on the Approval table and just run a separate flow when the approval is Complete. It avoids long-running flows and makes it somehow cleaner. Thanks again for all your effort and explanations

@@IvanTretyakov i am happy you figured that out. Indeed, your scenario is interesting. I also understand, why you are not a big fan of "wait action". Good luck!

Hey, in this case I would rather recommend to use the simple "Post adaptive card" action, without waiting, and then to build another flow that is triggered with the "when someone responds to an adaptive card" trigger. Learn more here: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-2ZHv0l_6W5Q.htmlsi=NbTPlxi6mYr2QLaI

Sure, the same way as using Power Automate. You need to perform patches on Approvals tables.

@@TomaszPoszytek Could you list the table names where I have to perform the patches ?

Could you elaborate a little on it? What should happen to the other cards?

@@TomaszPoszytek Scenario is Sent Approval to Multiple User through adaptive but first who responded to adaptive card only take that response rest of all will be decarded

It's difficult to say. Maybe user is missing security roles? As a side note - I heard this feature should be officially available in Power Automate end of this month, or early next.

@@TomaszPoszytek Unfortunately, it seems Microsoft still has not brought it publicly available. Can you confirm the solution still works on your side?

Hey @@davidzhang7455 - it only works in Microsoft Teams as of today. I don't have it in Power Automate either.

Oh, I haven't noticed that. Where have you found this information?

@@TomaszPoszytek it was removed after some delays from the roadmap - and no word from Microsoft.

Hey, it's just an entry in the Steps table, with guid to Approval and lookup to that model record created inside the previous action.

@@TomaszPoszytek I am new to Power Automate and I need exactly the same implemented. If you have any blog or detailed article to this. I will be greatfull. Video is quite fast and I am not able to understand completely. Thanks

@@homeostore same here

@@TomaszPoszytekwhat you said is last road block I have, after many repeating errors. How input the ‘step model’ parameter in ‘creating step record’ can link back to ‘basic model data’ record? My ‘create step record’/Step Model’ parameter = concat('msdyn_flow_basicapprovalmodel(',outputs('Create_record_in_Basic_Approval_Model_Data')?['body/msdyn_flow_basicapprovalmodelid'],')'). But didn’t work, appreciate help for this😂