Answered

Create Rank number of each item in collection when collection is created

(0) Share

Report

Posted on by Bolas

Hi,

I'm looking for some help with patching a rank number to a collection when it is created. The collection will already have a column named rank to add to it. The first item should be the number 1 and should increment through by 1. The code I have below so far initially creates the collection.

With(
 {
 StartDate: Date(
 Year(cmb_ChooseMonth.Selected.Value),
 Month(cmb_ChooseMonth.Selected.Value),
 1
 ),
 EndDate: Date(
 Year(cmb_ChooseMonth.Selected.Value),
 Month(cmb_ChooseMonth.Selected.Value) + 1,
 1
 ) - 1
 },
 ClearCollect(
 colMonthReview,
 Filter(
 EOTMSPNominations,
 Created >= StartDate
 ,
 Created <= EndDate
 )
 )
);

Categories:

Building Power Apps

All responses (5)

Answers (1)

Sort by

v-jefferni Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Bolas ,

Would you like to add an increment ID column to the collection colMonthReview?

If so, please try below formula:

ForAll(Sequence(CountRows(colMonthReview),1),Collect(colMonthReview2,AddColumns(Last(FirstN(colMonthReview,Value)),Rank,Value)))

Best regards,
Verified answer

WarrenBelz 156,750 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @Bolas

Try this

With( { StartDate: Date( Year(cmb_ChooseMonth.Selected.Value), Month(cmb_ChooseMonth.Selected.Value), 1 ), EndDate: Date( Year(cmb_ChooseMonth.Selected.Value), Month(cmb_ChooseMonth.Selected.Value) + 1, 1 ) - 1 }, With( { _Review: Filter( EOTMSPNominations, Created >= StartDate, Created <= EndDate ) }, ClearCollect( colMonthReview, ForAll( Sequence(CountRows(_Review)), Patch( Index( _Review, Value ), {Rank: 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.

MVP (Business Applications) Visit my blog Practical Power Apps
Bolas 13 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks. Is it necessary to create a 2nd collection or can i just addcolumn to comMonthReview?
WarrenBelz 156,750 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Bolas ,

You only need the one collection - colMonthReview which should be produced with what I posted.
Bolas 13 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks. I have used your code. Appreciated 🙂