Answered

If search is blank then show nothing in gallery

(0) Share

Report

Posted on by HSK2507

Hi,

I'm fairly new to Power Apps, however I'm in the building of creating one and I'm having a few issues...

I'm using the below query to filter the search, however when the search field is empty, currently it shows everything available, rather than showing a blank gallery...can someone please help me work out how to do this?

Query being used:

SortByColumns
(Search
(Filter
('Purchase Order Requests',
(Title = "Pending" Or Title = "Submitted" Or Title = "Open" Or Title = "Further Action Required")),
POFilterInput.Text,'PO Number','Requisition Number'),"ID",SortOrder.Descending)

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

mmbr1606 14,605 Super User 2025 Season 2 on at

Like (0)

Report
Copy link

Link copied!
hey @HSK2507

can you try this:

If( IsBlank(POFilterInput.Text), ClearCollect(EmptyGallery, {}), SortByColumns( Search( Filter( 'Purchase Order Requests', Title = "Pending" Or Title = "Submitted" Or Title = "Open" Or Title = "Further Action Required" ), POFilterNext.Text, 'PO Number', 'Requisition Number' ), "ID", SortOrder.Descending ) )

Let me know if my answer helped solving your issue.

If it did please accept as solution and give it a thumbs up so we can help others in the community.

Greetings

Was this reply helpful? Yes No
HSK2507 on at

Like (0)

Report
Copy link

Link copied!

Thanks for the response @mmbr1606, I have tried this however it has not made the gallery blank. Do I need to replace Empty Gallery with the gallery name at all?

Was this reply helpful? Yes No
Verified answer

HSK2507 on at

Like (0)

Report
Copy link

Link copied!

I've managed sort it using the below, @mmbr1606 you we're almost there...

If(!IsBlank(POFilterInput.Text),
SortByColumns
(Search
(Filter
('Purchase Order Requests',
(Title = "Pending" Or Title = "Submitted" Or Title = "Open" Or Title = "Further Action Required")),
POFilterInput.Text,'PO Number','Requisition Number'),"ID",SortOrder.Descending))

Was this reply helpful? Yes No