Filter Data to only show completed items

(0) Share

Report

Posted on by Dinerz

112

Hi Everyone,

I need some help. I'm stuck filtering my gallery to show items that are not blank for a specific category.

My data has a column called 'Type'. When I select 'Completed' on Gallery_Progress I want the Main_Gallery to show me only the 'Type' where the column called 'Recipient Answer1' is not blank for all that same 'Type'.

Currently its showing me 'Type' that has a not blank 'Recipient Answer1' even if its only 1 of 3 'Types' where 'Recipient Answer1' is not blank.

I need it to only show me 'Type' if all 3 or however may of the same 'Type' has a not blank 'Recipient Answer1'

Items:

If(

Dropdown1.Selected.Value = "All" And Gallery_Progress.Selected.Value = "All Reviews",
Distinct(collect_AppData_Recip_MVP2, Type),
Dropdown1.Selected.Value = "All" And Gallery_Progress.Selected.Value = "Completed",
Distinct(Filter(collect_AppData_Recip_MVP2, 'Recipient Answer1' <> Blank()), Type)

)

Categories:

Building Power Apps

All responses (2)

Answers (1)

Sort by

Verified answer

mmbr1606 14,629 Super User 2026 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
hey @Dinerz

can u try this please:

If( Dropdown1.Selected.Value = "All" And Gallery_Progress.Selected.Value = "All Reviews", Distinct(collect_AppData_Recip_MVP2, Type), Dropdown1.Selected.Value = "All" And Gallery_Progress.Selected.Value = "Completed", Distinct( Filter( collect_AppData_Recip_MVP2, Type in Filter( GroupBy(collect_AppData_Recip_MVP2, "Type", "GroupData"), CountRows(Filter(GroupData, 'Recipient Answer1' <> Blank())) = CountRows(GroupData) ).Type ), Type ) )

if this raises a delegation issue you can also try this:

If( Dropdown1.Selected.Value = "All" And Gallery_Progress.Selected.Value = "All Reviews", Distinct(collect_AppData_Recip_MVP2, Type), Dropdown1.Selected.Value = "All" And Gallery_Progress.Selected.Value = "Completed", Distinct( Filter( collect_AppData_Recip_MVP2 as c, CountRows(Filter(collect_AppData_Recip_MVP2, Type = c.Type)) = CountRows(Filter(collect_AppData_Recip_MVP2, Type = c.Type && 'Recipient Answer1' <> Blank())) ), Type ) )

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
Dinerz 112 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks for the help. This works perfect!