Skip to main content

Notifications

Finance | Project Operations, Human Resources, ...
Suggested answer

Configuration lookup values not populating in Excel Add-In

(0) ShareShare
ReportReport
Posted on by 20

Hi All,

Try to export the data from customization table and entity , The data are exporting in excel. 

Connect with excel Add-in, the inserting record is in excel.

Issues: When we try to add new record in excel, some fields are not showing lookup values.

5841653.PNG

Some fields are showing lookup values.

021112.PNG

  • GirishS Profile Picture
    GirishS 27,821 Super User 2024 Season 1 on at
    RE: Configuration lookup values not populating in Excel Add-In for Finance and Operations to Dynamics 365

    After adding relation have you updated the staging table - Just right click the staging table - Select update staging table - Build the project and check. If still doesn't work means try " refresh entity list" on data management.

    Also on the relation property set the Validate property to No and check.

    Thanks,

    Girish S.

  • Suggested answer
    Dax Profile Picture
    Dax 20 on at
    RE: Configuration lookup values not populating in Excel Add-In for Finance and Operations to Dynamics 365

    Hi Girish ,

    Thanks for your reply.

    Yes, already given relation. but not working.

    136016.PNG

  • Suggested answer
    GirishS Profile Picture
    GirishS 27,821 Super User 2024 Season 1 on at
    RE: Configuration lookup values not populating in Excel Add-In for Finance and Operations to Dynamics 365

    Hi Dax,

    For some fields it will automatically show lookup based on some conditions - If you want a lookup for all the required fields you need to add a relation with respective data entities.

    Refer to the below blog.

    Lookup - Open in excel

    Thanks,

    Girish S.

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.

Helpful resources

Quick Links

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Congratulations to the January Top 10 leaders!

Check out the January community rock stars...

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,160 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 230,962 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans