Retrieve Sharepoint list ID on Confirmation page after form submit

[Daemagor]

Hey all!

I am looking to retrieve the SharePoint List Item ID when I hit submit on a form in PowerApps.

For example: I click on create a ticket. A new screen will show and I will enter in my ticket's details. When I click on my button to submit my form, onSuccess, the page will navigate to a confirmation page. Here is where I would like to display the ticket ID to the user. 

Is there any way to do this? Does SharePoint have a response back stating that the form that has XYZ in the form was created and has a List ID of ____?

[Daemagor · Accepted solution]

I was able to get the ID by using the following:

EditForm1.LastSubmit.ID

[azzamkaz]

on the confirmation screen what item should i put ?? 

form, text input or what ???

 need help

hope response ASAP thank you 

[azzamkaz]

on the confirmation screen what item should i put ?? 

form, text input or what ???

 need help

hope response ASAP thank you 

[Daemagor]

@azzamkaz,

Depends on what you are trying to do with it. If you just displaying it to the screen, then you would use text.

[azzamkaz]

@Daemagor

you mean "Label" ??

what code should I put on label to show the selected data ?

[Daemagor]

@azzamkaz,

you mean "Label" ??

- Yes, I am talking about using a Label

what code should I put on label to show the selected data ? 

- What do you mean "what code"? If you want to show something from the selected data on a confirmation page, you will need to display it to the user when they get to that page. You need to use LastSubmit to achieve that

[Anonymous]

I am trying to get the sharepoint ID after successfully patching the data from multiple forms into sharepoint list. At the moment, after I click on the submit button, the information is compiled in SP and the user navigates to a confirmation page. I want the ID to be displayed in the confirmation page for record keeping.

Can anyone help with this?

[WarrenBelz]

Hi @Anonymous ,

Not sure why you posted on this old thread - you were lucky someone found it.

You need the LastSubmit() function.

YourFormName.LastSubmit.ID

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

[jhat]

I have used Last Submitted process in the past. Unfortunately it only works when there are no deletions in the list. For example, I had a list and all was well up until someone deleted from the list which through my ID count off by the number of entries deleted: Items 1, 2, 3, 4, 5, 6 were entered, but Item 6 was deleted. When item 7 is entered PowerApps Last Submitted formula will generate ID of 6, but SharePoint will generate the ID as 7. And that's because the SharePoint Auto generated ID (6) was not reused - in other words there are 7 items entered even though one was deleted. Now this only occurs when the last item submitted is deleted before a new item is submitted. 

Now if you are only trying to generate a key to be used to link the SharePoint list this will work fine, but if you are trying to give the customer a glimpse of the list item ID - you may run into issues.