You’re offline. This is a read only version of the page.
65
Hello,
I am in the early stages of developing a vehicle inspection app. My challenge I am having is that I can't view the items for my drop down menu.
For some context:
- I have a "DriverLog" table that has a lookup column called "Employee_DriverLogFK" that points to a "Employee" table. As you can see above I am able to select the items and they will show up in the DriverLog table but they are not visible.
- I have the "Item" component set to "Choices(DriverLogs.Employee_DriverLogFK)".
Thanks, kinda small issue but has me stumped.
Jason
Thanks for everyone who helped, it was a quick fix in the end. All I had to do was reference a column in the parent "Employee" table. In my case I referenced the primary key column "EmployeeKey". So the items value for the drop down was Choices(DriverLogs.Employee_DriverLogFK).EmployeeKey.
Hello, @JasonSealy, Make sure that your Parent Table: "Employee" table has values in the Primary Name Column. Lookup columns in Dataverse only show the value in the Primary Name column.
| If my reply helped you, please give a 👍 , & if it solved your issue, please give a 👍 & Accept it as the Solution to help other community members find it more. I am primarily available on weekdays from 6-10 PM CT and 5-10 PM CT on weekends. Visit my Blog: www.powerplatformplace.com Visit my YouTube Channel: https://www.youtube.com/@powerplatformplace/videos |
I think what it is happening is that you might have several records in "DriverLog" with a null value in the "Employee_DriverLogFK" column. If that is the case you can filter the return value from "Choices" function.
So, assuming the Employee table has a column with display name "Full Name", you could try.
Filter(Choices(DriverLogs.Employee_DriverLogFK),'Full Name' <> "")
Check Items and Value in right panel and confirm that has correct column name
Or
Quickest way to trouble shoot is create a form and add the field in the form. Validate if data shown in the dropdown. Take the Item property code from there and paste it in the dropdown above
Hi @JasonSealy ,
To obtain a Choices field from a related table, in the Items property of the Dropdown control, enter the following: Choices(Employee[
Notice after entering the left bracket, all columns associated to the Employee table are available for selection.
------------------------------------------------------------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved. Remember, you can accept more than one post as a solution.
If you like my response, please give it a Thumbs Up.
#1
mmbr1606
22
Super User 2025 Season 1
#2
stampcoin
19
#3
Michael E. Gernaey
15
Super User 2025 Season 1
Share
Report
All responses (
Answers (
