Lookup column not showing values in collection table

[Rob_Cap]

Hello, I’ve got troubles with Lookup.
I have a 2 tables

1. ‘Users’, with a lot of columns. The relevant ones are Band Name and School Name
   

   

2. ‘Bands_Battle’ with a lot of columns. The relevant one is Band name.
   

   

I have a layout page “Battle” where I display a collection table, which shows the Band names (source data table: Bands_Battle).

I want to display the School Name next to Band name .

To do so I created a relationship column in the data table Bands_Battle: rel_Bands_School. Relate to items where the value in: Band_Name
Matches the value in: Users/Band_Name
Single

Then I created a Lookup column: Lkp_School. Configuration. Relation column: rel_Bands_School/School_Name.

The column in the data table displays the correct values.

In the layout page, I added the column Lkp_School to the collection table. It does not display anything.

After numerous trials (and errors), I created a simplified version on a different app, with only the columns I mentioned above.
It works perfectly.

It appears to me there is some additional setting or something, but I have no idea where to look into.

Any suggestion on what I could be doing wrong is appreciated or what to look into.

[Darren_Murphy]

@Rob_Cap

‘Users’, with a lot of columns. The relevant ones are Band Name and School Name

There may be other relevant columns. In particular, check the Email column, if there is one. If that (or any other column) has row owners applied, that would almost certainly be the source of your problem.

[Rob_Cap]

oh … let me look into it.
Thanks

[Rob_Cap]

Bingo.
That was the issue.

[Rob_Cap]

I removed the row owner and data displays correctly.
However, it caused other issues in other pages (e.g. the set lists are not band specific anymore)

Is there a workaround?
Thanks

[Darren_Murphy]

If data security is not important, then you can just apply appropriate filters to your collections.

Otherwise, you would need to look into using roles as row owners.