Announcements
No record found.
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,
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)
Thank you, Nya for your reply. I've already received a response from the power Automate community, but the solution is really not easy.
Hope it can be solved soon.
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.
Congratulations to our 2026 Super Stars!
Thanks to all of our 2025 Community Spotlight stars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
ManoVerse 180 Super User 2026 Season 1
11manish 123
CU11031447-0 100
