@JediWookie are you patching data via a form to SharePoint?
If this is the case, an easy way to get the ID after record creation would be the LastSubmit() function.
OnSelect of the form submit button:
//Your code to submit the form
SubmitForm(Form1);
//Updating the Tracker Number
Patch(DataSource, Form1.LastSubmit, {'Tracker Number': Concatenate(Text(Form1.LastSubmit.ID), Text(Form1.LastSubmit.Created, "mmyy"))})
If you don't use a Form and manually patch the record to SharePoint, try this:
//Your code to patch the record initially (this will generate the ID)
//Patch(... Defaults() ...)
//Your code to update the Tracker Number
UpdateContext({varLastRecord: First(Sort(DataSource, Created, Descending))})
Patch(DataSource, varLastRecord, {'Tracker Number': Concatenate(Text(varLastRecord.ID), Text(varLastRecord.Created, "mmyy"))})
Both solutions would update the Tracker Number field instantly after creating the record.
If this solves your question, would you be so kind as to accept it as a solution.
Thanks!
