So I'm doing a ticket number system, and I need an increment column from 1 to num of items in that day, so it should reset to 1 every day.
Is there any way to do this with using only sharepoint online and microsoft flow?
Thanks for the help
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It only takes a minute to sign up.Sign up to join this community
As long as you have clear understanding on what DAY means, below solution can be applied. If your users are geographically distributed around world, it can get tricky, so please take with pinch of salt.
You can use this in combination of dateyear and number, to keep it unique for every Ticket.
Hope this helps
if current item counter == 1 && Date == Today
add new item with Date = today date + 1, Counter = 1
4 .While creating new item in your existing ticketing application, refer this newly created list (in step 1) to check date and get item ID.
Hope that helps to develop your required solution.