Select random items from collection

(0) Share

Report

Posted on by sachinsoni441

119

Hello folks,

I have 100 records in my collection and want to randomly select any 5, 10 or 30 records and display them in the PowerApps canvas gallery.

Can somebody explain how we can choose any random items from the collection?

Categories:

Power Apps Pro Dev & ISV

I have the same question (0)

All responses (2)

Answers (1)

Suggested answer

SaiRT14 1,990 Super User 2025 Season 2 on at

Like (1)

Report

Hi sachinsoni441 , Pls try the following:

Use the AddColumns function to add a new column to your collection with a random value for each record. ClearCollect(
colWithRandom,
AddColumns(
colOriginal,
"RandomValue",
Rand()
)
);

Use the Sort function to sort the collection by the RandomValue column. ClearCollect(
colSortedRandom,
SortByColumns(
colWithRandom,
"RandomValue",
Ascending
)
);

Use the FirstN function to select the desired number of random records. ClearCollect(
colRandomSubset,
FirstN(
colSortedRandom,
10 // Replace with 5, 30, or any other number
)
);

Set the Items property of the gallery to the colRandomSubset collection: Items: colRandomSubset
--------------

If you want the user to dynamically specify the number of records (e.g., 5, 10, or 30):

ClearCollect(
colRandomSubset,
FirstN(
colSortedRandom,
Value(TextInput_NumRecords.Text) // Use the value from the input
)
);

hope this helps.

Was this reply helpful? Yes No
Verified answer

AndrianaO 213 Moderator on at

Like (1)

Report

Hi! You can try this formula

Set(recordsNumber,5);

ClearCollect(colRandom,FirstN(Shuffle(originalCollection),recordsNumber));

where colRandom is a random collection to display in your gallery, recordsNumber is number of records in that collection, originalCollection is your original collection with 100 records

Let me know if this works!

Was this reply helpful? Yes No