web

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

News and Announcements icon

Power Platform CommunityForums Power Apps Filter a gallery view ...

Power Apps

Unanswered

Filter a gallery view - simple formula doesn't seem to work

(0) Share

Report

Report

Posted on by BCWdesign

56

This has driven me mad as I can't see why it doesn't work!

All the advice seems to point to this formula

There is a a drop down box of choices to filter the gallery and have tried to put the filter on the gallery

So dropdown box is

Name : dropdowncase

Distinct(Table1,'EHC Hub Case Number')

Filter(Table1,'EHC Hub Case Number'= dropdowncase.Selected,'EHC Hub Case Number')

Help much appreciated

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (4)

Answers Img

Answers (0)

PowerRanger 3,458 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!
@BCWdesign You should change your Filter formular to this:

Filter(Table1,'EHC Hub Case Number'= dropdowncase.Selected)

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No
BCWdesign 56 on at

Like (0)

Report
Copy link

Link copied!

Sadly this did not work : (
The error I receive is incompatible types for comparison
These types can't be compared text, record

Was this reply helpful? Yes No
PowerRanger 3,458 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!
@BCWdesign Sorry...my fault. Use this instead

Filter(Table1,'EHC Hub Case Number'= dropdowncase.Selected.Value)

I assume that the field "EHC Hub Case Number" is a Text or Number field.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No
BCWdesign 56 on at

Like (0)

Report
Copy link

Link copied!

@PowerRanger
sorry still have the same issue "EHC Hub Number" is a text field

Was this reply helpful? Yes No

Join the conversation