web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate Column change for Data...

Power Automate

Unanswered

Column change for Dataverse column

(0) Share

Report

Report

Posted on by Tango

1,168

Hi,

I have a use case where I would like to add a note every time a choice column changes values.

This note would simply need to say Quote Stage gas changed from <previous value> to <New Value>

At this point I'm trying to get my head around where I might get the old value from?

Thanks in advance

Todd

Categories:

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (0)

Expiscornovus 33,846 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hi @Tango,

This sounds a lot like auditing. Can't you simply use the Audit feature for this instead?

https://learn.microsoft.com/en-us/power-platform/admin/manage-dataverse-auditing

If for some reason you still want post this separately as a note you could still reuse that auditing feature as well. Just retrieve the details from the Audits table via a List rows.

Below is an example with the Accounts table.

1. List rows for the Audits table uses the below filter query.

_objectid_value eq '@{triggerOutputs()?['body/accountid']}'

2. The select retrieves the changedAttributes array

json(outputs('List_rows')?['body/value'][0]['changedata'])['changedAttributes']

3. The Add new row uses the values from the Select and concats it to a text

concat('Field ',first(body('Select'))['logicalName'], 'has changed from: ', first(body('Select'))['oldValue'], ' to ', first(body('Select'))['newValue'])

4. The regarding field is set for the Account table with the below format

/accounts/@{triggerOutputs()?['body/accountid']}

Was this reply helpful? Yes No

Join the conversation