PowerApps Auto increment id as per choice column

Question

PowerApps Auto increment id as per choice column

Anonymous

Hell everyone,

I am customizing a SharePoint list with PowerApps which have choice filed with colors in to choose from and would like to have auto incrementing number generated to each submission based on selection (choice field).

for example: If user1 chooses Red I want to have 00001 as an id and if another user chooses Blue, I would like that to be 00001. And then if another user chooses Red it should reference the last submission associated with Red and increase by one and same if they choose other colors.

The result should look like below:

Choice	ID Number
Red	00001
Blue	00001
Green	00001
Red	00002
Blue	00002
Green	00002
Red	00003

Thank you in advance!

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

Anonymous

Hi TaTa_87,

Thanks for posting in the community.

According to your description, you want to an auto-increment Number column and the value will be automatically added based on different values in a Choice column. If so, you can build a Power Automate flow to meet your requirement. Based on my search, here is a thread where members discussed a similar requirement. Please view the thread and check if the flow helps.

Also, if you have more concerns about building a flow, since we have a specific channel Microsoft Power Automate Community coping with such building flow questions, you can post a new thread there for expert help.

Thanks for your understanding.

George

0 comments

1 additional answer

Answer 1

Anonymous

Thank you for the suggestion. I have resolved the issue with some PowerApps code.

0 comments

Share via

PowerApps Auto increment id as per choice column

1 additional answer