Hello,
I'm using Microsoft Dynamics Office Add-in to update data in the custom entity and push changes back to FO.
Could you pls point me to the right direction if it's possible to show lookup values in data connector somehow? I need lookup values to be available for custaccount in dataconnector on the right-hand side like it's working out of the box with enum values or date values. So that I could choose account value from right-hand side and not enter it manually. I created a relation on the customer entity but it didn't help. the list is empty. is it doable at all and if yes what should be the approach?
Thanks.
I have solved the issue. I created relations on the entity but towards tables (not entities) and the system allowed to do that but lookups didn't work. When I created relations towards entities(not tables) then lookups began to work. Maybe it would be helpful for someone else in the future.
To my best understanding Excel addins don't support lookup values from its master table.
Hi Azat,
When you created the relation, did you also do a build of the full model (not only the solution/project) and a DB sync?
Hello Andre,
I've read through the article. thanks. Also I found this one
community.dynamics.com/.../how-to-enable-lookup-for-a-field-in-open-in-excel-for-dynamics-365-finance-and-operations
it's said there that only relation should be created on the entity and that's it. I tried to create the relation but the system doesn't react. The lookup doesn't show up.
There is documentation about adding lookup values for Financial Dimensions. I have not tried myself to use the instructions for other entities, but you can give it a try yourself and see if that works: Add lookup values for financial dimensions to Excel templates - Finance & Operations | Dynamics 365 | Microsoft Docs
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.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Andrés Arias as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Sohaib Cheema 785 User Group Leader
André Arnaud de Cal... 626 Super User 2025 Season 2
Martin Dráb 621 Most Valuable Professional
