web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps If filtered table in(P...

Power Apps

Suggested Answer

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

(0) Share

Report

Report

Posted on by Community Power Pla... Microsoft Employee

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

Categories:

I have the same question (1)

All responses Img

All responses (2)

Answers Img

Answers (0)

Sort by

Ronak83garg 117 on at

Like (0)

Report
Copy link

Link copied!

I am also facing the same issue. Has there been any solution to this ?

Was this reply helpful? Yes No
Suggested answer

Power Platform 1919 2,205 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi ,

You can try this formula

With(
{
SelectedRows: Filter(
DependenciesSE_Step2,
DependenciesStep2 in PowerBIIntegration.Data.DependenciesStep2
)
},
If(
// If the filtered result has the same row count as the full table.
// treat it as "no selection in slicer"
CountRows(SelectedRows) = CountRows(DependenciesSE_Step2),
// Return an empty table with the same schema
Filter(DependenciesSE_Step2, false),
// Otherwise show only the filtered rows
SelectedRows
)
)

Was this reply helpful? Yes No

Join the conversation