Choose items from a collection when we have a minimum and maximum range

(0) Share

Report

Posted on by sachinsoni441

123

Hello folks,

I have an collection that will have n number of records. The user will have two custom dropdowns (which is multiple of 5) to select the minimum and maximum amount of records to be selected from the collection.

Can someone explain how to choose items from a collection when we have a minimum and maximum range?

Thanks in advance!

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Fardy_MADI_2 332 Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hi @sachinsoni441,

If I untenderstand your problem correctly you just have to use the formula bellow to solve this :

ClearCollect( myCol_2, LastN( FirstN(myCol_1, MaxValue), MaxValue - MinValue + 1) )

myCol_1 is the collection with n number of records and myCol_2 is the collection where I select the elements I want.

Was this reply helpful? Yes No
sachinsoni441 123 on at

Like (0)

Report
Copy link

Link copied!

Hello Fardy_MADI,

let me simplify question with an example

For example, if I have 60 items in my collection and a user chooses 5 in the first dropdown and 20 in the second, the new collection should have at least 5 and no more than 20 entries.

Was this reply helpful? Yes No
Verified answer

timl 36,715 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!
Hi sachinsoni441,

So if a user chooses 5 in the first dropdown and 20 in the second and there are fewer than 5 records in the source collection, you want to return 0 rows? If so, something like this should work.

With( { MinValue: Value(DropdownMin.Selected.Value), MaxValue: Value(DropdownMax.Selected.Value), RowCount: CountRows(YourSourceCollection) }, If(RowCount >= MinValue, ClearCollect(ResultCollection, FirstN(YourSourceCollection, MaxValue) ) )

Was this reply helpful? Yes No