cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
SoftDevBen
Regular Visitor

Add a Key column to a Collection

I want to add a generated unique key column to a collection, using integers in an ascending order.

 

I had asked this question before, and got an excellent and workable answer from @RandyHayes , but can't find it under my previous account,  BenDonahue, nor anywhere else online. I remember that Last(FirstN()) was used, but haven't been able to figure out how, exactly.

 

Thank you for your assistance.

1 ACCEPTED SOLUTION

Accepted Solutions
RandyHayes
Super User
Super User

@SoftDevBen 

Was it this post?

 

Doesn't seem like it has what you are thinking of, but that was the closest one I could find from you.

 

If you are trying to add a index column to your collection, then you can use this formula:

With({_items: yourCollection},
    ClearCollect(yourCollection,
        ForAll(Sequence(_items),
            Patch(Last(FirstN(items)), {_index: Value})
        )
    )
)
     

 

I hope this is helpful for you.

_____________________________________________________________________________________
Digging it? - Click on the Thumbs Up below. Solved your problem? - Click on Accept as Solution below. Others seeking the same answers will be happy you did.
NOTE: My normal response times will be Mon to Fri from 1 PM to 10 PM UTC (and lots of other times too!)
Check out my PowerApps Videos too! And, follow me on Twitter @RandyHayes

Really want to show your appreciation? Buy Me A Cup Of Coffee!

View solution in original post

2 REPLIES 2
RandyHayes
Super User
Super User

@SoftDevBen 

Was it this post?

 

Doesn't seem like it has what you are thinking of, but that was the closest one I could find from you.

 

If you are trying to add a index column to your collection, then you can use this formula:

With({_items: yourCollection},
    ClearCollect(yourCollection,
        ForAll(Sequence(_items),
            Patch(Last(FirstN(items)), {_index: Value})
        )
    )
)
     

 

I hope this is helpful for you.

_____________________________________________________________________________________
Digging it? - Click on the Thumbs Up below. Solved your problem? - Click on Accept as Solution below. Others seeking the same answers will be happy you did.
NOTE: My normal response times will be Mon to Fri from 1 PM to 10 PM UTC (and lots of other times too!)
Check out my PowerApps Videos too! And, follow me on Twitter @RandyHayes

Really want to show your appreciation? Buy Me A Cup Of Coffee!
SoftDevBen
Regular Visitor

THERE it is!

Sequence!!!

 

Thank you, yet again, @RandyHayes 

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

365 EduCon 768x460.png

Microsoft 365 EduCon

Join us for two optional days of workshops and a 3-day conference, you can choose from over 130 sessions in multiple tracks and 25 workshops.

Top Solution Authors
Users online (4,804)