LookUp column to filter a second column

[Wackmack88]

Hi all,

I want to show a value in a lookup column. My forms have two lookup cascading columns from two lists.
When i have only 1 lookup column and i want to show the value from another column in the list, i always use this method what works fine:

"Example: " & LookUp(Source, Title = DataCardValue3.Selected.Value, Example)

As i said, this works for out of the box Lookup columns perfect. Now i have a cascading columns setup with a collection.

I think i need to make my collection creater so that i can filter later on that, is that correct?
Here is the setup for my cascading, this is on the OnSelect button

ClearCollect(
    collSchools,
    {
        Schools: Filter(
           Schools,
            Facility.Value = DataCardValue2.Selected.Value
        )
    }
)

This is on the item button from the second cascading column:

Filter(
    Choices(Testlist.School),
    Value in First(collSchools).School.Title
)

This doesn't work anymore:

"Second lookup:" & LookUp(
    School,
    Title = DataCardValue5.Selected.Value,
    Example
)

So i think i need to make my collection bigger and then later filter on the collection so i can use the value from the second column, is that right? 

[Wackmack88 · Accepted solution]

"Example: " & LookUp(Source, Title = DataCardValue3.Selected.Value, Example)

This was the solution, cache was the problem 🙂