Data entity Export(Add lookup)

(0) Share

Report

Posted on by Waed Ayyad

9,023 Super User 2025 Season 2

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?

I have the same question (0)

All responses (5)

Answers (0)

GirishS 27,827 Moderator on at

Like (1)

Report

Data entity Export(Add lookup)

Hi Waed,

Are you referring to Open in excel?

Thanks,

Girish S.

Was this reply helpful? Yes No
Waed Ayyad 9,023 Super User 2025 Season 2 on at

Like (0)

Report

Data entity Export(Add lookup)

Hi Grisihs

Yes, Iam referring to Open in excel?

Was this reply helpful? Yes No
André Arnaud de Cal... 300,716 Super User 2025 Season 2 on at

Like (1)

Report

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.

Was this reply helpful? Yes No
Waed Ayyad 9,023 Super User 2025 Season 2 on at

Like (0)

Report

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

Was this reply helpful? Yes No
André Arnaud de Cal... 300,716 Super User 2025 Season 2 on at

Like (1)

Report

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.

Was this reply helpful? Yes No