cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
arnonel Helper IV
Helper IV

[Potential Bug] CDM lookups

If I have the following entities:

  • Car
    • Name:
    • Interior Color: Lookup to Color entity
    • exterior Color: Lookup to Color entity
  • Color
    • Name (used for lookups above)

 

When I open "Car" in Excel, and put "Red" for interior color, it puts "Red" for exterior color too. Instead of letting me choose 2 seperate colors. 

 

Assume this is a bug?

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Microsoft
Microsoft

Re: [Potential Bug] CDM lookups

Hi Arnonel,

 

We have reproduced this issue. It can be seen in both the Excel Add-in and in a PowerApps app, so the problem appears to be in the data layer. We are investigating more. Thanks for bringing it to our attention!

 

- Chris

 

View solution in original post

11 REPLIES 11
Community Support
Community Support

Re: [Potential Bug] CDM lookups

Hi Arnonel,
                                  
How did you create your custom entities? To reproduce this issue, could you provide your steps?

 

I created two entities Car and Color.
>About Color entity, I opened this entity in Excel and filled “Red” and “Blue” in the Excel, then Published it.
>About Car entity, I added two Custom fields(Interior Color and Exterior Color) and set these two entities to Lookup to Color entity. When I opened this entity in Excel, I can choose separate colors in each column.

 

Please make sure you create proper Custom entities and Custom fields. This article about building a relationship between entities in the Common Data Model could be a reference for you.

 

The article link is:
https://powerapps.microsoft.com/en-us/tutorials/data-platform-entity-lookup/


Best regards,
Mabel Mao

Community Support Team _ Mabel Mao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
arnonel Helper IV
Helper IV

Re: [Potential Bug] CDM lookups

Seriously? 

 

This feels like a canned respone.

 

I have tried to keep it as simple as possible.

 

Can you at least tell me if this is an expected behaviour or a bug?

 

(You dont really want me to say: "I click 'create entity', I create a lookup, etc" do you? From below it should be fairly self explanetory.

 

 

Microsoft
Microsoft

Re: [Potential Bug] CDM lookups

Hi Arnonel,

 

We have reproduced this issue. It can be seen in both the Excel Add-in and in a PowerApps app, so the problem appears to be in the data layer. We are investigating more. Thanks for bringing it to our attention!

 

- Chris

 

View solution in original post

arnonel Helper IV
Helper IV

Re: [Potential Bug] CDM lookups

No worries, thank you for looking into it. Thought I was going crazy.

 

ETA for resolution?

Microsoft
Microsoft

Re: [Potential Bug] CDM lookups

No ETA yet since we just started looking at it. We'll update this thread when we know more.

Thanks

arnonel Helper IV
Helper IV

Re: [Potential Bug] CDM lookups

Any update please?

Microsoft
Microsoft

Re: [Potential Bug] CDM lookups

Apparently this bug didn't get prioritized by one of our teams. I'm following up...

Microsoft
Microsoft

Re: [Potential Bug] CDM lookups

This bug is now assigned and hopefully will be fixed in the next couple of weeks. Thanks for checking in on it! 🙂

Power Apps
Power Apps

Re: [Potential Bug] CDM lookups

Hi Arnonel,

 

We are working on a fix for this.

Helpful resources

Announcements
MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

firstImage

New Ranks and Rank Icons released on April 21!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power Apps Community!

Top Solution Authors
Top Kudoed Authors
Users online (6,033)