Table with a lookup column is showing up empty

[morall]

I have two entities - OneEngEvent Interviewers & Users

In one of the columns for Event Interviewers, there is a look up in the Users table.

I'm trying to create a dropdown Filter that will show me everyone in the Users table (and then the next step is to create a filter)

As a test, I created two variables:

ClearCollect(userstbl1, 'OneEng Event_Interviewers'.Interviewer);
ClearCollect(userstbl2, Users);

userstbl2 works as expected

but not userstbl1 (returns empty)

Dropdown Items = 'OneEng Event_Interviewers'.Interviewer

It seems that its finding the Users table, but no data is popping up. 

It sees all of the columns

But the data is empty

 

I have access to the User entity and go in and look at all of the records, but for some reason my app isn't pulling them. 

Any thoughts? 

[BenFetters]

I have an idea that might help, on the properties panel, when you've selected the drop down, what does it say the "Value" is set to? Right under items (see below)? Could you also try something like: Choices('OneEng Event_Interviewers'.Interviewer) when creating the collection?

[v-yutliu-msft · Accepted solution]

Hi @morall ,

Could you tell me the relationship between drop down1 and drop down2?

Firstly, let me tell you why you met that problem:

since Interviewer is a lookup column , so if you directly use "'OneEng Event_Interviewers'.Interviewer" in a drop down's Items, you will get a table nested table, which is not supported to display directly.

Do you mean that OneEngEvent Interviewers & Users relationship is N:1 and Interviewer is the lookup field?
If so, you could display related OneEngEvent Interviewers based on the selected User or

                         display related User  based on the selected OneEngEvent Interviewers.

So please tell me the drop down1 and drop down2's relationship.

Then I will understand how you need to filter.

If drop down1 display User entity, drop down display related items of 'OneEng Event_Interviewers' based on the selected user, you could set like this:

drop down1's Items:

Users

 drop down2's Items:

Filter('OneEng Event_Interviewers',Interviewer.Name=drop down1.Selected.Name)

 Then drop down1 will display all items of user entity.

Drop down2 will display related items in 'OneEng Event_Interviewers' based on the selected user in drop down1.

Best regards,

[morall]

There are two entities:

Users

OneEng Event_Interviewers

In the OneEng Event_Interviewers, there is a column called "Interviewers" that is a lookup in the Users entity. 

I have a dropdown that is trying to access the Names of the Interviewers through 'OneEng Event_Interviewers.Interviewers' and then setting the value to Name on the right hand side

[v-yutliu-msft]

Hi @morall ,

Have you tried my solution?
I think it works for your issue.

Best regards,

[morall]

Hey v-yutliu-msft, 

This is great. Thank you!