cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Show record ID for the last submitted item in Sharepoint

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

1 ACCEPTED SOLUTION

Accepted Solutions
yashag2255
Dual Super User II
Dual Super User II

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!

View solution in original post

2 REPLIES 2
yashag2255
Dual Super User II
Dual Super User II

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!

View solution in original post

Anonymous
Not applicable

Thanks @yashag2255 ,

Form1.LastSubmit.ID worked perfect!

 

Thanks for the quick response 😉

 

Regards,

Trond

Helpful resources

Announcements
PA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

PA Community Call

Power Apps Community Call

Next call is happening on April 21st at 8a PST.

MBAS Carousel

Sign up for our May 4th event!

May the fourth be with you, join us online!

secondImage

Experience what’s next for Power Apps

See the latest Power Apps innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Top Solution Authors
Top Kudoed Authors
Users online (87,695)