Adding an "index" number column to a collection (fast)

(0) Share

Report

Posted on by HansHeintz

704

Hi,

I need to add an index column to a collection so my in my gallery an item can look into the previous item to hide data if it is the same.

I found this code somwhere here which works but on revieweing the speed of the process that builds the collection this step appears to be incredibly slow (3 seconds for 40 items, a bit less than half the total process that involves getting data from dataverse and sql tables). I don't know why it is is so slow but might someone now a quicker way?

;;ForAll(
 Collection1 
 ;Collect(Collection2;
 Last(FirstN(AddColumns(Collection1;
 "SortNr";
 CountRows(Collection2)+1
 ); 
 CountRows(Collection2)+1
 )
 ) 
 )
)

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Verified answer

RandyHayes 76,297 Super User 2024 Season 1 on at

Like (6)

Report
@HansHeintz

Any time you use a ForAll table creating function to act like a ForLoop, you will experience performance issues.

The formula should be the following:

ForAll(Sequence(CountRows(Collection1)); Patch(Last(FirstN(Collection1; Value)); {SortNr: Value}) )

This will return a table with all of your rows of collection1 and an added column with the row number.

I hope this is helpful for you.

Was this reply helpful? Yes No
HansHeintz 704 on at

Like (0)

Report

Thanks! That helps!!
For anyone copy pasting in europe: the , after "FirstN(Collection1" should be an ; of course

Was this reply helpful? Yes No
RandyHayes 76,297 Super User 2024 Season 1 on at

Like (0)

Report

@HansHeintz

I tried to remember to replace commas with semi's...forgot one! I have changed it in the posted formula.

Glad to help.

Was this reply helpful? Yes No
MustafaHussain 173 on at

Like (0)

Report
Hi @RandyHayes
I tried your code but its not working as expected
App OnStart Code:
ClearCollect(MeetingDetailsCol, MeetingDetails); ForAll(Sequence(CountRows(MeetingDetailsCol)); Patch(Last(FirstN(MeetingDetailsCol, Value)), {SortNr: Value}) )

I cant see any Index Column in my collection any help?

Was this reply helpful? Yes No
Daved5 54 on at

Like (1)

Report

Hello

I got this to work - here is how i used it - first I added the new column to a new collection - colAllUsersSort - (based on old collection colAllUsers)

ClearCollect(colAllUsersSort,
AddColumns(colAllUsers,
"SortNr", 0
)
);

Then I added the sequence number to the new column SortNr

ClearCollect(colAllUsersSort,
ForAll(Sequence(CountRows(colAllUsers)),
Patch(Last(FirstN(colAllUsers, Value)),
{
SortNr: Value
}
)
)
)

1 people found this reply helpful.

Was this reply helpful? Yes No