I am looking to save entries in OneDrive excel from Power Apps once entered,
For saving I used the following code:
Patch(
Records,
Defaults(Records),
{
Unit:'User Input - Unit'.Selected.Value,
Application:'User Input - Application'.Selected.Value
}
)
How can I save records with a sequence of number Eg "AM-2023XX" and increment by "1" for each entry?
Also once the number is generated it should get displayed for the user for future reference.