Answered

Is there an equivalent of MS Access combo box in PowerPages to 'view the text but input the ID'?

(0) Share

Report

Posted on by MJWhite

338

My tables are related using a numerical ID field. When I use the lookup field on the 'many' table, it shows me a dropdown list of ID fields from the 'one' table, which is no use. I want to be able to view a text field from the 'one' table in the dropdown and use the ID field from the 'one' table to populate the ID field in the 'many' table. This is managed easily in MS Access by a combo box. I can also manage it relatively easily in PowerApps using the Combo or Dropdown. But in PowerPages/Dataverse, I can't find any solution, never mind an easy one.

Categories:

General topics

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

Fubar 8,503 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Relationships between tables are managed via their internal GUID. a Lookup is a foreign key, whilst it is linked by the internal GUID the Lookup will display the value that is held in the Primary Name column (by default for custom Tables yourpublisherprefix_name e.g. new_name) - sounds like you may have populated your id into the primary Name column.

Was this reply helpful? Yes No
MJWhite 338 on at

Like (0)

Report
Copy link

Link copied!

Thanks. I'd almost got there since I raised the ticket, but it is good to have it confirmed. I now have another challenge about how to import data into the dropdown, as attempts so far have failed. I'll go looking for the answer and will raise a separate ticket if I can't find it.

Was this reply helpful? Yes No