Answered

Filter Gallery

(0) Share

Report

Posted on by Nu2this

I am building a visitor registration app and using a gallery on the checkout page to show who has checked in. I would like to filter this list by those who have not checked out. Not having checked out will be identifiable by a field in the list being blank (the checkout time).

How do I apply this filter?

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

mdevaney 29,991 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
@Nu2this

You can FILTER the SharePoint list like this:

Filter(your_datasource_name, TimeColumn=Blank())

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

Was this reply helpful? Yes No
Nu2this 8 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you. What field in the gallery do I assign this code to? Also I would like to include only those items that are blank, not filter out the items that are blank. Is this what the result will be?

Was this reply helpful? Yes No
Verified answer

mdevaney 29,991 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!
@Nu2this

This code should be used in the Items property of the gallery. It will include only include those items which are blank.

Filter(your_datasource_name, TimeColumn=Blank())

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

Was this reply helpful? Yes No