Sequence Submit Form and auto-numbering item

Like (0) Share

Report

Posted on 19 Jun 2022 10:12:29 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:

General Questions

Using Apps Using Formulas

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

WarrenBelz 150,995 Most Valuable Professional on 19 Jun 2022 at 10:45:30

Like (2)

Report
Re: Sequence Submit Form and auto-numbering item

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 19 Jun 2022 at 12:05:09

Like (0)

Report

Re: Sequence Submit Form and auto-numbering item

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

Was this reply helpful? Yes No