Answered

Retrieving SharePoint List ID after new form submission

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

I want to return the ID of the inserted row back to my PowerApps screen so that I can then provide a link back to the app.

Is there some kind of function that will give me this ID? This is something I might expect to exist below.

Form.GetLastInsertedId()

Thanks.

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (2)

Sort by

Verified answer

Meneghino 6,949 on at

Like (0)

Report
Copy link

Link copied!

https://powerusers.microsoft.com/t5/Expressions-and-Formulas/Generate-Unique-ID/m-p/74276#M165

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

The LastSubmit only apples to the EditForm. I am creating a record from scratch using NewForm.

Was this reply helpful? Yes No
Meneghino 6,949 on at

Like (0)

Report
Copy link

Link copied!

I never use out-of-the-box forms, you can easily get the value by using Patch() to create a new record.
Point 21 of this post gives an idea.

Was this reply helpful? Yes No
Verified answer

v-micsh-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Hi @Anonymous,

Yes, the LastSubmit property only applies to EditForm.

The EditForm has two mode, Edit Mode for record editing, and New Mode is used for creating new record.

I think here you are using the New mode, but it should be the EditForm control.

So if here you are trying to get the Server side ID once submitted by the EditForm control, this property would work.

For how EditForm works, please check:

Edit form and Display form controls in PowerApps

Further, as @Meneghino suggested, using patch () function would also work. The patch () function would return the record that has been created, including the Server side field.

Quoted:

"The return value of Patch is the record that you modified or created. If you created a record, the return value may include properties that the data source generated automatically."

Reference: Patch() function

Regards,

Michael

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

I am using the NewForm method as I am creating a new record in the SP list. It's basically a booking form. So I think the way to solve it would possibily this Patch function which you both mentioned.

I will have a go later today and see how I get on.

Thanks.

Was this reply helpful? Yes No