Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Service | Customer Service, Contact Center, Fie...
Suggested answer

Different Sequence of Auto-Numbering within One Entity

(0) ShareShare
ReportReport
Posted on by 50

Hello All,

I have multiple country names in one entity. I want records of each country to start with it's own auto-number sequencing.

I used XRM tool but but it gives me auto numbering for all records.

For example, country UK records should start with 1001, 1002, 1003,....

                        county Japan records should start with 1001, 1002, 1003,...

   You get the point.  Also, I am not using canvas power apps, I do not have auto number data type

  • Manny Floyd Profile Picture
    Manny Floyd 50 on at
    RE: Different Sequence of Auto-Numbering within One Entity

    Thank you all. I actually used Plugin and it's working like a charm. Now my next task is how to fetch a field value of previous record. For example if Country Japan has value 20, I want next record to pre-populate Country Japan with value 20

  • Suggested answer
    a33ik Profile Picture
    a33ik 84,325 Most Valuable Professional on at
    RE: Different Sequence of Auto-Numbering within One Entity

    Plugin approach will work for sure. Before going that path you should check if you can create that attribute through the code - jonasr.app/.../ I didn't do any work of that kind with on-prem for ages so I don't know if this possibility reached the on-prem platform. Good luck.

  • Manny Floyd Profile Picture
    Manny Floyd 50 on at
    RE: Different Sequence of Auto-Numbering within One Entity

    Hi Andrew, on-prem. I am looking at plug-in approach now. It seems like nothing else will work. Let me if any other options I have.

  • a33ik Profile Picture
    a33ik 84,325 Most Valuable Professional on at
    RE: Different Sequence of Auto-Numbering within One Entity

    Manny,

    Are you online or onprem?

  • Manny Floyd Profile Picture
    Manny Floyd 50 on at
    RE: Different Sequence of Auto-Numbering within One Entity

    Hi Andrew, yes, I looked at that before. At first, I was very excited but then noticed that I do not have data type "auto-number"

    I am in model driven app. It's sometimes confusing to see different types of power-apps/licenses especially for a beginner  like me.

  • Suggested answer
    a33ik Profile Picture
    a33ik 84,325 Most Valuable Professional on at
    RE: Different Sequence of Auto-Numbering within One Entity

    Hello,

    Check this post - jonasr.app/.../

  • Manny Floyd Profile Picture
    Manny Floyd 50 on at
    RE: Different Sequence of Auto-Numbering within One Entity

    Good Morning Leo,  

    new_entryno field is string. see below.

    add(int(outputs('List_records')?['body/new_entryno']),1)

  • LeoAlt Profile Picture
    LeoAlt 16,331 Moderator on at
    RE: Different Sequence of Auto-Numbering within One Entity

    Hi Manny,

    What's the content in the int expression in your Flow?

    Regards,

    Leo

  • Manny Floyd Profile Picture
    Manny Floyd 50 on at
    RE: Different Sequence of Auto-Numbering within One Entity

    Hi Venkata,

    any existing plugins I can use?

  • Suggested answer
    venkatsr Profile Picture
    venkatsr User Group Leader on at
    RE: Different Sequence of Auto-Numbering within One Entity

    Hi,

    If flow does not helps you then go with an plugin ,definitely you can achieve this.

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

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,575 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,493 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans