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

[Syasini]

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 @Syasini ,

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.