Filter Powerapp Dates

[MrAutomate]

I am stuck on adding a clause to  filter a data table ITEMS formula in Powerapps.

LIne 1 :  //Filter(SortByColumns(TeammateBasics,"FirstName",Descending),Active=1)

LIne 1 brings back only active teammates and works fine.

However, I also want to show what teammate has NOT had a Covid Vaccine. I need to return/display any active teammate that has a blank/missing date for Shot1Received, Shot2Received,Shot3Received

Thanks for looking and pointing me in the right direction.  

[WarrenBelz · Accepted solution]

Hi @MrAutomate ,

As below

Filter(
   SortByColumns(
      TeammateBasics,
      "FirstName",
      Descending
   ),
   Active=1 &&
   (
      Shot1Received = Blank() ||
      Shot2Received = Blank() ||
      Shot3Received = Blank()
   )
)

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps

[MrAutomate]

Warren, Many thanks!  I tried using isblank with an IN clause with commas. Your response worked perfectly.