Notifications
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.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Tom_Gioielli 137 Super User 2025 Season 2
#ManoVerse 57
Jimmy Passeti 50 Most Valuable Professional
