Answered

Drop down items not showing: Canvas App

(0) Share

Report

Posted on by JasonSealy

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

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Ami K 15,679 Super User 2024 Season 1 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Sid_Jafri 478 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Luis Arellano 247 on at

Like (0)

Report

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' <> "")

Was this reply helpful? Yes No

AhmedSalih

6,678 Moderator on at

Like (0)

Report

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

New Project.png

Was this reply helpful? Yes No

Verified answer

JasonSealy 65 on at

Like (0)

Report

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.

Was this reply helpful? Yes No