Requirement:
Customer Require every application/records has it own unique number with below format.
Format: ABCBK - Year – Month -Date-RandomNumber
Sample number - ABC – 2022-06-06-001
Steps to Achieve:
Go to the https://make.powerapps.com/
Configuration of AutoNumber in Power Apps
1. Choose you required Tables from the list
2. Choose the list of columns
3. In the top left, create a New Column by clicking on the + New column
4. Give meaningful name to Field
5. Choose the Date Type by clinking on down arrow mark
6. Choose Autonumber Data Type
7. Choose Autonumber Type - (String prefixed number, Date prefixed number and Custom)
for now I have select Custom.
8. Choose your required Formats, by choosing the Append option
9. In Append we have a multiple options - (Add sequential number to format, Add datetime to format and Add random string to format)
for now I have selected Add datetime to format option and I have added String before the datetime
10. Then check your final preview of the autonumber
Finally, you have to save app changes and publish your changes, then only changes will commit.
No comments:
Post a Comment