CDM Lookup Values Not Showing Information

[Anonymous]

Hello,

I have an entity (Person) with a defined relationship to itself. In the default lookup fields, I have PrimaryID, FullName, and EmailPrimary selected. I then chose for the create/edit field of the Person lookup to show the Lookup-Person's name as the selection, but the dropdown list does not reveal any possible values. If I choose to show the PrimaryID, it will show all possible Lookup-Persons, but not when I select to show the Lookup-Person's FullName. (Image 1)

Also, if I am able to select a Lookup-Person successfully via their PrimaryID, on the view form it will not show the Lookup-Person's FullName. It will only show that Lookup-Person's PrimaryID. (Image 2)

I have been having issues like this for ALL defined relationships in my CDM. It doesn't matter whether it's a self-referencing relationship or a lookup to another entity. Any help here would be great.

[v-monli-msft]

Hi @Anonymous,

Thanks for your report. I have reproduced your issue. We have reported this to the pg and I will let you know if there is any update later.

Further, for the Lookup performance issue, please take a try to save the lookup entity in a collection, then use the function with the local collection, which would make the performance a little better.

Regards,

Mona

[arnonel]

Any updates on this issue?

[Anonymous]

I have not gotten any updates.

[arnonel]

@v-monli-msft - please can you get an update?

[v-monli-msft · Accepted solution]

Hi @arnonel,

Sorry for the late response. I got the update from pg that this can’t be supported today without taking a significant performance hit. We are working on adding relationship support which will help in this scenario.

For now user can himself add a textbox with just for illustration purposes NameLabel.Text = Lookup( Contact, ​ContactID =ThisItem.AccountContact.ID).FullName

Sorry for the inconvenience.

Regards,

Mona