Answered

Last Submit ID on NewForm

(0) Share

Report

Posted on by Gottijay1999

i have one form(SharePointForm1) for creating new items and editing items in one screen. i'm hoping i can get the correct approach to retrieving the lD of last submitted item by the current user.
i have read in a couple of articles that you can only get the LastSubmitID from an edit form, which confuses me a little bit.

OnNew

NewForm(SharePointForm1)

OnSave

SubmitForm(SharePointForm1);
Set(varLastSubmittedItem,SharePointForm1.LastSubmit.ID);

i get the ID sometimes, i'm just not sure if this is the right way to do this. And also how to ensure that SharePointForm1 is an EditForm

Categories:

Building Power Apps

All responses (4)

Answers (1)

Sort by

eka24 20,925 on at

Like
a
(0)

Report
Copy link

Link copied!

Use:
Set(varLastSubmittedItem,SharePointForm1.LastSubmit.ID) OnSuccess of the form SharePointForm1

To Edit a form, insert a button and put OnSelect:
EditForm(SharePointForm1)

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.
Gottijay1999 95 on at

Like
a
(0)

Report
Copy link

Link copied!
Onsuccess
Set(varLastSubmittedItem,SharePointForm1.LastSubmit.ID); ResetForm(SharePointForm1); RequestHide()
OnSave
SubmitForm(SharePointForm1); LastSubmitTest.Run(Text(varLastSubmittedItem));
i put the set function in the OnSuccess property as you suggested, and tested it by putting a workflow after the submit function in the OnSave property. the workflow received a blank value. I need the ID to be generated after the submit function. is that possible?
Verified answer

eka24 20,925 on at

Like
a
(0)

Report
Copy link

Link copied!

If you are using the ID in a flow in that process, it not possible.
Try:
SubmitForm
SubmitForm(SharePointForm1)
OnSuccess
Set(varLastSubmittedItem,SharePointForm1.LastSubmit.ID);LastSubmitTest.Run(Text(varLastSubmittedItem));ResetForm(SharePointForm1); RequestHide()

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.
Gottijay1999 95 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you