New to Sharepoint and couldn't quite figure this problem out.
I'm trying to create a ticketing system where the numbering is incremental, but the number needs to reset to 1 whenever the fiscal year changes.
I have two columns: one with the Fiscal Year and one with the Ticket ID Number.
The numbers should only increase by 1 with every new item created. But the number should change back to 1 if the year is different.
If there's a way to do this with Power Automate, that would really be helpful!