Need to grab previous triggering field value and use it in my flow

[Anonymous]

I have a requirement where I need to track multiple owners for a specific record. I built a custom entity (Account/Contact Business Owner) which can track multiple owners of an Account or Contact. I built a Power Automate flow that triggers upon the "Add" or "Modify" action of the Owner field and the flow will create the Business Owner record to automatically track the user who is the new owner. 

The PA flow now needs to be modified so that when an Account or Contact Owner is modified, the existing Business Owner entity record that tracks the old owner is updated to reflect the new owner.

So if John created the Contact record, he would be listed as the Owner of the Contact and the PA flow would run and create a Contact Business Owner record with John as the Owner. But if that Contact is assigned to Jane, the PA flow would need to run and grab John's Owner record as the previous Owner and then use that guid/value to search for John's Contact Business Owner record and edit that existing Contact Business Owner record and replace John with Jane (new Owner). 

I am not sure how to grab the previous Owner since the flow runs on the modification of the Owner field so it only sees the new Owner value. If I am able to grab that previous Owner guid and store it, then I can use that variable to then search for the existing Contact Business Owner record and then replace the Owner value on that record with the new Owner (Jane). 

Any assistance would be greatly appreciated!

[v-xiaochen-msft · Accepted solution]

Hi @Anonymous ,

You could open audit for your table.

This function can save historical changes.

1\ open audit for your table.

2\ Register an azure ad app 

// You could find relevant information online.

3\ Create a flow

URI: {Your dynamic organization URI}/api/data/v9.0/audits?$filter=_objectid_value eq {record Id}

Audience: {Your dynamic organization URI}

// Other parameters are some information about your app

URI: {Your dynamic organization URI}/api/data/v9.0/audits(@{last(body('HTTP')?['value'])?['auditid']})/Microsoft.Dynamics.CRM.RetrieveAuditDetails()

The result is as follows:

Best Regards,
Wearsky
If my post helps, then please consider Accept it as the solution to help others. Thanks.

[dee2005]

@v-xiaochen-msft this is way too complicated I hope in the near future there will be an easier way to do this?

@Anonymous did you try it or maybe find a better way to get it? 😁 

I have made a request for this in Ideas, please vote and share with anyone who would be interested, help me get some votes.

https://powerusers.microsoft.com/t5/Power-Automate-Ideas/Get-Changes-for-Dataverse/idi-p/1340518

[dignus93reply]

1) I activate the audit, it seems very interesting.
2) I create the app registration and I give the api permission "user_impersonation"

3) The flow is not working, it gives me this error on the first http action:
"The user is not a member of the organization".

If I copy and past the uri of the http action on my browser i can see the audit record changing... Can you share some more details about point 2? Am I missing something?

[Anonymous]

hi ,
this is the only post on the internet which talks about this issue.
my flow ran successfully 
i tried the same to capture the old order status field..but when i change the order status
its giving me the account associated with that particular order and not the audit of the order status can you help.

[Gustavo2000]

I know that this goes back to 2021.

However, today I think I found a similar problem as described. I want to update the old value when a row is changed on my Dataverse table.

Before I start to build my Power Automate Flow, I enable the auditory on the respective environment, table, and columns. https://learn.microsoft.com/en-us/power-platform/admin/manage-dataverse-auditing

Then i started to build the Power Automte Flow:

1-Add the trigger
2- List the rows from the table Auditory, by filtering the rows where the objectid_value is equal to the id of the table trigger:

3: Then I used a compose to get the collection of all values changed. I acomplished this by following this suggestion: https://stackoverflow.com/questions/76393024/get-previous-value-of-a-dataverse-field:

4: After that, I used the Select to get only the old value provided by the collection in the image above:

5- Next, I used the Initialize Variable to store in a string form the Select Output;

6- Then I used two composes to only get the row ID of the old value changed when the trigger occurred.Compose 5: last(split(variables('To splite'),','))
Actual Id equipamento:  substring(outputs('Compose_5'),0,sub(length(outputs('Compose_5')),2))

7-Finally, I updated the row by getting the ID row from the last compose outpot, i.e., Outpot (Actual ID Equipamento'').

I hope it helps some