web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics CRM (Archived) Get GUID for state loo...

Microsoft Dynamics CRM (Archived)

Get GUID for state loop up field

(0) Share

Report

Report

Posted on by Community Member

Dear All,

I have a look up field for states now when I need to set value for it I have to have guid for that state.

Liek this: account.Attributes["state"] = new EntityReference("State", new Guid("B4C2A9D2-9D4A-YYYY-XXX-12B796D1D7F2"));*/

Now my question is I don't know guid for each state, what is the best way to retrieve it from CRM?

Thx

*This post is locked for comments

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (0)

Sort by

Suggested answer

Nithya Gopinath 17,078 on at

Like (0)

Report
Copy link

Link copied!

Hi,

You could navigate to the view showing all the records of State entity. Click on Export to Excel in the command bar. Refer the screenshot below.

An Excel Sheet showing the details of all the state records will be downloaded. Once we open the excel sheet, it will be as follows.

The first column of this excel sheet gives you the Guid Ids of the state records. This is one of the easy ways to get the guid id of the records.

Hope this helps you.

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report
Copy link

Link copied!

Refer this:

https://msdn.microsoft.com/en-us/library/microsoft.xrm.sdk.iorganizationservice.retrievemultiple.aspx

Was this reply helpful? Yes No

Helpful resources

News and Announcements

🚀 Season of Sharing Community Challenge Launch! 🚀

Ask A Community Pro

Introducing our New Video Series: Community Spotlight

Quick Links

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1

#2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans