Context:
I am building a voting form (of sorts) for a recurring annual process at work. The form needs to capture nominations, but the total allowed nominations per vote will vary from year to year. I have setup a global variable to indicate what this "total nominations allowed" will be:
Problem:
In order to capture nominations I created a collection that feeds into a gallery control which the user can interact with in order to make their selections.
How can I pre-emptively create the collection and add X empty records based on "total nominations allowed" number above?
I'm trying to avoid the solution below as I would need to adjust this piece of code every year depending on that "total nominations allowed" number:
ClearCollect(colNominations,
{col1: Blank(), col2: Blank(), ... , coln: Blank()},
{col1: Blank(), col2: Blank(), ... , coln: Blank()},
....
{col1: Blank(), col2: Blank(), ... , coln: Blank()}
)
Solved! Go to Solution.
Hello @sigmaNot ,
You can try this to create that collection :
ForAll(Sequence(yourtotalNominationsAllowed_Variable) As totalNominationsAllowed, Collect(colNominations, {Id: totalNominationsAllowed.Value, yourColumn1: Blank(), yourColumn2: Blank()}))
I hope this helps!
Hello @sigmaNot ,
You can try this to create that collection :
ForAll(Sequence(yourtotalNominationsAllowed_Variable) As totalNominationsAllowed, Collect(colNominations, {Id: totalNominationsAllowed.Value, yourColumn1: Blank(), yourColumn2: Blank()}))
I hope this helps!
Exactly what I was looking for!
Was not aware of the Sequence function, but it seems like this is the closest to an index loop that PowerApps offers.
Thanks.
User | Count |
---|---|
126 | |
87 | |
85 | |
75 | |
69 |
User | Count |
---|---|
215 | |
180 | |
139 | |
97 | |
83 |