002 - Power Automate - Dataverse record Added, Modified, Deleted trigger

In this video you will learn how to handle when a row is added, modified or deleted in Microsoft Dataverse using single flow

[DanielWesterdale]

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.

[TusharBorawake]

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

[shamlymackey]

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!

[Aaron-patch]

7:22 <-- When I get to this point, only the primary column and owner shows up for editing. The others cannot be set, same for when I edit a record. Do you know why? Thanks!

[saurabhtalele]

Do these types of flow only trigger with model driven app? I want it with canvas app

[mirelaathayde]

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?

[SandraDevin]

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 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?

[tuyenpham]

Great video. But How to Check data if it's exits on form?

[nununu]

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?

[salgigi]

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 ?

[conaxlearn]

Hi, would you be able to explain how to choose an appropriate trigger scope (1:40), please?

[sanatan_dharam]

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??

[kavyamuniswamappa]

Very informative! Is it possible to get the old and modified values in power Automate and send those via email?