Compare updated value to previous value?

[Joshua-Young]

In Microsoft Power Automate, does anyone know of a way to compare the original attribute value to the current attribute value when a "Fetch updates, changes, or deletions from feature layer" is used with a "When a record is updated in a Feature Layer" trigger?

It looks like the fieldsToCompare parameter for extractChanges is what I need but I cannot find a way to set that parameter in Power Automate. It also appears that supportsFieldsToCompare is set to false for all my hosted feature services that have Change Tracking enabled.

I would like users to get emails when the status of a reported issue has changed. Currently, I am sending different emails based on the current status, but the emails also trigger when staff enters notes on the reported issue even though the status has not changed.

[AkshayHarshe · Accepted solution]

@Joshua-Young We currently don't support `fieldsToCompare` in Fetch updates changes and deletions action but you can use layer queries which might not exactly solve the problem you have but you can only get the changes that matches the filter. 

There is always an option to use Http Request built in action instead of fetch to send the parameters you need. 

We do have this enhancement in our backlog.