Hello friends! We have Dynamics 365 on-premise which is connected through On-premise data gateway to Power Automate. We need to add a row with the Account name to the Excel spreadsheet when one field in Opportunity was changed. To do this, a SQL trigger "When an item is modified" was created. Now this trigger works when changing any Opportunity field, but we need it to execute only when only one field new_ResearchDate was changed. How to correctly prescribe this in the trigger settings?
Hi,
Hope it can be solved soon.
Thank you, Nya for your reply. I've already received a response from the power Automate community, but the solution is really not easy.
According to the definition of When an item is modified (V2), the "Select Query" just identifies the columns to be fetched in the modified record.
However, there is no sample which describes how to use the "Select Query" and "Filter Query".
It is recommended to post your issue the forum of Power Automate for further help.
Here is the link:
Forums - Power Platform Community (microsoft.com)
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Andrés Arias as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Daniyal Khaleel 116
DAnny3211 101
Abhilash Warrier 66 Super User 2025 Season 2
