Show record ID for the last submitted item in Sharepoint

[Anonymous]

Hi,

I've created an APP where I'm creating a new incident ticket. When I click submit I would like to show the ID for this item.

Even a textbox which will show the ID for the last submitted item would help (then I can just add +1 for the newest item).

Does anyone know how to do this?

I tried to insert a text box with Last("MySharepoint").ID but this did not show the correct ID for the last submitted record.

Regards,

Trond

[yashag2255 · Accepted solution]

Hey @Anonymous 

If you are submitting the record using an edit form, you can directly use the expression below as:

Form1.LastSubmit.ID

Or else, you can use the expression as:

Last(Sort("MySharepoint",ID,Ascending)).ID

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

[Anonymous]

Thanks @yashag2255 ,

Form1.LastSubmit.ID worked perfect!

Thanks for the quick response 😉

Regards,

Trond