Automated SharePoint Ticket Numbering

Ayres, Matthew 0 Reputation points

I'm feeling pretty fluent with SharePoint but a complete stranger to Power Automate.  Currently I have a ticketing system, which I've displayed below:



I've been manually filling in the numbering but I've decided this week is going to be the week that I get the numbering to be automated ! I'd prefer to be able to do this without Power Automate but if need be I will learn it for this trick.



SharePoint Development
SharePoint Development
SharePoint: A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.Development: The process of researching, productizing, and refining new or existing technologies.
2,761 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Yanli Jiang - MSFT 22,656 Reputation points Microsoft Vendor

    Hi @Ayres, Matthew ,

    Regarding the automatic filling of list data, there are other ways besides Power Automate.

    1. Use the calculated column

    I observe that your data is regular, and it increases according to the date column next to it. Then you can set Ticket as a calculated column, which can also be automatically filled. You can refer to this article:

    However, this method is not very stable. I tried it in my environment without success. Give it a try if you want.


    1. Using Power Apps

    Power Apps is a great tool for customizing forms. I found a post that seems to be very similar to your needs, you can refer to it.

    If you think it meets your needs, because the current Q&A forum does not support Power Apps, I suggest that if you have any related confusion, you can go to the Power Apps Community to create a new discussion to get more professional help.

    Finally, of course, you can also use Power Automate. Flow is also very powerful. If you want to know the relevant details, you can go to the Power Automate Community to issue a discussion in order to get more targeted help.

    Hope to help you.

    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.