Unanswered

Can't filter gallery by variable

(0) Share

Report

Posted on by bennking

Hi there! - I am trying to filter a gallery by a variable that has been passed over to the screen where the gallery sits.

DemandFamily is the variable and does have a value when trying to filter.

Navigate('Filter Down Screen', ScreenTransition.UnCoverRight, {DemandFamily: ThisItem.'Family Name'} < This is how the variable gets its value

Filter(
SKUs,
'Demand Family'.'Family Name' = 'Demand Family Dropdown_2'.Selected.Result

) << Works

Filter(
SKUs,
'Demand Family'.'Family Name' = DemandFamily
) << Brakes the gallery

Any ideas?

Categories:

Building Power Apps

I have the same question (0)

All responses (13)

Answers (0)

Sort by

eka24 20,925 on at

Like
a
(1)

Report
Copy link

Link copied!

What formula are you using for the variable.
Try:

Filter(
SKUs, DemandFamily in
'Demand Family'.'Family Name')
------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Was this reply helpful? Yes No
bennking 3 on at

Like
a
(0)

Report
Copy link

Link copied!

I have added the formula on how the variable is populated with a value.

DemandFamily in 'Demand Family'.'Family Name' produces the same result and just brakes the gallery (there are no syntax errors).

Was this reply helpful? Yes No
eka24 20,925 on at

Like
a
(0)

Report
Copy link

Link copied!

I assume the variable is inside a Gallery. If so change it to
Navigate('Filter Down Screen', ScreenTransition.UnCoverRight);
Set(DemandFamily, ThisItem.'Family Name')

Filter:
Filter(SKUs, DemandFamily in 'Demand Family'.'Family Name')
Or
Filter(SKUs,'Demand Family'.'Family Name' = DemandFamily)
------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Was this reply helpful? Yes No
eka24 20,925 on at

Like
a
(0)

Report
Copy link

Link copied!

Please is this issue resolved
------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Was this reply helpful? Yes No
JR-BejeweledOne 5,836 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

How does it break your gallery? What is happening?

Also have you put a label on your screen and populated it with the variable to make sure the value is what you think it is?

Was this reply helpful? Yes No
BennDev 13 on at

Like
a
(0)

Report
Copy link

Link copied!

Both of these don't work! So weird 😕

Was this reply helpful? Yes No
BennDev 13 on at

Like
a
(0)

Report
Copy link

Link copied!

By brake, I mean no results appear in the gallery.

'Demand Family'.'Family Name' = 'Demand Family Dropdown_2'.Selected.Result << This works, but when I change the filter to ue the variable that has the excact same value as 'Demand Family Dropdown_2'.Selected.Result it doesen't work 😞

Was this reply helpful? Yes No
JR-BejeweledOne 5,836 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Do you get any syntax errors or red squiggly lines? If so what is the error message?

Did you verify the content of the variable by displaying it as a label? Whenever I run into an issue like this I always verify the variable by using it in a label. Many times there is something with the value of the variable that shows up when displayed in a label.

Was this reply helpful? Yes No
BennDev 13 on at

Like
a
(0)

Report
Copy link

Link copied!

No syntax errors or squiggly lines! I have written lots of code in this Power App but this bug has stumped me.

Making the variable a label does indeed show the value as expected. Weird 😞

Was this reply helpful? Yes No
JR-BejeweledOne 5,836 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Have you tried switching this around?

Filter(
SKUs,
'Demand Family'.'Family Name' = DemandFamily
)

Filter(
SKUs,
DemandFamily in 'Demand Family'.'Family Name'
)

Was this reply helpful? Yes No