Skip to main content

Notifications

Service | Customer Service, Contact Center, Fie...
Suggested answer

Different Sequence of Auto-Numbering within One Entity

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,321 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,321 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,321 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,329 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

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Complete!

🔔 Be sure to subscribe to the new forums you are interested in to stay up to date! 🔔

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,900 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 229,297 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans