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 :
Customer experience | Sales, Customer Insights,...
Answered

Opportunity table Column values only accept 3 digit integer?

(1) ShareShare
ReportReport
Posted on by 15

Because a pick-list of the Opportunity list was no longer in sequence due to an extra new pipeline status, I needed to change the technical values associated with that pick-list table (the sequence is triggered by the technical value, not the display value).

The initial numbers were 9 digits from 750 280 001 to 750 280 011 and I tried to rearrange them but the admin page only accepted 3 digits integer. So I replaced the technical values by numbers from 981 to 991 and saved. 

Problem is now that the opportunity list page displays all the pipeline statuses as blanck. I want to roll-back the technical values to their original 9 digit values but the admin table only accepts 3 digits (see below picture, sorry it is a French application)

Could anyone please help here? 

Opportunity-status-value-display-issue.png

I have the same question (0)
  • Verified answer
    Haig Liu Profile Picture
    Microsoft Employee on at
    RE: Opportunity table Column values only accept 3 digit integer?

    Hi Raphael@goodplanet.org,

    You can try modifying it like this: 

    1.

    pastedimage1677145768813v1.png

    2.

    pastedimage1677145814154v2.png

    3.

    pastedimage1677146024584v4.png

    4.

    pastedimage1677145990512v3.png

    5.

    pastedimage1677146056871v5.png

    Some fields do not have the length setting and need to change the data type. 

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…

Pallavi Phade – Community Spotlight

We are honored to recognize Pallavi Phade as our Community Spotlight honoree for…

Leaderboard > Customer experience | Sales, Customer Insights, CRM

#1
Tom_Gioielli Profile Picture

Tom_Gioielli 152 Super User 2025 Season 2

#2
#ManoVerse Profile Picture

#ManoVerse 103

#3
MVP-Daniyal Khaleel Profile Picture

MVP-Daniyal Khaleel 74

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans