News and Announcements icon

Dynamics 365 CommunityForums Customer experience | Sales, Customer Insights,... how can we retrieve lo...

Customer experience | Sales, Customer Insights,...

Suggested answer

how can we retrieve lookup field without using expand in java script

(0) Share

Report

Report

Posted on by Community member

I need retrieve values of one lookup field using another lookup field without using expand keyword.

All responses Img

All responses (1)

Answers Img

Answers (0)

Suggested answer

Leah Ju Microsoft Employee on at

Like (0)

Report

how can we retrieve lookup field without using expand in java script

Hi Partner，

Your retrieval of the 'lookup' field is a query on the entity record.

Lookup field: A field that allows setting a reference to a single record of a specific type of entity.

You want to retrieve one lookup based on another lookup, which means you need retrieve current entity and related entity.

If so, an Expand query is the fastest and easiest way to retrieve the related entity record columns through WebApi.

If you insist, try the following two ways:

1.You can query the current entity and then retrieve related entities based on the current entity's guid.

2.Using Fetch XML With WebAPI Using JavaScript

https://carldesouza.com/running-fetchxml-using-xrm-webapi-in-dynamics-365/
I hope you can mark my answer verified if it is helpful! If you have any questions, please feel free to contact me.
Regards,
Leah

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2

Martin Dráb 230,235 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans