Using lastRecord or LastSubmit to create ID

(0) Share

Report

Posted on by JeffT2022

137

I have a canvas app linked to a sharepoint list.

I have a field/card called "PR ID" that is blank by default and isn't a text input.

Once a new record is saved, I would like the 'PR ID' field, to take the line ID (created automatically by sharepoint once submitted) and put a "4" in front of it. So if a I saved a record, that had ID# '12345' then the 'PR ID' would save as '412345'.

I have tried using variations of lastRecord, LastSubmit, Patch, etc. and I just can't seem to get the syntax right.

I'm also curious as to where correct syntax should go, possibly OnSuccess in the edit form?

Any help or direction is appreciated.

thank you.

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (2)

Verified answer

LaurensM 12,516 Moderator on at

Like (2)

Report
@JeffT2022 could you try the following code in the submit button:

SubmitForm(FormName); Patch(DataSource, FormName.LastSubmit , {'PR ID': 4 & FormName.LastSubmit.ID});

If this solves your question, would you be so kind as to accept it as a solution.
Thanks!

Was this reply helpful? Yes No
Verified answer

BCBuizer 22,505 Super User 2025 Season 2 on at

Like (2)

Report
Hi @JeffT2022 ,

Try to add a Patch() to the OnSuccess property of the Form, for example:

Patch('DataSource',Form1.LastSubmit,{'PR ID': 4 & Form1.LastSubmit.ID})

Was this reply helpful? Yes No
JeffT2022 137 on at

Like (1)

Report

Both of these methods work, no issues - Thank you both!

Was this reply helpful? Yes No