Unanswered

Auto-number

(0) Share

Report

Posted on by AndKanPA

214

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

Categories:

Power Apps portals

I have the same question (0)

All responses (3)

Answers (0)

oliver.rodrigues 9,368 Most Valuable Professional on at

Like (0)

Report

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.

Was this reply helpful? Yes No
AndKanPA 214 on at

Like (0)

Report

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

Was this reply helpful? Yes No
oliver.rodrigues 9,368 Most Valuable Professional on at

Like (0)

Report

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

Was this reply helpful? Yes No