cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
rw_ga
Advocate III
Advocate III

Dataverse trigger flows when a row changes - column filter bug

Trigger flows when a row is added, modified, or deleted - Power Automate | Microsoft Docs states "Use the Column filter box to define a set of comma-separated, unique names for the table, as shown in the following image. The flow runs only when these columns change on the specific rows." 

  1. I find this statement a little confusing, does this phase "unique names for the table" try to tell us to use the "unique name of each column"?
  2. This doesn't work for all column/field types.  So filtering columns isn't accurate.  It should either filter by ANY column/field type or be changed to say "A distinct set of columns/field types that can be filtered but you will have to guess which ones... hehehe" so that its more accurate!
  3. If it does allow adding lookup columns to the column filter area, what name do I need to use?  BECAUSE THE UNIQUE NAME FOR THE LOOKUP DOESN'T TRIGGER THE FLOW!

Trying to be a citizen developer is so frustrating when MS doesn't support their own column/field types and returned data in triggers and actions!

 

  1. Please ADD your hidden fields you/MS use on forms and other areas to the Dynamic Data.  You use this information why can't we?
  2. Allow Triggers to use any data from a row.  Null and empty are values for optional columns/fields!
  3. Allow Saving flows with errors, we may need to run out and have to get back to the flow later and to lose everything because one issue cropped up while building the flow throws an error shouldn't require us to fix it before we save it!
  • Example a lookup field appears to use 4 fields/values (and the column name/schema name doesn't appear to even be used):
    • Microsoft.Dynamics.CRM.lookuplogicalname
    • Microsoft.Dynamics.CRM.associatednavigationproperty
    • Microsoft.Dynamics.CRM.lookuplogicalname
    • _columnname_value
1 ACCEPTED SOLUTION

Accepted Solutions

@Iddy,

 

I think someone fixed something on the backend, because I had the same experience!

View solution in original post

42 REPLIES 42
Mira_Ghaly
Multi Super User
Multi Super User

Hi @rw_ga 

 

Yes the documentation is a bit confusing, for the lookup Issue you are facing I made a test and it is  working on my side.

 

Can you share some details and we may figure it out, also make sure there is not spaces in between the columns.

 

If this post helps you with your problem, please mark your as Accepted solution.If you like my response, please give it a Thumbs Up.

Blog: here

Hi Mira_Ghaly,

 

The trigger "Change type" is set to "Modified" and the "Column filter" only has the unique name of the lookup column (example: new_lookupcolumnname).  The flow doesn't trigger.

 

If I don't specify anything in the "Column filter" the flow will trigger when the lookup column changes.  I suspect it's triggering because the row's modified on and modified by are also getting updated when the lookup is changed and saved, then those fields trigger the flow!

 

So.... How do you use the column filter option to specify the lookup column? (I'm wanting only a select few columns to trigger this flow and one of them is a lookup).

@rw_ga 

Can you please share a screen shot of your column filter because i tried and it is working on my side so screenshot can help either reproduce your issue or identify what might be the issue?

If this post helps you with your problem, please mark your as Accepted solution.If you like my response, please give it a Thumbs Up.

Blog: here
Iddy
Frequent Visitor

I've been trying this too.

 

From my research it seems to work for simple columns (you need the fully qualified column name with your solution prefix if you app is coming out of a solution), however it does not trigger if you try and add a lookup column to the list of column filters.

 

Nor do any of the other previously working columns.

 

Unless someone knows some magic here for referencing the lookup column in the column filter I'd say its a bug or omission by design (please update the docs).

@Iddy 

So you mean when you add a lookup column among other types of columns?

Can you tell me please what other column types so I can try to reproduce?

 

If this post helps you with your problem, please mark your as Accepted solution.If you like my response, please give it a Thumbs Up.

Blog: here

@Iddy @rw_ga 

This is what I am trying at my side and it is working for any of the 3 fields

Mira_Ghaly_0-1628203104352.png

I will try on custom entities and custom fields as well but it would be great if you guys share with me some more details so I am able to reproduce it

If this post helps you with your problem, please mark your as Accepted solution.If you like my response, please give it a Thumbs Up.

Blog: here
Iddy
Frequent Visitor

Here's what I tested. Add the name field (my solution is prefixed stk_ so I added stk_name). Tested the workflow (manual test in the browser). This works fine - updates to the record do not trigger the flow unless the name field is changed.

I have a second field on my entity, exam (named stk_exam). Its a lookup field to a second custom entity (Certification Exam). If I add it as a filter (as the only filter) the workflow does not trigger, I've tried various combinations (exam, stk_exam, stk_exam_value). Also, if I add it to the end of the list of columns (i.e with my name filter as well) the workflow no longer triggers on the update to the name field. I am wondering if the field needs to be refenced differently?

Are any of those lookup fields? My flows trigger for simple columns.

@Iddy

Yes parentcustomerid is a lookup.

 

If this post helps you with your problem, please mark your as Accepted solution.If you like my response, please give it a Thumbs Up.

Blog: here

Hi Mira_Ghaly/Iddy,

 

Thank you both for providing your experiences. I'm getting mixed results and don't know why other than its some type of BUG or I need to do something different with custom tables/lookups!

 

Recap: 

I'm using Dynamics 365 for Sales Ent. (Online).

I created a "unmanaged solution" to hold all my custom STUFF.

I created multiple custom tables (they are the standard ones not Activity Type)

I created cloud flows to trigger when rows in these custom tables get modified (specific columns using column filter).

 

In testing:

Using OOB Account, Parent Account Lookup (parentaccountid) with the column filter triggers the flow.

Records:

rw_ga_1-1628255434231.png

Column Name:

rw_ga_4-1628255532613.png

 

Flow:

rw_ga_2-1628255453333.png

 

Select Test 1 in Lookup field:

rw_ga_3-1628255503889.png

Flow Run History:

rw_ga_5-1628255588971.png

rw_ga_6-1628255675403.png

 

Using custom tables/lookup columns with the column filter doesn't trigger the flow.

I use the same process with custom tables and lookups and it won't trigger!  What the heck!!!!  Why doesn't it work the same for custom tables and their lookups?

Well, I'm at a complete lose.  I just tried it again this morning and it APPEARS to be working for me now.

 

@Iddy

I tried it before and it didn't appear to work, but I'm currently using just the "Name" of the column that is displayed when viewing all columns of a table. NOTE: I did notice a red banner after saving the cloud flow that indicated something was wrong with my trigger like before, but this time it worked and that went away after I changed a record (lookup column value) and it triggered the flow. 

rw_ga_0-1628257878093.png

WORKED:

  • new_lookupcolumn

 

DOESN'T WORK:

  • new_lookupcolumn@Microsoft.Dynamics.CRM.lookuplogicalname
  • new_lookupcolumn@Microsoft.Dynamics.CRM.associatednavigationproperty
  • new_lookupcolumn@Microsoft.Dynamics.CRM.lookuplogicalname
  • _new_lookupcolumn_value

 

Did somebody change something on the backend!  Someone is just messing with me!!!

Okay, whoever fixed the lookup field, can you fix the image field type now?  The trigger only appears to fire when you remove the image and not when one is added!

 

Still a "Column filter" issue/bug, doesn't work the same for all column types.  Now I only have an image column I want to monitor.  I can add an image and it doesn't fire but it will fire when the image is removed.  I need it to fire when an image is added too!

 

Thanks

I noticed there are a few image column (field/values) MS uses but doesn't really tell us about:

For Example, if you create an image column named "Image", it defaults the NAME to something like "new_image".  But using a Chrome browser extension like "Level up for Dynamics 365/Power Apps" Offered by: Natraj Yegnaraman you can see the following other fields are present.  So similar to a lookup, it appears there might be multiple values used with an image column and probably the file column too.  Now the next question is when can we use these with triggers and actions...  MS doesn't appear to support all of them everywhere.

As a workaround and until the image column type gets fully supported/fixed in the column filter, I've added both:  new_image,new_imageid which triggers the flow when an image is added OR removed!  


Again, its so frustrating that we have to search for odd workarounds when MS should just support all their own fields at both the trigger and action levels!  Why are there these hit or miss attempts???  By the way, that new_imageid appears in the Dynamic data tool when I searched for image!!!!  Go figure....  I can't get a label or the displayed text of an optionset or lookup from the Dynamic data but I can get this imageid....

 

Hope this helps someone else fighting to use these tools.  Don't get me wrong, the whole concept of allowing citizen developers is great!  I just wish it executed a little cleaner.

@rw_ga

I did a test using a custom table and custom lookup and it fired OK as well and I think now the lookup is working fine with you but you have an issue with the image / file column types which you have successfully found a work around.. Is my understanding correct?

 

If this post helps you with your problem, please mark your as Accepted solution.If you like my response, please give it a Thumbs Up.

Blog: here

Edit: Yes it does appear to be working with the lookup Name in the column filter option.

 

I did find a work around for the image column, but don't know how long it will be supported (if it's supported at all).  Hopefully that issue will get fixed as well!

Iddy
Frequent Visitor

So, this flow is now working, using the solution qualified name of my lookup field (stk_exam). The same option I tried unsuccessfully yesterday. I have no sensible explanation for this. 

@Iddy,

 

I think someone fixed something on the backend, because I had the same experience!

Anonymous
Not applicable

Hi Mira_Ghaly,

I have a question, in the below Column filter... which is now "select columns"

Can I Give multiple columns with or condition.

I have a requirement where I want to Update a record when there is Row  Modified with any one of the selected  Columns.(Like dirty fields).

 

Any help would be so greatful.

Thank you

Stpower_0-1634673443404.png

 

@Anonymous 

The purpose of the column filter or Select Column is that these are used as triggers to your flow , so when either of these columns change your flow gets triggered.

 

If this post helps you with your problem, please mark your as Accepted solution.If you like my response, please give it a Thumbs Up.

Blog: here

Helpful resources

Announcements

Celebrating the May Super User of the Month: Laurens Martens

  @LaurensM  is an exceptional contributor to the Power Platform Community. Super Users like Laurens inspire others through their example, encouragement, and active participation. We are excited to celebrated Laurens as our Super User of the Month for May 2024.   Consistent Engagement:  He consistently engages with the community by answering forum questions, sharing insights, and providing solutions. Laurens dedication helps other users find answers and overcome challenges.   Community Expertise: As a Super User, Laurens plays a crucial role in maintaining a knowledge sharing environment. Always ensuring a positive experience for everyone.   Leadership: He shares valuable insights on community growth, engagement, and future trends. Their contributions help shape the Power Platform Community.   Congratulations, Laurens Martens, for your outstanding work! Keep inspiring others and making a difference in the community!   Keep up the fantastic work!        

Check out the Copilot Studio Cookbook today!

We are excited to announce our new Copilot Cookbook Gallery in the Copilot Studio Community. We can't wait for you to share your expertise and your experience!    Join us for an amazing opportunity where you'll be one of the first to contribute to the Copilot Cookbook—your ultimate guide to mastering Microsoft Copilot. Whether you're seeking inspiration or grappling with a challenge while crafting apps, you probably already know that Copilot Cookbook is your reliable assistant, offering a wealth of tips and tricks at your fingertips--and we want you to add your expertise. What can you "cook" up?   Click this link to get started: https://aka.ms/CS_Copilot_Cookbook_Gallery   Don't miss out on this exclusive opportunity to be one of the first in the Community to share your app creation journey with Copilot. We'll be announcing a Cookbook Challenge very soon and want to make sure you one of the first "cooks" in the kitchen.   Don't miss your moment--start submitting in the Copilot Cookbook Gallery today!     Thank you,  Engagement Team

Announcing Power Apps Copilot Cookbook Gallery

We are excited to share that the all-new Copilot Cookbook Gallery for Power Apps is now available in the Power Apps Community, full of tips and tricks on how to best use Microsoft Copilot as you develop and create in Power Apps. The new Copilot Cookbook is your go-to resource when you need inspiration--or when you're stuck--and aren't sure how to best partner with Copilot while creating apps.   Whether you're looking for the best prompts or just want to know about responsible AI use, visit Copilot Cookbook for regular updates you can rely on--while also serving up some of your greatest tips and tricks for the Community. Check Out the new Copilot Cookbook for Power Apps today: Copilot Cookbook - Power Platform Community.  We can't wait to see what you "cook" up!    

Welcome to the Power Automate Community

You are now a part of a fast-growing vibrant group of peers and industry experts who are here to network, share knowledge, and even have a little fun.   Now that you are a member, you can enjoy the following resources:   Welcome to the Community   News & Announcements: The is your place to get all the latest news around community events and announcements. This is where we share with the community what is going on and how to participate.  Be sure to subscribe to this board and not miss an announcement.   Get Help with Power Automate Forums: If you're looking for support with any part of Power Automate, our forums are the place to go. From General Power Automate forums to Using Connectors, Building Flows and Using Flows.  You will find thousands of technical professionals, and Super Users with years of experience who are ready and eager to answer your questions. You now have the ability to post, reply and give "kudos" on the Power Automate community forums. Make sure you conduct a quick search before creating a new post because your question may have already been asked and answered. Galleries: The galleries are full of content and can assist you with information on creating a flow in our Webinars and Video Gallery, and the ability to share the flows you have created in the Power Automate Cookbook.  Stay connected with the Community Connections & How-To Videos from the Microsoft Community Team. Check out the awesome content being shared there today.   Power Automate Community Blog: Over the years, more than 700 Power Automate Community Blog articles have been written and published by our thriving community. Our community members have learned some excellent tips and have keen insights on the future of process automation. In the Power Automate Community Blog, you can read the latest Power Automate-related posts from our community blog authors around the world. Let us know if you'd like to become an author and contribute your own writing — everything Power Automate-related is welcome.   Community Support: Check out and learn more about Using the Community for tips & tricks. Let us know in the Community Feedback  board if you have any questions or comments about your community experience. Again, we are so excited to welcome you to the Microsoft Power Automate community family. Whether you are brand new to the world of process automation or you are a seasoned Power Automate veteran - our goal is to shape the community to be your 'go to' for support, networking, education, inspiration and encouragement as we enjoy this adventure together.     Power Automate Community Team

Hear what's next for the Power Up Program

Hear from Principal Program Manager, Dimpi Gandhi, to discover the latest enhancements to the Microsoft #PowerUpProgram, including a new accelerated video-based curriculum crafted with the expertise of Microsoft MVPs, Rory Neary and Charlie Phipps-Bennett. If you’d like to hear what’s coming next, click the link below to sign up today! https://aka.ms/PowerUp  

Tuesday Tip | How to Report Spam in Our Community

It's time for another TUESDAY TIPS, your weekly connection with the most insightful tips and tricks that empower both newcomers and veterans in the Power Platform Community! Every Tuesday, we bring you a curated selection of the finest advice, distilled from the resources and tools in the Community. Whether you’re a seasoned member or just getting started, Tuesday Tips are the perfect compass guiding you across the dynamic landscape of the Power Platform Community.   As our community family expands each week, we revisit our essential tools, tips, and tricks to ensure you’re well-versed in the community’s pulse. Keep an eye on the News & Announcements for your weekly Tuesday Tips—you never know what you may learn!   Today's Tip: How to Report Spam in Our Community We strive to maintain a professional and helpful community, and part of that effort involves keeping our platform free of spam. If you encounter a post that you believe is spam, please follow these steps to report it: Locate the Post: Find the post in question within the community.Kebab Menu: Click on the "Kebab" menu | 3 Dots, on the top right of the post.Report Inappropriate Content: Select "Report Inappropriate Content" from the menu.Submit Report: Fill out any necessary details on the form and submit your report.   Our community team will review the report and take appropriate action to ensure our community remains a valuable resource for everyone.   Thank you for helping us keep the community clean and useful!

Users online (4,214)