Synchronize Auto Number between two databases (CDS)

(0) Share

Report

Posted on by Dy365Fan

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 :) ??)

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

I have the same question (0)

All responses (3)

Answers (2)

Verified answer

a33ik 84,331 Most Valuable Professional on at

Like (2)

Report

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.

Was this reply helpful? Yes No
Verified answer

Gus Gonzalez 27,113 on at

Like (1)

Report

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

Was this reply helpful? Yes No
Dy365Fan on at

Like (0)

Report

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

Was this reply helpful? Yes No