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

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Autonumber setting to ...
Power Apps
Answered

Autonumber setting to Default when transferring data from One Environment to another.

(1) ShareShare
ReportReport
Posted on by 2
Dear All,
Here is the scenario:
I have created a table called Department in an environment named "envsimar" (environment type:Developer) with field: DeptID (Autonumber, Autonumber type: String Prefixed number, Prefix: D, Minimum number of digits: 2, Seed value: 10); Example -> DeptID will be stored as D-10, D-11, D-12 .... also it is the primary column for the Department table.
 
When I am trying to transfer the data from "envsimar" environment to another environment named "clientenv", I have to reset the seed value again for the DeptID. Although the data is transferred properly, I have to again configure the seed value accordingly. Is this the default behaviour of power apps or can I do some settings/configuration so that it takes the same seed value as that from the "envsimar" environment? If yes, please provide the steps/references.

Thank you in advance!!!
 
 
 
I have the same question (0)
  • Verified answer
    Fubar Profile Picture
    8,352 Super User 2025 Season 2 on at
    It is the default behavior, and it is what you will want in most situations. Your Dev environment will have less records than your Test, which will have less than your Prod - so when you promote solutions you do not want the Seed to be set back to the value in Dev (as it will start creating duplicates in the higher environments).
    I don't believe there are any settings to alter this behavior - however you can set it programatically or by using one of the plugins to XrmToolBox.
     

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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 721 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 320 Super User 2025 Season 2

#3
Power Platform 1919 Profile Picture

Power Platform 1919 268

Last 30 days Overall leaderboard