Filter based on Yes/No with dropdown

[poloboyyur]

I have a visitor check in app where once you check in on my list it changes VisitorStatus to yes. When the person presses check out it changes to no but the filter is not working. Any help on how to fix this. 

[WarrenBelz]

Hi @poloboyyur ,

You can shorten that code to this

With(
   {wStatus:Dropdownl.Selected.Value = "Checked In"}
   Filter(
      Visitors,
      VisitorStatus = wStatus
   )
)

but I can see a button there (not a drop-down). What does the button do?

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

[poloboyyur]

@WarrenBelz 

The code is not working for me. It still does not separate the people who are checked in versus those who are checked out.  The checkout button logs the time in the SharePoint list of when the visitor leaves. I have put a picture of the checkout button code below. In my code VisitorStatus is a Boolean data type.

[WarrenBelz · Accepted solution]

@poloboyyur ,

I will try to simplify this so I can check my understanding is correct - this code

With(
   {wStatus:Dropdownl.Selected.Value = "Checked In"}
   Filter(
      Visitors,
      VisitorStatus = wStatus
   )
)

Looks at the item selected in Dropdown1 and if it is Checked In sets a temporary Boolean variable of true (or false if it is not Checked In ). It then filters the List Visitors where the column VisitorStatus matches this Variable.

Is any of this incorrect?

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