Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Service | Customer Service, Contact Center, Fie... / Synchronize Auto Numbe...
Service | Customer Service, Contact Center, Fie...
Answered

Synchronize Auto Number between two databases (CDS)

(0) ShareShare
ReportReport
Posted on by Dy365Fan

Hi

meanwhile there is the possibility in Dynamics to generate autonumber with OOB. This is good :) (but only in the new powerapps designer, not on the classic designer for dynamics - Why Microsoft :) ??)

pastedimage1598270812744v1.png

I have a request to synchronize the autonumber-value from account entit between two different dynamics databases (and two different tenants). I know i can make a web service with custom autonumber generating connected to the two CDS, but maybe is there OOB Way? I have no experience with data connections or with the custom connectors in powerapps. I must have unique common number range for both environments.

Thank you in advance

  • Dy365Fan Profile Picture
    Dy365Fan on at
    RE: Synchronize Auto Number between two databases (CDS)

    Hi Andrew Butenko

    thats worked for my requirement. Thank you.

    And to Gus Gonzalez - Thanks for the hint with the Conditional Unique Auto Number, thats is a requirement in future :)

    Best regards

    Dy365Fan

  • Verified answer
    Gus Gonzalez Profile Picture
    Gus Gonzalez 27,113 on at
    RE: Synchronize Auto Number between two databases (CDS)

    Hello,

    Can you try the solution I detailed in this video?

    I think it can help solving this requirement: www.youtube.com/watch

  • Verified answer
    a33ik Profile Picture
    a33ik 84,325 Most Valuable Professional on at
    RE: Synchronize Auto Number between two databases (CDS)

    Hello,

    Here is the way I see with no-code involved:

    1. In one of environments create the dummy entity with autonumber field and configure that autonumber the way you need.

    2. Create the flow for both of environments that will do following on create of account:

    - create the "dummy" record in the environment from point 1 and get the value of autogenerated field

    - update account with that value

    This customization should cover you requirement.

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

Congratulations 2024 Spotlight Honorees

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December

Congratulations to our December super stars! 🥳

Start Your Super User Journey

Join the ranks of our community heros! 🦹

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,703 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,433 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans