Answered

CDM Lookup Values Not Showing Information

(0) Share

Report

Posted on by SupportForce

I have two entities in Common Data Service, Purchase Orders and Address. Purchase Orders has a lookup (POAddress) that looks up addresses in the Address entity. The address entity only has two fields that I use ID and Address (address is all saved in one field). The problem I am having is I have a gallery in my view screen and an edit icon at the top to edit the selected one in the gallery. When I go into the edit screen the address is not showing up. I know the address is right as I can see it in the data when I look at the data online in the entity. It just doesn't show up on my screen. It's fine when I add it just not when I edit it. How do I fix this?

Thanks for the help!

Gavin

Categories:

Building Power Apps

All responses (2)

Answers (1)

Sort by

Verified answer

v-micsh-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
Would you please upload a screenshot of the issue you mentioned?

Based on what I know, the lookup field under Common Data Service could only display the Id field, if here you would like to have it display the proper address, then you need to take use of the lookup () function, for example:

Lookup(AddressEntity, PrimaryId=ThisItem.POAddress.PrimaryId, Address)

Regards,

Michael
SupportForce 45 on at

Like
a
(0)

Report
Copy link

Link copied!

I have two main problems with lookup. The first is in an edit screen lookups won't show what has been selected unless its the PrimaryID field. I have three lookups on this edit screen, Staff Member is showing something because I have told it to use the PrimaryID field but Supplier and Address are not because they are trying to use the Supplier and Address fields instead of the PrimaryID field. I am assuming this is a bug with Powerapps?

The second problem I have is how do I show the selected entry for a lookup field on just a view screen. So for example if I was using labels to show the different fields in a select Gallery Item. I can show all fields but for lookup ones. Is there a formula I can use or do I need to use a different type of field i.e. dropdown box or the likes?

I am desperate to get answers on this so any help you can give will be really appreciated!

Thanks in advance.

Gavin