Generating an ID field that is a number

(0) Share

Report

Posted on by Kirsten2

383

What's the best way to generate a unique ID in PowerApps that is a number?

Most of my research results on generating an ID are timestamps, but those are not technically unique if two users access the app at the same time. Any suggestions, advice, or links to resources that describe how to generate unique IDs will be helpful. I would like it to be numbers.

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

Verified answer

Drrickryp Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

@Kirsten2

I use First(Sort(datasource, ID, Descending)).ID+1

Was this reply helpful? Yes No
Ramole Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@Kirsten2
I see a similar question you have asked and it was market as a solved? dated 1.12.2023

Was this reply helpful? Yes No
Kirsten2 383 on at

Like
a
(0)

Report
Copy link

Link copied!

Does this build off the SharePoint ID and just increment by 1?

Was this reply helpful? Yes No
Drrickryp Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@Kirsten2

Written this way it will build off the SharePoint ID but it would be useful if you wanted to create a "shadow" ID, say call it id1 First(Sort(datasource, id1, Descending)).id1+1

There are advantages to using a "shadow" id in SharePoint. For more information see @WarrenBelz 's blog here

https://www.practicalpowerapps.com/data/constructing-your-first-power-app-before-you-start/

Was this reply helpful? Yes No