Announcements
I have an entity, Profit Centre with a many-to-one relationship to the Team entity. I want to trigger a flow each time the team field is changed on the Profit Centre unless the team field has been set to null.
What is the syntax for the OData expression I must put in the Filter Rows field of the trigger?
Hi @halifaxious ,
You can enter the column name for the team in the Select columns and if this field changes it will then trigger the flow. It used to be called "Column filters" and now is "Select columns". If you have multiple you can separate by commas. Is this what you were looking for?
Hope this helps. Please accept if answers your question or Like if helps in any way.
Thanks,
Drew
That's exactly what I did (see pic above). The problem is, if I edit the record and set my triggering field to <blank>, the flow still triggers. I'd like to prevent that.
Ahhh, understand. Try <team field name> ne null in the filter rows.
Okay, that's what I thought it should be. But it's not behaving. But I just tried this:
Note that in the Select columns field the fieldname is xxx_delegates but in the Filter rows field the fieldname is _xxx_delegates.
Honestly! Why can't MS apply some consistency. How are we supposed to know which form of fieldname to use in which seemingly similar field?
HI @halifaxious ,
Please try just the filter rows and see if this works. If not, let me know and I will try a test as well.
Hello @halifaxious
Flow Using Web API so we need to go with the same
To Proceed with I have attached a file this for generating ODATA query calls etc.
You can import the solution in your environment
and Navigate to Your Environmnet --> Click Gear Icon on Top--> Select Advance Settings --> Select Solutions --> You can see CRM Rest Builder at the top
Once Page Opened Select RETRIEVE MULTIPLE then select the Entity (i have selected account and Filter as Owner {in your case its delegate })
Once selected Click Result
You can find the Condition highlighted here, you can copy the same and use it in flow.
Please mark as Answer if it is helpful and provide Kudos
Subscribe : https://www.youtube.com/channel/UCnGNN3hdlKBOr6PXotskNLABlog : https://microsoftcrmtechie.blogspot.com
I did try it. That's what I meant by "it's not behaving". Using the _fieldname works. Using the bare fieldname has no effect when field is not null and hangs when field is null.
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.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
WarrenBelz 342 Most Valuable Professional
11manish 234
Valantis 187
