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?
Solved! Go to 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,
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?
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,
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
Hi @morall ,
Have you tried my solution?
I think it works for your issue.
Best regards,
Hey v-yutliu-msft,
This is great. Thank you!
User | Count |
---|---|
250 | |
250 | |
82 | |
45 | |
29 |
User | Count |
---|---|
343 | |
262 | |
123 | |
64 | |
58 |