'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
How to Trigger Power Automate Flows on Data Changes in Dynamics 365
Question details
The user needs to trigger a Power Automate flow specifically when data changes (data events) in a Dynamics 365 Finance and Operations table, rather than relying solely on business events.
- Product
- Microsoft Power Automate and Dynamics 365 Finance and Operations
- Device & OS
- not provided
- Scenario
- Automating business workflows based on specific record modifications or value updates within a D365 F&O table.
- Observed behavior
- The standard Dynamics 365 F&O connector natively displays business events, making it unclear how to configure the system for direct data events or specific field value change triggers.
Ensure you have administrative access to your Power Automate environment and Dynamics 365 Finance and Operations instance to configure connectors and check event catalogs.
Use the Dataverse Connector for Data Events via Virtual Tables
Since direct D365 F&O data events might not natively appear in the legacy connector, routing via Dataverse virtual entities is the recommended modern approach for triggering flows on data changes.
Microsoft integrates Dynamics 365 Finance and Operations tightly with Dataverse. By exposing your F&O tables as virtual entities in Dataverse, you can utilize the highly robust Dataverse connector to trigger automation exactly when data changes.
In Dynamics 365 F&O, navigate to System administration and ensure Dataverse integration and virtual entities are enabled for the specific target table you want to monitor.
Open Power Automate, click on 'Create', select 'Automated cloud flow', and search for the Microsoft Dataverse connector.
Choose the trigger 'When a row is added, modified or deleted'. Select 'Modified' as the change type and pick your F&O virtual table from the dropdown menu.
To prevent the flow from running on every single modification to the record, click 'Show advanced options' and enter the logical name of the specific column in the 'Column filter' field. The flow will now only trigger when that specific value changes.
Consult the Microsoft Power Automate Community for Table-Specific Support
If your specific table does not support virtual entities or data events, you should consult Power Automate experts for specialized workarounds.
Looking for a Reliable and Free Office Suite? Try WPS Office
While Power Automate and Dynamics 365 handle your complex enterprise workflows, you still need a fast, reliable, and highly compatible suite for your daily document processing. WPS Office provides an all-in-one solution for handling spreadsheets, documents, and presentations natively compatible with Microsoft formats, without the heavy subscription fees.
- 1. Download the installer: Visit the official WPS Office website and download the free version for your operating system.
- 2. Install WPS Office: Run the setup file and follow the on-screen prompts to complete the installation in minutes.
- 3. Open your Microsoft files: Launch WPS Office and seamlessly open your existing Word, Excel, and PowerPoint files without any formatting loss.
Frequently Asked Questions
What is the difference between business events and data events in Dynamics 365 F&O?
Business events are triggered by specific business logic or completed processes (like an invoice being successfully posted), whereas data events are triggered directly by basic database operations (Create, Read, Update, Delete) on tables, such as a single field value changing.
Can I trigger a Power Automate flow only when a specific field value changes?
Yes. By using the Dataverse connector and virtual tables, you can use the 'When a row is added, modified or deleted' trigger and specify column filters to ensure the flow only runs when that designated field is modified.
Why doesn't the native F&O connector show my table for data events?
Not all tables are natively exposed for data events in the legacy connector. You may need to enable Dataverse integration, expose the target table as a virtual entity, or consult the Power Automate community for workarounds specific to that entity structure.
