I am working on an integrated SharePoint form. The title of this form is Project Tracker XXXX. The number is calculated by capturing the last number in a separate column and adding one. In order to do this successfully without accidentally duplicating the number it has to be done OnSave.
If I put a button in the form and use this formula it successfully gets the highest number and creates the title.
Set(varTitle, Set(varCurrID, "Project Tracker " & First(Sort('Indirect Procurement Project Tracker New', 'Curr Form ID', Descending)).'Curr Form ID' + 1))
However if I do this in the SharePointIntegration OnSave property, it captures a number that is about halfway through the existing numbers.
Any suggestions?