Skip to main content
Community site session details

Community site session details

Session Id : puSzTth0xzJsODUWSqQkdK
Power Apps - Power Query
Unanswered

If filtered table in(PowerBIIntegration.Data) has no selected value, return no items in Power Apps gallery

Like (0) ShareShare
ReportReport
Posted on 12 Feb 2023 14:14:21 by

Hi!

 

I have a gallery in Power Apps with 'Items' field which return an Excel/Power BI table:

 

Filter(DependenciesSE_Step2,DependenciesStep2 in(PowerBIIntegration.Data).DependenciesStep2)

 

 

I have a multi-selections slicer in Power BI for that table and when the users filters values their are reflected in the Power Apps gallery (working fine).

 

BUT, if the users hasn't selected anything in the Power BI slicer, the Power Apps gallery will return all values from the table by default until a value is selected in Power BI/Apps. It's invalidating my calculations in the app since I'm looking for user inputs (filtered value only)

 

Is there a way for the Power Apps gallery to only show selected values and return none if none are selected?

 

I really need help with this, been investigating this for days! 😩

 

Thanks.

 

Alex.

 

 

 

 

 

I want the gallery to filter only the selected values in Power BI (which is working fine), but 

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

Announcing our 2025 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for…

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 791 Most Valuable Professional

#2
MS.Ragavendar Profile Picture

MS.Ragavendar 410 Super User 2025 Season 2

#3
mmbr1606 Profile Picture

mmbr1606 275 Super User 2025 Season 2

Featured topics

Loading complete