Filter Gallery from variable

[mprice]

Hello,

I am trying to filter a gallery using a variable that was set after selected an option from another gallery.

First I set a variable with the following. Where ThisItem.Campaign is to load the variable with the column called "Campaign" from the selected item in the first gallery.

Set(
gblDisc,
ThisItem.Campaign
);

Now in the Items field for the second gallery, I tried the following search function, searching the table K.E.Y.S which has a column called Disciplines (or cr0fd_disciplines):

Search(
'K.E.Y.S',
gblDisc,
"cr0fd_disciplines"
)

I also tried, but was getting an error with the "=":

Filter(
'K.E.Y.S',
Disciplines=gblDisc
)

[WarrenBelz]

Hi @mprice ,

What type of fields are Campaign and Disciplines?

[mprice]

Choice fields

[WarrenBelz]

Hi @mprice ,

First one

Set(
   gblDisc,
   ThisItem.Campaign.Value
)

and the other

Filter(
   'K.E.Y.S',
   Disciplines.Value=gblDisc
)

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.

[mprice]

[Jcook]

Hey @mprice where are you setting the variable?

[mprice]

In the initial gallery, in the OnSelect field

[WarrenBelz]

@mprice ,

If it a Choice field, then .Value is correct.

If set on the OnSelect of the gallery, ThisItem is correct as long as the value is in the Items of the gallery.

Is there something incorrect in any of the above?

[mprice]

I am using this functin on the OnSelect of the first gallery. I think I may have a misunderstanding of ThisItem. I though it would return which item I selected from the gallery.

[WarrenBelz]

@mprice ,

It will - as long as the Items contain the field Campaign.

For a test, try this - OnSelect

ClearCollect(colItem,ThisItem)

Then go to View > Collections > colItem and see what is in Campaign