Power Platform Community Forum Thread Details

I have 2 dataverse tables: ContractItem and Inspection.

I have 1 record in the ContractItem table for testing.

In my powerapps canvas i have a 'new form' which has all the revelant columns to create a new 'Inspection' record.

When it displays the 'ContractItem' field, it shows as a combobox.

The options within that combobox are showing the 'record id', but i want to show the 'name' column - in this case, i want it to show 'Stair's as the option, and not the record id.

I cannot figure out how to change the display field for the combobox - this seemed a lot easier when connected to sharepoint using lookup columns, but this is my first time using dataverse tables.

Further to this, if i add a new record to the 'Inspection' table within dataverse itself, it correctly displays the 'Stairs' name in the lookup column, but for some reason in PowerApps, it only displays the ID in the lookup.

How do i change the column that the combobox searches and displays?

I'm sure it's very simple!

Thanks

Categories:

Microsoft Dataverse with Power Apps

Hi @mt-8 ,

Some things to check in your Dataverse table setup based on the screenshot ending in the "39 pm.png" that has the table structure view from Dataverse.

Verify your Primary Name field on the ContractItem table shows "Stairs" as the value in this Primary Name column.
Verify you have a Lookup column in the Inspection table that set to map to the ContractItem table. This is your N:1 relationship back to the Contract Item.

When looking at the records in Dataverse (like the view you are showing in the screenshot I mentioned) you should see "Stairs" in the value of this column vs. the GUID, if you do then this should look correct in the Canvas App from there.

If not, then please show the code behind the ComboBox in the Canvas App and we can review more.