Answered

Dropdown based on ID field

(0) Share

Report

Posted on by MattMcQ

I'm not sure why I'm struggling with this so much but I'm trying to do a simple dropdown control based on an ID field stored in the datasource. In this case I have a "request" table and a "statuscode" table. The request table has a statusID field which is linked to the statuscode table. Let's say there are two values for status code, "1=Open, 2=Closed". I added the code below to the default property but it doesn't appear to work. I have a record that is closed but the dropdown shows open.

This should be simple and something I will need to do often if I am going to work with database tables which often just store the ID of a foreign key instead of the display text.

If(EditForm1.Mode = FormMode.New, LookUp(StatusTable, 1 = StatusID, Status), LookUp(StatusTable, Parent.Default = StatusID, Status))

Categories:

Building Power Apps

All responses (2)

Answers (1)

Sort by

Verified answer

iotc 43 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi, this is how I do it with a combobox control called fkSex_dd
MattMcQ 92 on at

Like
a
(0)

Report
Copy link

Link copied!

Turns out to be user error. My formula for the lookup on the default in the drop down was not using the ID field from the supporting table. I was using StatusID instead of StatusCodeID. Normally I would use the exact same name for the fields but I wonder if that is a good idea. If both tables had "StatusID" then how would the lookup know which to use? If I get the time I should try a test and see what happens. Looking at your example I assume that is partially why have a "fk" prefix on your main table when looking to store the ID from a foreign table.