You’re offline. This is a read only version of the page.
I am working on a Purchase Order Table, Invoice Table, and Link Table in Microsoft Dataverse.
Link Table is created to link Purchase Order and Invoice together. This is to know how many Purchase Order has been invoiced, to know the outstanding balance, outstanding quantity, etc.
My question is... I would like to have an automatic number sequence based on a column common value and reset the sequence if the value changes and generate another sequence based on the new value on the Link Table.
Sample table: Sequence column reset based on the value on the item column
| Item | Sequence |
| Value 1 | 100 |
| Value 1 | 101 |
| Value 1 | 102 |
| Value 2 | 100 |
| Value 2 | 101 |
| Value 2 | 102 |
| Value 2 | 103 |
Thank you and appreciate if someone can see if the above functionality is feasible in Dataverse.
Yes it is possible but there are different ways to go about it.
You’re obviously making a custom auto-number that can be overwritten if a column changes so out of the box auto number won’t work.
If you are ok with asynchronous assignment of ID, push the custom auto numbering to Power Automate. You can define all your criteria there.
if you need it instantly assigned, you can try JavaScript and tie it to the column change event. Note this will only execute when you modify the form, not if you update the value outside the form.
the better answer would be a Plug-In. This is a Pro-Code solution as you need to know C#. I’d avoid unless you’re confortable creating one and supporting it in the future.
PowerFX plugins are now a thing too, it may be possible to execute your criteria in this manner but note they are a relatively new feature.
Thank you @a33ik for sharing the post.
However, I am looking for a solution where the column has a dynamic value and not fixed.
Do we have any other solution for that requirement?
Hello,
Check this post - https://jonasr.app/anm-unique-seq/
#1
WarrenBelz
637
Most Valuable Professional
#2
stampcoin
570
Super User 2025 Season 2
#3
Power Apps 1919
473
Share
Report
All responses (
Answers (
