Value +1 based on other column

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hello.

I have a code to let my SignupID go +1 for each new item added.

Currently i am trying to implement it so I have my MainID and my SignupID.

Currently SignupID follows the code below

Patch(
 Deltagerliste;
 Defaults(Deltagerliste);
 {
 SignupID: Text(
 Value(
 First(
 Sort(
 Deltagerliste;
 Value(SignupID);
 Descending
 )
 ).SignupID
 )+1
 );
 Titel: Label1_3.Text;
 MainIDSignup: Label24.Text;
 Brugernavn: User().FullName;
 Deltager: "1";
 PlusOne: If(
 Checkbox1.Visible;
 (If(
 Checkbox1.Value = true;
 Text("1");
 Text("0")
 ));
 Text("0")
 );PlusKids: If(
 Dropdown1.Visible;
 Dropdown1.SelectedText.Value;Text("0"))
 }
)

(and works)

Now I wish to tweak the code so that it always follows the number it reached according to MainID.

For instance

MainID	SignupID
1	1
1	2
1	3
3	1
3	2
4	1
5	1
5	2

Any tips or tricks?

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

Sort by

mdevaney 29,991 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
@Anonymous

You can do this by simply adding a FILTER function in your SignupID argument to look at only records for a particular MainID.

MainID: varMainID, SignupID: Text( Value( First( Sort( Filter(Deltagerliste, MainID=varMainID); Value(SignupID); Descending ) ).SignupID )+1

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hey there @mdevaney

I believe i forgot to tell you that the MainID comes from another sharepoint list called "MainEvent".

Perhaps this is what you are doing with the variable varMainID - but i can't get the variable to work. I feel like i need a Set() or something for that part.

Was this reply helpful? Yes No