Hello,
I know how to create an auto-number-field.
https://docs.microsoft.com/en-US/powerapps/maker/common-data-service/autonumber-fields
But how to use it in a form? Is there a Special Need or simply a in entity main form?
And addional important question: Can it depend on another column?
In one entity there are "projects" saved. Each Project has ist unique number.
In next entity there are orders.
Each project contains many orders (relationship)
Autonumbering orders has to counted depending on related project record.
P01 - Project 1
-- O001 - Orderno. 1 for Project 1
-- O002 - Orderno. 1 for Project 1
P02
-- O001 - Orderno. 1 for Project 2
-- O002 - Orderno. 2 for Project 2
I have no need to autonumber all orders … 😉
Ty,
AndKan
Hi, can you create a new Site Setting record with the name Site/EnableCustomPluginError and value True
this will give us the proper error message, another way to see what's causing this is trying to create your Order record via model-driven app
Thank you for information.
It didnt work in my case for me, no number is generated 😞
When Opening the new-form, number inserted.
When I save the new record without input this error occurs:
Should it be a required field?
Or because it is part of a key?
Read-only is a good idea to prevent for user input failure (I tried). But without auto generated ...
I'll try to resolve my depency-auto problem with some Liquid+JS
Best regards,
AndKan
Hi
The existing Auto-Number doesn't allow a dependency on other fields/relationships, so your auto-number for Project and Order wouldn't be related to each other.
once you created the field all you need is to place it in your entity form, I would suggest leaving it as read-only as well.. but there is nothing additional you need to do
------------
If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.
Lucas001
60
Super User 2025 Season 1
Fubar
55
Super User 2025 Season 1
surya narayanan
35