Answered

Generating Unique Sequential ID Based Off of Sharepoint Lists

(0) Share

Report

Posted on by CU06081315-1

Hello,

I've created a form which intends to input data and populate it into a list in Sharepoint. Each entry needs to have a sequential unique ID. What I'd like to do is:

On Selection of Texas from my dropdown - Pull the highest ID from the list (TX Switching Order Record 2023) and +1 to continue the sequence.

I have a formula built into the Sharepoint list to code it appropriately, but I need to display the current ID on the app.

Sorry if this has been commented on already. I'm new to Power Apps. Screenshots for reference. Thanks in advance.

Formula for the ID and format on the list.Format on the Sharepoint ListDisplay in the app (currently manually inserted)

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

LaurensM 12,516 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!
@cborde3 do you only want the highest ID of the Texas record or all records?
Should you want to have the highest ID of all records you can add the following code to a label (Text property):

"TX" & Text(First(Sort(SharePointList, ID, Descending)).ID + 1), "00000")

You could set the Visible property to: DropDownName.Selected.Value = "Texas". (value might need to be changed to the field name, depending on the use case)

This will sort the list on highest auto ID first and return the first record's Switching Order value.

If this solves your question, would you be so kind as to accept it as a solution.

Was this reply helpful? Yes No
CU06081315-1 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you, this worked!

Was this reply helpful? Yes No