Thank you, Tomasz. I like your videos and you are a genius of Power Automate! I have successfully implemented the flow, but I found the "Get list of assigned tasks" step is useless in your demo flow context. Would you please explain a little bit about that? Thanks!
Hi @Tomasz , what are you doing in get user details , how are you getting the user details ? I mean what parameter you are filtering the table and which table ?
Thanks you Tomasz, this was amazing inspiration for a work project. One hurdle I have not been able to overcome is for a series of approvals created within a loop. Each approval is created by Create Approval and Wait for an approval steps in my flow. If there's two approvers, four rows are created in the Flow Approvals table (two with Flow Notification URIs and two without). The only difference between the two rows that have the notification URI is a parameter in the URI called repetitions with values 0000000 and 0000001. I have no way of knowing which of the two URIs to use and so I'm randomly completing the approval for the wrong approver. Hope this makes sense. Would really value any thoughts you have!
I came up with a satisfactory solution - I set the Requestor to be the user and that way I can filter the Approvals table to get the correct Approval ID.
@Tomasz Poszytek by using this approach, were you able approve/ reject the request in teams approval app?.... I can see the automate completes wait for approver action. Please can you confirm that.. I tried the same power automate runs but status in teams approval app is requested
Hi Tomasz. Is there a way to get notified about the information on whom the approval is reassigned? In "start and wait for an approval" action in Power Automate, there is only the section "Enable Reassignment".
You would need to build a cloud flow which is triggered anytime there’s a new record created in Approval Request table and that meets specific condition - e.g., has a value in „reassigned from” column etc..
@Tomasz Poszytek Thanks, Very informative video..On completing the flow through Flow URI, the Approvals Email content is updated as "Others have already completed this request". Though I have the owner name as Approver name. Do have any idea on how to change it to "You have already completed this request". Thanks
I can able to approve/reject using api flow url end point along with invoke http request in power automate. But I could not able to approve the tasks assigned to others..any suggestions on this
Amazing, great work.
Thank you, Tomasz. I like your videos and you are a genius of Power Automate! I have successfully implemented the flow, but I found the "Get list of assigned tasks" step is useless in your demo flow context. Would you please explain a little bit about that? Thanks!
This is to get information about the assigned tasks so that they can be later set as inactive. Why do you mean the step is useless?
Hi @Tomasz ,
what are you doing in get user details , how are you getting the user details ? I mean what parameter you are filtering the table and which table ?
I'm filtering Users table using email address to get user's Dataverse id.
@@TomaszPoszytek Thanks
Thanks you Tomasz, this was amazing inspiration for a work project. One hurdle I have not been able to overcome is for a series of approvals created within a loop. Each approval is created by Create Approval and Wait for an approval steps in my flow. If there's two approvers, four rows are created in the Flow Approvals table (two with Flow Notification URIs and two without). The only difference between the two rows that have the notification URI is a parameter in the URI called repetitions with values 0000000 and 0000001. I have no way of knowing which of the two URIs to use and so I'm randomly completing the approval for the wrong approver. Hope this makes sense. Would really value any thoughts you have!
I came up with a satisfactory solution - I set the Requestor to be the user and that way I can filter the Approvals table to get the correct Approval ID.
I am glad you found the solution :)
@Tomasz Poszytek by using this approach, were you able approve/ reject the request in teams approval app?.... I can see the automate completes wait for approver action. Please can you confirm that.. I tried the same power automate runs but status in teams approval app is requested
Basically, once an approval is completed using the approach described in the video, the pending approval in Teams is also shown as completed.
Thanks you Tomasz for your video. Can i download somewhere power automate flow that you show on video ? Thanks again !
Sorry, it's not available. But I'm happy to help you. Please contact me via aka.ms/poszytek
Hi Tomasz. Is there a way to get notified about the information on whom the approval is reassigned? In "start and wait for an approval" action in Power Automate, there is only the section "Enable Reassignment".
You would need to build a cloud flow which is triggered anytime there’s a new record created in Approval Request table and that meets specific condition - e.g., has a value in „reassigned from” column etc..
@Tomasz Poszytek Thanks, Very informative video..On completing the flow through Flow URI, the Approvals Email content is updated as "Others have already completed this request". Though I have the owner name as Approver name. Do have any idea on how to change it to "You have already completed this request". Thanks
You can simply design your own email after the approval is completed. But those automatic ones are not possible to change.
Great stuff. Do we need premium license to update data-verse tables? Also is it possible to provide more details in each workflow activity
Hey, thanks. Yes, you do need premium license. Speaking about details - what do you mean?
Hello and congrats for the amazing work! Could you possibly share the solution or code with the flow that complete the approval? Many thanks
Hi, you can find it on my blog ☺️
I can able to approve/reject using api flow url end point along with invoke http request in power automate. But I could not able to approve the tasks assigned to others..any suggestions on this
Why can't you approve tasks assigned to other? What do you mean?
Could I get the template for that workflow, that would be so awesome. Thanks
Sure, please reach me out through e-mail and we can discuss the details.
Where did I get the tenant id
Navigate to Azure Portal and AzureAD, it's on the overview page.