web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Microsoft Dynamics 365 | Integration, Dataverse...
Answered

Setting up the Default Value for the country on account is picking up wrong Id

(0) ShareShare
ReportReport
Posted on by 22

We got a business rule that sets the default value for the country on the account form on create.

Basically the country value is set to 'Australia' as a default value. Country is a look up field.

Now when I try to create a new account, the value for country on the form is showing as Australia but when I try to save the record I'm getting an error saying -

Record Is Unavailable

The requested record was not found or you do not have sufficient permissions to view it.

The actual error when I download the log file is

pastedimage1662335625705v1.png

I'm getting the similar error when I try to navigate to country from account (by clicking on Australia). but the strange thing is Australia does exist when I query the country .

pastedimage1662335722090v2.png

so why is the business rule picking up the wrong Id value?

I have the same question (0)
  • Akshay AEMO Profile Picture
    22 on at
    RE: Setting up the Default Value for the country on account is picking up wrong Id

    Yes! deactivating the business rule and resetting the country kinda solves the problem. I tried clearing cache but that did not work.

    so hopefully deploying the updated business rule(s) to Prod will resolve the issue because can't really do this in prod.

  • Verified answer
    Community Member Profile Picture
    on at
    RE: Setting up the Default Value for the country on account is picking up wrong Id

    Hi Akshay,

    You mentioned that you got a business rule to set default value, right?

    You can try to deactive it and then set country lookup field manually, Check if the error still occurs.

    Or you can try clear browser cache or change other browser to test again.

  • Akshay AEMO Profile Picture
    22 on at
    RE: Setting up the Default Value for the country on account is picking up wrong Id

    Thanks for the reply. So guid for the country in the url is different than the one in the error message. In the url I can see it's 9198cb07-b02c-ed11-9db1-002248114b1f

    "&pagetype=entityrecord&etn=aemo_country&id=9198cb07-b02c-ed11-9db1-002248114b1f" but the Id in the error message is different. Which is "2cd9b145-cc61-eb11-a812-000d3a6a49c3".

    It is same for any other country I select, the error message got the same id. In terms of permission I'm trying to create an account using sys admin access still the same error.

  • Suggested answer
    Community Member Profile Picture
    on at
    RE: Setting up the Default Value for the country on account is picking up wrong Id

    Hi Akshay,

    Have you check the guid of the Australia record through clicking it in the country view(your second screenshot)?

    You can view the guid in the url after openning the record form:

    pastedimage1662349698729v1.png

    The guid from the URL is the same as the ID of the error message?

    Will you get the same error message if you select other country records?

    Perhaps you can check that the country table privilege for the security role assigned to the current user are sufficient.

    --Microsoft has added a new button on the records called ‘Check Access’ using which user can easily check out their access to the records.

    https://www.inogic.com/blog/2021/02/check-access-to-a-dynamics-365-crm-record-using-check-access-button/ 

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Mansi Soni – Community Spotlight

We are honored to recognize Mansi Soni as our August 2025 Community…

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Microsoft Dynamics 365 | Integration, Dataverse, and general topics

#1
DAnny3211 Profile Picture

DAnny3211 433

#2
Abhilash Warrier Profile Picture

Abhilash Warrier 137 Super User 2025 Season 2

#3
Martin Dráb Profile Picture

Martin Dráb 67 Most Valuable Professional

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans