Answered

Generate Unique ID

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi Dear,

I am building an application to collect some information at the office, I am trying to generate a unique ID based on SharePoint List ID (called raID, auto increment, primary key).

The formula I used OnSelect event is:

UpdateContext({NewID:If(RapidAssessmentEditForm.Mode=FormMode.New, "BSA-00"& Last(listRapidAssessment).raID+1,NewID)});SubmitForm(RapidAssessmentEditForm)

Than assigned the NewID to Default value of a text box at the form RapidAssessmentEditForm:

If(RapidAssessmentEditForm.Mode=FormMode.New,NewID,Parent.Default)

If I used the application by one person, it works well but at the time we have two users, the NewID start duplicate.

Thanks for you support in advance!

Best Regards

Mahmoud

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

WarrenBelz 156,409 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Anonymous ,

On the Save code

If( RapidAssessmentEditForm.Mode=FormMode.New, UpdateContext({vNew:true}) ); SubmitForm(RapidAssessmentEditForm)

Now on the OnSuccess of the Form

If( vNew, UpdateContext( { vNewID:"BSA-00"& Self.LastSubmit.raID, vNew:false } ) )

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
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @WarrenBelz
Thanks for your support, but how to save the value to SharePoint list? I added vNewID as a Default value to code text box, but it did not save the value (as it is generating the vNewID value at OnSuccess, which mean the data submitted to the list.)
If(RapidAssessmentEditForm.Mode=FormMode.New,vNewID,Parent.Default), I tried to remove this statement too, but it dose not save the vNewID to the list.

Best Regards
Mahmoud

Was this reply helpful? Yes No
Verified answer

WarrenBelz 156,409 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @Anonymous ,

Are you trying to save the ID of the new item back to the same item in another field?

If( RapidAssessmentEditForm.Mode=FormMode.New, UpdateContext({vNew:true}) ); SubmitForm(RapidAssessmentEditForm)

OnSuccess

If( vNew, Patch( YourListName, {ID:Self.LastSubmit.ID}, {NewID:"BSA-00"& Self.LastSubmit.raID} ); UpdateContext({vNew:false} )

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