Answered

Filtering a gallery by category

(0) Share

Report

Posted on by ABralln

I am trying to create button functionality that filters a gallery of questions by category. I need to be able to filter to the next category each time the button is selected.

the main filter items property to start the gallery is: Filter(QuestionCol,Category=varCategory), QuestionCol)

varCategory is established by starting the gallery from a main screen.

I then would like to use a button to filter the gallery to the next category of questions. The category and questions are set up like so:

Category 1= 5 questions

Category 2=8 questions

Category 3= 9 questions

etc...

Any help would be appreciated. I believe the answer lies in creating a new variable for the next category of questions but not sure how to execute it.

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

CNT 10,921 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@ABralln You can have another variable to see which category you are in now. In the beginning it will be,

Set(varCurrentCategory,1)

Add a Button saying Next. In the OnSelect,

Set(varCurrentCategory,varCurrentCategory+1);

Switch(varCurrentCategory,

1, Set(varCategory="Category 1",

2, Set(varCategory="Category 2",

3, Set(varCategory="Category 3",

....

)

Please remember to give a 👍 and accept my solution as it will help others in the future.

Was this reply helpful? Yes No
ABralln 12 on at

Like (0)

Report
Copy link

Link copied!

Thanks CNT, I tried the solution but am getting an invalid number of arguments with this part.
1, Set(varCategory="Category 1",
2, Set(varCategory="Category 2",
3, Set(varCategory="Category 3",

Was this reply helpful? Yes No
CNT 10,921 Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!

@ABralln Close brackets ) are missing

1, Set(varCategory="Category 1"),

2, Set(varCategory="Category 2"),

3, Set(varCategory="Category 3"),

Was this reply helpful? Yes No
Verified answer

ABralln 12 on at

Like (0)

Report
Copy link

Link copied!

Thanks CNT, I messed around with it and after removing the "=" it worked, I added a new filter expression, and it works great.

Switch(varCurrentCategory,
1, Set(varCategory,"Category 1"),
2, Set(varCategory,"Category 2"),
3, Set(varCategory,"Category 3)",
....
);Filter(QuestionCol,Category=varCategory))

Was this reply helpful? Yes No