Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Apps - Building Power Apps
Answered

Show the actual ID in PowerApps

(0) ShareShare
ReportReport
Posted on by 12,112 Super User 2025 Season 1

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

mmbr1606_0-1699871669453.png

 

  • mmbr1606 Profile Picture
    12,112 Super User 2025 Season 1 on at
    Re: Show the actual ID in PowerApps

    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

  • Verified answer
    SpongYe Profile Picture
    5,580 Super User 2025 Season 1 on at
    Re: Show the actual ID in PowerApps

    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! 🍻

  • mmbr1606 Profile Picture
    12,112 Super User 2025 Season 1 on at
    Re: Show the actual ID in PowerApps

    This should be added to the ID Property Text am i right?

    If yes, i tried  it an still see a blank value 😞

  • SpongYe Profile Picture
    5,580 Super User 2025 Season 1 on at
    Re: Show the actual ID in PowerApps

    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! 🍻

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Markus Franz – Community Spotlight

We are honored to recognize Markus Franz as our April 2025 Community…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,668 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 66,004 Most Valuable Professional

Leaderboard