Announcements
how I can show the ID number from database (share point) in power app screen, as showing in attachment all time give me error
Unfortunately, the ID isn't assigned by the system until after a new item is submitted. So you can't show it on creation of a new item. You can show it when editing an existing item.
So I can show the previous ID then +1,
or is there any way?
You should be able to show the previous highest ID +1. But that won't be guaranteed to be the right ID. There are a couple cases where it would show the wrong value.
Could you support me for writing the code to show the highest ID+1
@Anonymous
Something along the lines of this will give you the highest ID+1
First( SortByColumns(YourDataSource, "YourIDField", Descending) ).YourIDField + 1
@timl 's code should do it. But remember that is based on the current highest ID and may or may not represent the next ID to be assigned.
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.
Congratulations to our 2026 Super Users!
Congratulations to our 2025 community superstars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
11manish 551
WarrenBelz 430 Most Valuable Professional
Valantis 298
