Getting sharepoint list ID onsuccess and add text to it.

[vffdd]

Hi

I know this can be done easily enough I can't just seem to hit on the right formula 🙂

I am submitting a canvas form which is creating an item in a Sharepoint List.  OnSuccess I want to take the auto generated sharepointID add a few letters to it and add it to a text column in the sharepoint list as well as showing it on screen...so to create a nice unique reference that is not just a plain number such as the sharepoint ID.

Eg:  autogenerated sharepointId    234     my text column should read   CRQ-234 and ideally show that in a dialogue box that shows on success...

TIA

[mdevaney · Accepted solution]

@vffdd 

You can use the LastSubmit property of the form to retrieve information about what was submitted to SharePoint including the ID number.  Then you can perform a PATCH function to update the record with your desired custom ID number.

Set(lastRecord, Form1.LastSubmit);
Patch(your_datasource_name, ID=lastRecord.ID, {RefColumnName: "CR-"&lastRecord.ID});

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

[vffdd]

Perfec thanks that's all I needed was just having a blank moment !! 🙂