Answered

Searching on a Filtered Gallery Not Showing All Results?

(0) Share

Report

Posted on by Applications

Hello! I've built a PowerApp that is supposed to show people that don't have phone numbers so my team members can assign them phone numbers, but it's not showing all of the results when I'm pulling in the data and applying a search/filter function on the gallery:

Gallery:

Search(Filter('New Arrivals', IsBlank('Phone Number')), TextInput2.Text, "Title")

I'm pulling this data from a SharePoint list that has names and numbers, as well as other information, but even on the list there are people there that don't show up within my gallery:

Within the gallery:

Within the SharePoint list:

I know it's a new record, but it also does that with older records, and since I'm pulling from the list as a datasource, it shouldn't matter, right?

I checked the column name of the SharePoint list and I found it's actually named:

Field=Phone_x0020_Number_x0020_Assigne

But when I use that in the formula on the Gallery, nothing shows up.

Any thoughts? Am I doing something wrong somewhere?

Thank you all!

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

ushaambre3 5 on at

Like (0)

Report
Copy link

Link copied!

Hello!
According to project name I want to add a gallery view . Suppose someone created form that user can see that form only. But Seniors CEO and Director can see whole gallery view and Manager can see only which ever project he have they can see that form in gallery view.

Any thoughts?

Thank you

Was this reply helpful? Yes No
Verified answer

Drrickryp Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!
@Applications

If you are getting a partial list from your formula, then it is working but likely you are running into a delegation problem. Try this formula instead: It is odd but IsBlank() is not delegatable but =Blank() is.

Search( Filter( 'New Arrivals', 'Phone Number'=Blank() ), TextInput2.Text, "Title" )

Intellisense should give you a hint about which format you should use for the phone number.

Was this reply helpful? Yes No