Tuesday, November 8, 2022

Autonumber Configuration in Power Apps

 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.



Output
Create a New form Dynamics 365 CRM, then you can see the Application Number.














(Note: This Autonumber will generate when your trying to creating a new record and after saving the record you can get application number)




























No comments:

Post a Comment