Really useful video ... I started trying to detect a new record using the "SharePoint method" ie. Create On = Modified On ... which doesn't work in dataverse. Your video provided the answer. Thanks.
Hi, Instead of sending teams notification I am trying to add a new row in dataverse but triggerOutput() returns error that it accept the object instead string and int
Great video, Syed! I am trying to have a log of data that is modified in a table in dataverse, where when one modifies a column data in a different table (Let's say that this table has "Initial", "Processing", and "Finished" choice columns): Power automate to record the change of the old value and what the new value is in the log table. In your video I saw that for deleted product, you have the GUID. Is there a way to automate the task I said using the GUID or is there a better alternative? Thanks!
Hi Shamly, Dataverse has its own Audit History, you can turn on the Audit log in Dataverse. It is not a good idea to delete the record, best practice is to deactivate rather delete. Once you delete then you have nothing other than GUID which in my opinion is not that helpful other than you have to delete the record stored in somewhere else e.g. SQL or mySQL that contain the Dataverse GUID for reference
Can I use Power Automate to maintain a Dataverse database? For example, I put an excel with a list of products in a directory and Power Automate is able to insert these values into the Dataverse?
Scope can set based on rows ownership, if you want to limit to User then actions will be taken on rows owned by you, you can set on business unit or action on any change on environment level i.e. Organization. Hope that will answer your question.
Having abit of trouble trying to send an email to the user who modified the row. I cant find a way to extract the email address of the user. The get row by id on shows modified user (value) and i cant run this through the get profile as it needs a UPN? Is there a way to get this to work?
Great video. I have a flow in my dataverse environment and am using the When a row is added, modified or deleted trigger. I want it it to trigger when a specific field is modified to a specific value OR a record is added [and that specific field has that value]. I use the 'Added or Modified' change type; I updated the advanced features to use the select columns (statuscode). and a filter of statuscode eq 100000001. This triggers if the record exists and the status is changed to that value. But if the status code is set to that value and THEN the record is created, it does not trigger. Any ideas?
It should trigger however I would suggest that use the trigger condition and it will trigger only when condition met, in above scenario it will trigger but won't perform any action. Please check below document how to apply trigger condition powerusers.microsoft.com/t5/Power-Automate-Community-Blog/Power-Automate-Trigger-Conditions-made-EASY/ba-p/441348
I'm trying to replicate this but I cannot see Dynamics-related table names (ie Products) and there is a D365 instance in my tenant (if I use "Fin & Ops" connector the D365 instance is showed for selection), someone knows what is needed to make D365 tables/entities appear in the drop down such as in this video ?
Fin & ops ask you for the environment and Dataverse connector aren't. Make sure you create Power Automate flow in the same environment where D365 tables reside
Power Automate trigger post changes therefore don't have old values However you can track old information through audit history. Sharepoint list has audit history and you can use the action item "Get Changes for an item or file", if you are using dataverse then make sure Audit is turned on. Other option is you have to have plugin to capture pre and post changes
Hello nice video, I would like to ask If I want to notify the same to Owner of the record how to do that?? Because unable to get the email address of record. any workaround??
![I.N "HALLUCINATION" | [Stray Kids : SKZ-PLAYER]](http://i.ytimg.com/vi/n5B5q1Hwt_U/mqdefault.jpg)
Really useful video ... I started trying to detect a new record using the "SharePoint method" ie. Create On = Modified On ... which doesn't work in dataverse. Your video provided the answer. Thanks.
Thank you very much!!
Thank you for the solution! Really useful!
Do these types of flow only trigger with model driven app? I want it with canvas app
7:22
Great video. But How to Check data if it's exits on form?
Hi, Instead of sending teams notification I am trying to add a new row in dataverse but triggerOutput() returns error that it accept the object instead string and int
Very informative
Great video, Syed! I am trying to have a log of data that is modified in a table in dataverse, where when one modifies a column data in a different table (Let's say that this table has "Initial", "Processing", and "Finished" choice columns): Power automate to record the change of the old value and what the new value is in the log table.
In your video I saw that for deleted product, you have the GUID. Is there a way to automate the task I said using the GUID or is there a better alternative?
Thanks!
Hi Shamly,
Dataverse has its own Audit History, you can turn on the Audit log in Dataverse. It is not a good idea to delete the record, best practice is to deactivate rather delete. Once you delete then you have nothing other than GUID which in my opinion is not that helpful other than you have to delete the record stored in somewhere else e.g. SQL or mySQL that contain the Dataverse GUID for reference
Can I use Power Automate to maintain a Dataverse database? For example, I put an excel with a list of products in a directory and Power Automate is able to insert these values into the Dataverse?
Very easily
Hi, would you be able to explain how to choose an appropriate trigger scope (1:40), please?
Scope can set based on rows ownership, if you want to limit to User then actions will be taken on rows owned by you, you can set on business unit or action on any change on environment level i.e. Organization. Hope that will answer your question.
@@neusoltechnologies144 Thank you. 😀
Having abit of trouble trying to send an email to the user who modified the row. I cant find a way to extract the email address of the user. The get row by id on shows modified user (value) and i cant run this through the get profile as it needs a UPN? Is there a way to get this to work?
You have to add another dataverse action "Get Row by Id" and look the User (Value) in SystemUser table, that will return you the email address
Great video. I have a flow in my dataverse environment and am using the When a row is added, modified or deleted trigger. I want it it to trigger when a specific field is modified to a specific value OR a record is added [and that specific field has that value]. I use the 'Added or Modified' change type; I updated the advanced features to use the select columns (statuscode). and a filter of statuscode eq 100000001. This triggers if the record exists and the status is changed to that value. But if the status code is set to that value and THEN the record is created, it does not trigger. Any ideas?
It should trigger however I would suggest that use the trigger condition and it will trigger only when condition met, in above scenario it will trigger but won't perform any action. Please check below document how to apply trigger condition
powerusers.microsoft.com/t5/Power-Automate-Community-Blog/Power-Automate-Trigger-Conditions-made-EASY/ba-p/441348
I'm trying to replicate this but I cannot see Dynamics-related table names (ie Products) and there is a D365 instance in my tenant (if I use "Fin & Ops" connector the D365 instance is showed for selection), someone knows what is needed to make D365 tables/entities appear in the drop down such as in this video ?
Fin & ops ask you for the environment and Dataverse connector aren't. Make sure you create Power Automate flow in the same environment where D365 tables reside
Very informative! Is it possible to get the old and modified values in power Automate and send those via email?
Power Automate trigger post changes therefore don't have old values However you can track old information through audit history. Sharepoint list has audit history and you can use the action item "Get Changes for an item or file", if you are using dataverse then make sure Audit is turned on. Other option is you have to have plugin to capture pre and post changes
Hello nice video, I would like to ask If I want to notify the same to Owner of the record how to do that?? Because unable to get the email address of record. any workaround??
Add another action item of Dataverse "Get row by ID" and search the created by value in users table, then you can use the primary email from user