Gallery Control

(0) Share

Report

Posted on by DHAGZ

162

Good day!.

Asking for assistance regarding gallery control

scenario:

I have drop down control value: ["5" to "10"]

Two(2) Gallery

ex:

If drop down value is 5 then

1st Gallery show 1 - 5 data

2nd Gallery show 6 - 10 data

If drop down value is 6 then

1st Gallery show 1 - 6 data

2nd Gallery show 7 - 12 data

etc...

by Sequencing Data.

Thanks and advance

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Sort by

v-jefferni Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @DHAGZ ,

Could you please share more details? What exactly do you have in Items property of the Dropdown?

Best regards,

Was this reply helpful? Yes No
DHAGZ 162 on at

Like (0)

Report
Copy link

Link copied!

@v-jefferni thank for your response.

What I'm trying to do is sort the data per BATCH.
The drop Down function is control on how many data should load per batch in each gallery control
without duplicating the data.

ex.
If drop down = 5 The results all the gallery should have 5 data per gallery without repeating data.

Was this reply helpful? Yes No
v-jefferni Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @DHAGZ ,

What if there are 8 items in total when selects 5 in Dropdown, Gallery1 shows 1-5 and Gallery2 shows 6-8? And what if there are 15 items in data source then select 5 in Dropdown, ignore 11-15?

Best regards,

Was this reply helpful? Yes No
DHAGZ 162 on at

Like (0)

Report
Copy link

Link copied!

Sir @v-jefferni ex. I have 15 data in data source and I select 5 the distribution of data
Gallery 1 (batch 1)
1
2
3
4
5
Gallery 2 (batch 2)
6
7
8
9
10
Gallery 3 (batch 3)
11
12
13
14
15
etc....
I have 10 galleries and the data source is limited.
I gave only two ex. of galleries to make an example if its possible to work or not. And if its work the formula then very helpful to my project :).

Was this reply helpful? Yes No
Verified answer

v-jefferni Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @DHAGZ ,

If the data source of these Galleries is a collection, you need to add an index column to it:

Clear(COLII);ForAll(Sequence(CountRows(DataSource),1),Collect(COLII,AddColumns(Last(FirstN(DataSource,Value)),"NewID",Value)))

Items of the first Gallery:

Filter(COLII, NewID <= Dropdown1.Selected.Value)

Items of the second Gallery:

Filter(COLII, NewID > Dropdown1.Selected.Value && NewID <= Dropdown1.Selected.Value*2)

and of the third Gallery:

Filter(COLII, NewID > Dropdown1.Selected.Value*2 && NewID <= Dropdown1.Selected.Value*3)

and so on.

I have 12 items in the data source, so when I select 5 in the Dropdown, 3 Galleries behave as below:

If I select 7:

Best regards,

Was this reply helpful? Yes No