cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper V
Helper V

Filtering a Gallery based on Multiple Conditions (Including LookUp Value)

I have a gallery populated by the following code set on screen's OnVisible property:

ClearCollect(ColContactNeeded,
AddColumns('AT HOME LEARNING STUDENT CONTACT LOG', "Absence#",
LookUp('STUDENT DEMOGRAPHIC INFORMATION', OtherID=LogOtherID).Absences))

 

In the gallery, I have following displayed from SharePoint List:

  • LogOtherID (Text column)
  • LogStudentName (Text column)
  • LogContactType (LookUp column)
  • Absence# (Text column)

I need gallery to show items with LogContactType value not equal to "Home Visit" and Absence# >5.

 

So basically, this is a call to action screen to display any student with 5 or more absences and no home visits.

 

Thx Community, any help is greatly appreciated!

 

1 REPLY 1
Highlighted
Super User
Super User

Re: Filtering a Gallery based on Multiple Conditions (Including LookUp Value)

Consider this formula;

Filter (ColContactNeeded, LogContactType.Value<>"Home Visit" And 'Absence#' >5)

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Helpful resources

Announcements
secondImage

New Return to Workplace

Reopen responsibly, monitor intelligently, and protect continuously with solutions for a safer work environment.

August 2020 CYST Challenge

Check out the winners of the recent 'Can You Solve These?' community challenge!

Experience what’s next for Power Apps

Join us for an in-depth look at the new Power Apps features and capabilities at the free Microsoft Business Applications Launch Event.

Check this Out

Helpful information

Featuring samples like Return to the Workplace and Emergency Response Applications

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Users online (4,547)