Create N number of items based off text box

(0) Share

Report

Posted on by clepere

I have a New Item form that a user fills out and enters a quantity into a text box.

The form should create N number of identical items into a SharePoint List based off the quantity box.

The submit icon uses the following OnSelect:

ForAll(FirstN([TextInput1.Text, 1,2,3,4,5,6,7,8,9,10]),Patch('General Inventory',Defaults('General Inventory'),{Title: DataCardValue5_1.Text,Barcode: DataCardValue6_1.Text,User: DataCardValue9.Selected,Notes: DataCardValue8_1.Text,Attachments: DataCardValue14}));Back()

Only a single item is created in the SharePoint list, however.

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (2)

Sort by

Verified answer

SimonPiquer 255 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi,

You almost had it, try this:

ForAll(FirstN([1,2,3,4,5,6,7,8,9,10],Value(TextInput1.Text)),Patch('General Inventory',Defaults('General Inventory'),{Title: DataCardValue5_1.Text,Barcode: DataCardValue6_1.Text,User: DataCardValue9.Selected,Notes: DataCardValue8_1.Text,Attachments: DataCardValue14}));Back()

Was this reply helpful? Yes No
Verified answer

mdevaney 29,991 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
@clepere

You could use the SEQUENCE function. By using SEQUENCE you do not have to pre-define the number range. The user can add as many new items as they like.

ForAll(Sequence(Value(TextInput1.Text)),Patch('General Inventory',Defaults('General Inventory'),{Title: DataCardValue5_1.Text,Barcode: DataCardValue6_1.Text,User: DataCardValue9.Selected,Notes: DataCardValue8_1.Text,Attachments: DataCardValue14}));Back()

---
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
clepere 8 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you both for the suggestions! They both work like a charm!

Was this reply helpful? Yes No
mdevaney 29,991 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

@clepere

If they both worked you have the ability to select two answers 🙂

---
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
clepere 8 on at

Like
a
(0)

Report
Copy link

Link copied!

Done. Thanks for your time.

Was this reply helpful? Yes No