Answered

[Urgent]Auto ID generation item created Editform SharePoint list also attached steps kindly help

(0) Share

Report

Posted on by Veblitz

2,249

I created below steps when I'm trying to submit item in PowerApps form for SharePoint list as data source but issue is ID is stopped working intermittently and suddenly its working, inconsistent behavior.no clue why this is stopped working.

Kindly help

Step 1: Set the below formula in datacard default value for the field

Step 2: In the edit form success property i set the below formula

Auto created ID is only getting created inconsistently when list item is deleted and if you create form newly also sometimes its skipping for some record and getting created suddenly,no clue of this behavior also this is number field in my SharePoint list

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

WarrenBelz 154,930 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!
Hi @Veblitz ,

I will outline some fundamentals (you probably already know them but may jog some thoughts).

When you save your Form, it will write a new ID number (to the new record) and then set your Variable to the next number.

This number is then used as the Default of a Text Box as a Text value in what I assume is another new record.

Unless this is subsequently saved on that form, it will of course disappear and can never be generated again (the new record can only be saved once).

So one question (if I am interpreting your process correctly) is why not simply Patch it OnSuccess

Patch( SPListName, {ID: Self.LastSubmit.ID}, {StaffRosterID: Text(Self.LastSubmit.ID,"00000")} )

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.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No
Veblitz 2,249 on at

Like (0)

Report
Copy link

Link copied!

Thanks for the inputs. Yes correct process.

Unfortunately, I am facing below formula returns error that it has invalid arguments StaffRosterID does not match the expected number ,found type error.

Note: StaffRoster ID is number column in my SharePoint list

Was this reply helpful? Yes No
Verified answer

WarrenBelz 154,930 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
@Veblitz ,

Looking at this again, StaffRosterID is a number, so all you need to do is not use Text() and have the expected input of the text box as a number, however forgetting all of that OnSuccess

Patch( SPListName, {ID: Self.LastSubmit.ID}, {StaffRosterID: Self.LastSubmit.ID} )

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.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No
Veblitz 2,249 on at

Like (0)

Report
Copy link

Link copied!

Much appreciated

Was this reply helpful? Yes No