Answered

Patch number of Blank Records depending on numeric value

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hello All,

When I submit a record to SharepointList1 with "Reference" and "Total Loads", I would like it to create a number of records in SharepointList2.

Example - SharepointList1 = Reference: "REF", TotalLoads: "5"

Result - SharepointList2 = Reference: "REF", SubRef: "REF-01",

"REF", SubRef: "REF-02"

"REF", SubRef: "REF-03"

"REF", SubRef: "REF-04"

"REF", SubRef: "REF-05"

Any advice would be appreciated, thank you.

Categories:

Building Power Apps

All responses (4)

Answers (1)

Sort by

mdevaney 29,993 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
@Anonymous

You can create several records using this code. Change the variable values as needed.

Set(varReference, "REF"); Set(varTotalLoads, 5); ForAll( Sequence(varTotalLoads), Patch( SharePointList2, Defaults(SharePointList2), {Reference: varReference, SubRef: varReference&"-"&Text(varTotalLoads,"00")} ) )

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

Like
a
(0)

Report
Copy link

Link copied!
@mdevaney

This almost works, it created the records but the reference's are all the same. Example, I put 4 loads, each ref says the same "REF-04".
How can I get this to increment from 01 until the maximum number, in this case 04? Here's my current code,
Set(varReference, NewPopupConfirmationTextBox.Text); Set(varTotalLoads, Value(NewPopupTotalLoadsTextBox.Text)); ForAll( Sequence(varTotalLoads), Patch( SubCons, Defaults(SubCons), {Confirmation: varReference, SubCon: varReference&"-" & Text(varTotalLoads,"[$-en-GB]00")})

Thanks again for your help, very much appreciated.
Verified answer

RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@Anonymous

Change your Formula to the following:

Set(varReference, NewPopupConfirmationTextBox.Text); Set(varTotalLoads, Value(NewPopupTotalLoadsTextBox.Text)); ForAll( Sequence(varTotalLoads), Patch(SubCons, Defaults(SubCons), {Confirmation: varReference, SubCon: varReference&"-" & Text(Value,"[$-en-GB]00") } )

If you want to reference the Sequence number, you need to use Value.
Community Power Pla... Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

@RandyHayes @mdevaney
That worked, thank you both for your help.