web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Return all if Filter i...
Power Apps
Answered

Return all if Filter isn't Set - Working on 1 Data Set not the other?

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

So I'm building a document request list generator; will populate a sharepoint list for clients to upload documents to the list for submission.

So I built one in my personal account and since I couldn't get the list to migrate over with relationships in tact; I decided to rebuild the relationships with IDs.

Below is a picture that shows the filter not being set and displaying all results from DocList Datasource.

This shows the filter not being set by ComboBox; and displaying all Document TypesThis shows the filter not being set by ComboBox; and displaying all Document Types

 

 

 

If(!IsBlank(ComboBox1), Filter('Doc_List-0', ComboBox1.Selected.ID in 'EngageType:ID'.Value), 'Doc_List-0')

 

 

Above is the Function I put on the ListBox; which works perfectly.. 

Now because of the migration problems I changed 1 thing, which is the ID is now the primary lookup column and title is filled for ease of tracking within the data source.

Now in my work environment; I do the EXACT same thing but data doesn't show when filter isn't set.
Screenshot:
R2Kzjiw
And the function I applied to this listbox.

 

 

If(!IsBlank(EngageSelect), Filter('Doc-List-DB', EngageSelect.Selected.ID in 'EngageID'.Value), 'Doc-List-DB')

 

 

 

Now in my professional opinion, they are the EXACT same thing but the filter has to be applied for output in the listbox.

It's making me pull my hair out as it's honestly not a NEEDED feature but for general look and feel it kind of is...

Any type of direction would be super helpful, I literally have NO idea why it's not working unless it's because I switched the lookup columns; but I don't think that should be an issue unless I'm missing something.

Thanks.


Categories:
I have the same question (0)
  • Verified answer
    Community Power Platform Member Profile Picture
    Microsoft Employee on at

    Well I figured it out, just needed to set ComboBox.Selected in the isBlank function.


Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
Valantis Profile Picture

Valantis 491

#2
WarrenBelz Profile Picture

WarrenBelz 407 Most Valuable Professional

#3
11manish Profile Picture

11manish 331

Last 30 days Overall leaderboard