Announcements
If I have the following entities:
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?
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
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.
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
No worries, thank you for looking into it. Thought I was going crazy.
ETA for resolution?
No ETA yet since we just started looking at it. We'll update this thread when we know more.
Thanks
Any update please?
Apparently this bug didn't get prioritized by one of our teams. I'm following up...
This bug is now assigned and hopefully will be fixed in the next couple of weeks. Thanks for checking in on it! 🙂
We are working on a fix for this.
Rough ETA?
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
11manish 350 Super User 2026 Season 2
M Bilal Khan 318
Mohsin Ali 220
