Changing Approver of Previously-Ran Flows

(0) Share

Report

Posted on by BP-WS

Hello,

I have a requirement to:

1. Identify all previous approval requests that were sent to 'Employee X' (former employee), using a specific Flow that is used across the business.

2. Change the approver for said flow requests to 'Employee Y'.

I've been spending some time researching and learning about the Dataverse tables that hold approval request data, which supports the approval process in Flows, but am non-the-wiser on how I can actually change the approver field, so would really appreciate some thoughts and ideas on this. I have tried to manually change the 'Owner' field within the Approval Requests Dataverse table manually, to no avail.

Would be really grateful for any suggestions or thoughts around this 🙂

Thanks,

Categories:

Building flows

I have the same question (0)

All responses (10)

Answers (0)

okeks 802 Super User 2024 Season 1 on at

Like (1)

Report

We are using it for redirecting approvals temporarily to a delegate where we just change the Owner of the Approval request and that works quiet well for us.

The only downside is that this doesn't create a new email and the delegate needs to do the approval inside Teams.

Was this reply helpful? Yes No
BP-WS 34 on at

Like (0)

Report

Hi @okeks ,

Thank you for your response, it's greatly appreciated.

Would you be so kind to send over some screenshots of how you're achieving this, as I'm not sure I understand? 🙂

Thanks,
B

Was this reply helpful? Yes No
okeks 802 Super User 2024 Season 1 on at

Like (0)

Report

I can't give you a screenshot of it as it is in our company system, but the value you need to change is the Owner of the record in the table Approval Request to /systemusers(GUID).

You can get the GUID by query the User table.

It will be different for the same user in different environments so I don't recommend using static values.

Was this reply helpful? Yes No
BP-WS 34 on at

Like (0)

Report

Hi @okeks ,

When you say to query the Users table, do you mean this table below? I cannot see any users etc within this table, which confuses me...

Thanks,
B

Was this reply helpful? Yes No
okeks 802 Super User 2024 Season 1 on at

Like (0)

Report

In the bottom is a link to load more.

The first ones are some system stuff.

Was this reply helpful? Yes No
BP-WS 34 on at

Like (0)

Report

@okeks ,

D'oh! Thanks!

So now that I can see an approver in there, how do I then find the GUID you mention? Sorry, currently a bit confused about the process you've previously described?...

Thanks,
B

Was this reply helpful? Yes No
okeks 802 Super User 2024 Season 1 on at

Like (0)

Report

If you open up the columns list of the table you always have one column of type "Unique Identifier".

The Display name is usually the same the table name.

Remember that you need the name in the second column to do filtering in the Dataverse actions of Power Automate.

Was this reply helpful? Yes No
BP-WS 34 on at

Like (0)

Report

@okeks ,

Okay, the closest I have to that in my Users table is the SYSTEM account as per below...

Please would you be able to provide more guidance on the steps I need to follow to be able to change the Owner within the Approval Request table, as I'm pretty confused with this all? 😞

Thanks,
B

Was this reply helpful? Yes No
BP-WS 34 on at

Like (0)

Report

@okeks ,

Just a bump to this - as I'd be very grateful for some additional guidance around this, as per above? 🙂

Thanks,
B

Was this reply helpful? Yes No
BP-WS 34 on at

Like (0)

Report

@okeks , I'd really appreciate any further help with this - as I still need to try and figure this out?

Was this reply helpful? Yes No