cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
CCLam
Frequent Visitor

How do you filter a Lookup field when using the trigger When a row is added, modified or deleted?

Not having any success filtering a lookup column when using the "When a row is added, modified or deleted" trigger and unable to find any resources on how to do it. Any help is much appreciated.

 

Basically all I want to do is to make sure the trigger does not fire unless the lookup column being selected is of a certain value. Example:

A main table called Travel, and Country is one of the lookup columns. If user selects, for example Australia, then the trigger activates. If user selects other countries, nothing happens.

1 ACCEPTED SOLUTION

Accepted Solutions
Mira_Ghaly
Dual Super User II
Dual Super User II

@CCLam 

The filter row should be in the syntax 

_countryfieldlogicalname_value eq 'australiaGUID'

 

 

 

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

View solution in original post

2 REPLIES 2
Mira_Ghaly
Dual Super User II
Dual Super User II

@CCLam 

The filter row should be in the syntax 

_countryfieldlogicalname_value eq 'australiaGUID'

 

 

 

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
CCLam
Frequent Visitor

Thank you @Mira_Ghaly 

 

Somehow the only syntax that worked is:

_countryfieldlogicalname_value eq australiaGUID

without the quotes...

 

Just wondering is there any official Microsoft resource explaining this syntax?

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

May UG Leader Call Carousel 768x460.png

June User Group Leader Call

Join us on June 28 for our monthly User Group leader call!

PA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.

PA.JPG

New Release Planning Portal (Preview)

Check out our new release planning portal, an interactive way to plan and prepare for upcoming features in Power Platform.

Users online (2,524)