Answered

Collection Update n number of times

(0) Share

Report

Posted on by kevinsa

Hi,

I'm trying to build a powerapp that will update a collection from a form with a certain number of records that will be manipulated further later. In my form I currently have two text inputs fields Name, and Count.

What I want my end result to be, if I enter 'Apple' as Name and '4' as Count, I want to have four records created in the collection with 'Apple' in the 'Name' field. Next, if I enter 'Blueberry' as Name and '10' as Count, I want to have ten records created in the collection with 'Blueberry' in the name. This would be 14 records in total.

Any ideas how to accomplish?

Categories:

Building Power Apps

All responses (3)

Answers (1)

Sort by

RusselThomas 4,014 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @kevinsa ,
Couple of ways you can achieve this - this is how I would do it - add a button and set it's OnSelect: property to
ForAll(Sequence(Value(countInput.Text)), Collect(collectMyCollection, {Name: NameInput.Text}))
This will continue to append to the collection each time you press the button until you use Clear() or ClearCollect().
Note: you can only use Clear() and ClearCollect() outside the ForAll().
Hope this helps,
RT
kevinsa 29 on at

Like
a
(0)

Report
Copy link

Link copied!

HI @RusselThomas ,

Sorry for taking so long to reply - lots of other stuff on the go. Appreciate your reply - I think I may not have clearly expressed where the input data is coming from. I'll give greater insight -

I will have two collections. The first __planning, and the second __confirmed.

In __planning, I am using a two text input fields to append the collection, one is 'fruit' and a second 'count'. In __planning I use it as a temporary storage location as the user may want to make changes as we go. I don't want the user to be populating the __confirmed collection until all they input all their starting data in __planning. The end result is the collection for __planning like below:

fruit count
Apple 4
Blueberry
10

I have a second screen that would display the entire __planning collection allowing the user to review and make any last minute changes. Once the user is satisfied and click a button, I want a new collection to be created based off of data from the __planning collection - not from other control inputs. The end result for the __confirmed collection would look like this:
fruit
Apple
Apple
Apple
Apple
Blueberry
Blueberry
Blueberry
Blueberry
Blueberry
Blueberry
Blueberry
Blueberry
Blueberry
Blueberry
Verified answer

RusselThomas 4,014 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @kevinsa ,
Thanks for clarifying - can I assume then that you have the __planning table part sorted out and you just want to create the __confirmed collection from the __planning collection?
If so, then you can just wrap the above formula in a ForAll() for the planning table as input;
ForAll(__planning, ForAll(Sequence(ThisRecord.count), Collect(__confirmed, {fruit: ThisRecord.fruit})) )

Let me know if that helps,

Kind regards,
RT