Show the actual ID in PowerApps

(0) Share

Report

Posted on by mmbr1606

14,605 Super User 2025 Season 2

Hey guys

I need to display the current ID of the Item that will be added to the sharepointlist.

what i mean is:

I have a SP-List as datasource. Before i click on new the last Item has the ID (the column genereted of SP per default) 54.

When i click on new i want to see the number 55 and growing (before actually saving the item) in the ID colum.

Right now when i click on new i only see a blank field (see screenshot).

Thanks in advance

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

SpongYe 5,616 Super User 2025 Season 2 on at

Like (0)

Report
Hi @mmbr1606

If you want to predict the ID of the next item to be added, you can add 1 to this result:
Last(Sort(YourSPList, ID, SortOrder.Descending)).ID + 1

If you have any questions or feedback, please let me know. Have a great day! 😊

-----------------------
PowerYsa Power Platform Enthusiast [LinkedIn] | [Youtube]

I love to share my knowledge and learn from others. If you find my posts helpful, please give them a thumbs up 👍 or mark them as a solution ✔️. You can also check out my [@PowerYSA] for some cool solutions and insights. Feel free to connect with me on any of the platforms above. Cheers! 🍻

Was this reply helpful? Yes No
mmbr1606 14,605 Super User 2025 Season 2 on at

Like (0)

Report

This should be added to the ID Property Text am i right?
If yes, i tried it an still see a blank value 😞

Was this reply helpful? Yes No
Verified answer

SpongYe 5,616 Super User 2025 Season 2 on at

Like (0)

Report
Try adding in a Label see if your getting any results:
Last(YourSPList).ID
If you have any questions or feedback, please let me know. Have a great day! 😊

-----------------------
PowerYsa Power Platform Enthusiast [LinkedIn] | [Youtube]

I love to share my knowledge and learn from others. If you find my posts helpful, please give them a thumbs up 👍 or mark them as a solution ✔️. You can also check out my [@PowerYSA] for some cool solutions and insights. Feel free to connect with me on any of the platforms above. Cheers! 🍻

Was this reply helpful? Yes No
mmbr1606 14,605 Super User 2025 Season 2 on at

Like (1)

Report

displaying in a label helps, i also added+1 on the end and it will show me the next free ID in the Text property of the Label

Was this reply helpful? Yes No