Unanswered

How auto generate ID

(0) Share

Report

Posted on by Tapesh

825

Hi all experts here, do you have any idea how can you create the Autogenerated IDs? as I'm new to this I need help from you people.

such that when the record is created has a unique ID and if deleted should be reset for a new one just as we do it in SQL and EXCEL when the record is created, updated and deleted?

For example:

SPList Name is CashApproval

columns: newly generated after user input

ID	Employee Name	Status
1	Tapesh	Approved
2	Sam	Pending
3	Fiona	Rejected

columns: updated after user edited form

ID	Employee Name	Status
1	Tapesh	Approved
2	Fiona	Pending
3	Sam	Rejected

columns: Deleted and updated after the entry deleted

ID	Employee Name	Status
1	Tapesh	Approved
2	Sam	Rejected

Can this be possible by power apps ID filed/DataCard as the user sends a request form?

Any help is Appreciated or even Idea for getting this thing done.

@v-xida-msft @mdevaney @Eric6 @erik209 @WarrenBelz @eka24

#AutogenerateID #ID #SharepointList

Categories:

Building Power Apps

I have the same question (0)

All responses (12)

Answers (3)

WarrenBelz 153,030 Most Valuable Professional on at

Like (0)

Report

Hi @Tapesh ,
I assume this is SharePoint as you have mentioned SPListName.
So firstly, SharePoint has its own built-in numeric identifier called ID. It needs no management and it automatically generated when a new record is created.
If you want to maintain another separate number, there is a process for that too - just let me know.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No
Verified answer

eka24 20,923 on at

Like (1)

Report

watch the auto ID from Shane Young
https://youtu.be/plKw_xfVfwY

Was this reply helpful? Yes No
Tapesh 825 on at

Like (0)

Report

HI @WarrenBelz
@eka24
Yes, I would like to know more about this how to generate the Id automatically.

Also as you said the sharepoint list is automatically updated, do you know when we use the same ID filed of sharepoint list to update the custome Id Filed, why does it takes the time to show on sharepoint list? also the other reason behind asking you this question is the sharepoint list not been updated as the Record is created or deleted. Here is the Screen Shot of the the Page form my sharepoint list after the record is deleted.

Please!

Thanks

Was this reply helpful? Yes No
eka24 20,923 on at

Like (1)

Report

Check out this
https://youtu.be/b91RBJ42T5w

Was this reply helpful? Yes No
Verified answer

WarrenBelz 153,030 Most Valuable Professional on at

Like (2)

Report
Hi @Tapesh ,
To cover your questions
You did not say how you were updating your custom ID field, but generally a refresh of the data source should see it.
Your point on deleting records is valid - SharePoint does not re-order the list.
However if you want to keep another custom number list away from the ID, then try this - I will call the control (it can be a hidden text box or even a label in a custom card) CustomNo - I will cover the Text box scenario. The Default of this would be (I have used your 'Petty Cash' list):
First( Sort( 'Petty Cash', CustomNo, Descending ) ) .CustomNo + 1
This would add 1 to the highest number in the existing list and put the number in the text box for writing to SharePoint.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No
Verified answer

rebeccas 2,591 on at

Like (2)

Report

I almost always use the ID that is generated by a SharePoint list in my apps. The SharePoint list won't default to show it but you can change the settings to view it if you would like. I often have when my form is submitted as the OnSuccess I do a Patch that puts that ID field in my Title column because there are a few things that works good for.

I came from Access so it is just works good for me like that and when I have multiple list that need a tie point that is what I refer to. List two will have a column that is "ParentID" that is a number column and it stores that ID from list one. You will find that useful on the Flow side also because if you have the ID of an item easy to get to like that you can use the 'Get item' instead of 'Get items', which works much better!

Good luck!

Was this reply helpful? Yes No
WarrenBelz 153,030 Most Valuable Professional on at

Like (1)

Report

Hi @rebeccas ,
I too have an Access background.
Not wanting to get off the subject of this thread too much, but I use the ID and a cross-reference as you do and we actually use Access just as much as PowerApps for bulk editing and Excel reporting directly from SharePoint.

Was this reply helpful? Yes No
rebeccas 2,591 on at

Like (0)

Report

I still use Access too. I mainly use it for doing queries to monitor existing apps and watch for problems when they first launch (duplicates, in one place and not another and should be both, etc.).

I have one now that I am working on that will be the Active data in PowerApps but the archived data they can pull from Access.

Because that is where I started, my PowerApps tend to layout (on the data set-up) similar to how I would have in Access...that is hard to change the mindset on!

Was this reply helpful? Yes No
ArtU 27 on at

Like (0)

Report

Hi

the 'First' function has delegation limit. Do you have other formula instead.

Was this reply helpful? Yes No
WarrenBelz 153,030 Most Valuable Professional on at

Like (0)

Report

@ArtU ,

Yes, but sort does not - so you are only accessing one record, which is (well) within Delegation.

Was this reply helpful? Yes No