Skip to main content

Notifications

Finance | Project Operations, Human Resources, ...
Unanswered

Data entity Export(Add lookup)

(0) ShareShare
ReportReport
Posted on by 7,085 Super User 2025 Season 1
Hi All,
 
I exported projects using Excel Add in's. Is it possible to add lookup to project group field to choose its value from Excel and Can I make it changes based on project type?
 
  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 291,965 Super User 2025 Season 1 on at
    Data entity Export(Add lookup)
    Hi Waed,
     
    Like mentioned, the filtering based on Excel values in other columns is not working with OData. The lookup is not aware of any value present in Excel. 
  • Waed Ayyad Profile Picture
    Waed Ayyad 7,085 Super User 2025 Season 1 on at
    Data entity Export(Add lookup)
    Hi Andre,
     
    Yes, I added code to make project group open as lookup on Excel Add in, but I am not able to filter return data based on selected group type. Is there any MS that prove this case?
     
    Regards,
    Waed
  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 291,965 Super User 2025 Season 1 on at
    Data entity Export(Add lookup)
    Hi Waed,
     
    It is possible to link a data entity to act as a lookup for the project groups. This would require some development work. Note that this will not have dependency on any other field in the Projects entity. Lookups based on other fields from the entity are not supported using OData. You can have such experience in the Dynamics 365 F&O client itself only.
  • Waed Ayyad Profile Picture
    Waed Ayyad 7,085 Super User 2025 Season 1 on at
    Data entity Export(Add lookup)
    Hi Grisihs
     
    Yes, Iam referring to Open in excel?
  • GirishS Profile Picture
    GirishS 27,821 Super User 2024 Season 1 on at
    Data entity Export(Add lookup)
    Hi Waed,
     
    Are you referring to 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…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Vahid Ghafarpour – Community Spotlight

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

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,965 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 230,836 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans