Unanswered

OData lookup field not displaying

(0) Share

Report

Posted on by byst

Hi hope you can help. We have developed an OData V4 api to expose our data to dataverse for use in dynamics crm. It seems fine to query all rows because the lookup drop-down shows the values, but after selecting an item and clicking save on the parent entity causes the name in the lookup field to say "No Name". Here's the details:

Parent entity: Customer Card Type - standard physical table containing a Card Type lookup field

Virtual entity: Card Type - uses microsoft OData V4 Provider just contains ID and Name fields

The Account form has a grid showing Customer Card Type:

Editing or creating a new Customer Card Type:

using where criteria in Advanced Find proves that two of the Customer Card Types have C4D for Card Type and the other one has ESSO, so the data is saving correctly but the grid on Lead (and inside advanced find) doesn't display the name. Strangely if all 3 Customer Card Types are given the same Card Type (eg C4D) the names appear ok in the grid - seems it cant handle multiple values.

I made the OData as simple as possible for testing:

Any ideas? Thanks

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (3)

Answers (0)

EricRegnier 8,720 Most Valuable Professional on at

Like (0)

Report
Hi @bytestrype,

Couple of things to check:

The "(No name)" shows whenever the primary field/column of a table is blank. It is recommended that every row has a primary column value. Here's the definition of the primary column:
"By default, every table contains a Primary Field, which is used by lookup columns when establishing relationships with other tables. Typically the primary column stores the name or primary description of the data stored in the table. You may update the name and display name of the primary column before saving the table for the first time. Also, observe that the primary column also has its own Name box, which functions similarly to the table name described above. The primary column name is autopopulated when a display name is entered, uses the same prefix as the table, and cannot be changed after the table is created."
Make sure that field/column is populated and that your virtual table field/column configure is mapped.

The lookup column/field drop down on Customer Card Type that shows ESSO Net seems to set be another column than the primary column. Can you check the configuration of the View that is bound to the lookup? It seems like it pointing to another field which is why you don't see "(No name)"

Hope this helps!

Was this reply helpful? Yes No
byst 14 on at

Like (0)

Report

Thanks @EricRegnier . i have checked the config and all seems ok. I have made progress, the OData api wasnt handling $filter properly, so now the list works ok
now trying to get the single edit page to display the lookup value.

Was this reply helpful? Yes No
EricRegnier 8,720 Most Valuable Professional on at

Like (0)

Report

Good to hear you made some progress. Do check the Primary Name column as per my previous post so that you don't see "(No Name)"...

Was this reply helpful? Yes No