
Hello,
I need my flow to trigger any time the Account Owner (Account_Owner__c) field on a Account record in Salesforce is updated.
I know the trigger should be 'When a record is modified', but I am not sure how to set the filter query, so that my flow only fires when the account owner field gets modified.
Any ideas?
Thank you!
I found a solution for this. Instead of using Salesforce object 'Accounts', I used object 'Account History', which is a record showing updates made to the fields on the Account object. And instead of using trigger 'When a record is modified', I used trigger 'When a record is created', with 'Account History' as the object type. In this way, I could use filters based on the Account History fields that track changes on the fields of an Account. The filter query I used was "Field eq 'Owner', because the field for account owner on the Account History object is 'Owner'.