Unanswered

Sequence Submit Form and auto-numbering item

(0) Share

Report

Posted on by Mjetek404

Is it possible to use the function Submit form anf sequence in one command?

I have a simple SP list. After pressing the button I would like to save the form and call the command to repeat this procedure as many times as there are in the TextInput (I did it with the Patch function, but in my case it is inactive)

ForAll(
 Sequence(Value(TextInput.Text)),
 Patch(
 'Store',
 Defaults('Store'),
 {'Width': DataCardValue1.Text},
 {'Height': DataCardValue2.Text},
 {'SN': varSN+1}
 )

Additionally, I would like to broadcast more numbers to this Item (e.g. 101, 102, 103, 104, ...)

I tried to make it through a variable

Set(varSN,Last('Store')).'SN'

The effect is that the first record is written well (last position + 1) while each subsequent record is written with the same number

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

WarrenBelz 153,026 Most Valuable Professional on at

Like (2)

Report
Hi @Mjetek404 ,

You need to reference the Sequence Value to increment - also the structure below will be much quicker

Patch( 'Store', ForAll( Sequence(Value(TextInput.Text)), { 'Width': DataCardValue1.Text, 'Height': DataCardValue2.Text, 'SN': varSN + Value } ) )

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
Mjetek404 64 on at

Like (0)

Report

Thank you @WarrenBelz , You can help quickly as always 🙂

Was this reply helpful? Yes No