How I can show the ID number when create items

[Salehkhalil]

 

how I can show the ID number from database (share point) in power app screen, as showing in attachment all time give me error 

[Pstork1]

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.

[Salehkhalil · Accepted solution]

So I can show the previous ID then +1,

or is there any way?

[Pstork1]

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.

• A previous entry was created and then deleted.  Deleted IDs won't be reused so the highest ID currently +1 will be one short.
• If two people create items at the same time they might both show the same value for highest ID +1, but the resulting items will have different IDs. Only one would be correct.

[Salehkhalil]

Could you support me for writing the code to show the highest ID+1

[timl · Accepted solution]

@Salehkhalil 

Something along the lines of this will give you the highest ID+1

First(
   SortByColumns(YourDataSource, "YourIDField", Descending)
).YourIDField + 1

[Pstork1]

@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.