Answered

Filtering a gallery with radio buttons

(0) Share

Report

Posted on by T_A_M

332

I'm working on an app with 2 galleries connected to the same Sharepoint list. The list has a Title column that I use to filter the data in each gallery, using this formula:

Filter('My data source', StartsWith(Title,"Resid"))

Filter('My data source', StartsWith(Title,"Comm"))

I'm using StartsWith because the data in the Title column is an ID that contains numbers at the end. (Such as Residential_1, Residential_2, Community_1, Community_2, etc.). I need the data to be filtered by Titles that start with Resid or Comm.

What I'd like to do is consolidate the two galleries into a single gallery, with two radio buttons beside it that are labeled "Residential" and "Community." When the Residential button is selected, the gallery is filtered by all the Titles that start with "Resid". When the Community button is selected, the gallery is filtered by all the Titles that start with "Comm."

Any suggestions would be appreciated. Thanks!

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

zmorek 3,272 on at

Like
a
(1)

Report
Copy link

Link copied!

Make the Items property of your radio buttons something like this:

Table({Title:"Community",Value:"Comm"},{Title:"Residential",Value:"Resid"})

Then on your gallery:

Filter('My Data Source', StartsWith(Title, RadioButton.Selected.Value))

Was this reply helpful? Yes No
T_A_M 332 on at

Like
a
(0)

Report
Copy link

Link copied!

The filtering works perfectly, but my radio buttons are now labeled "Comm" and "Res." They should be labeled "Community" and "Residential." If I switch Title and Value in the formula, the radio buttons are labeled correctly but the formula doesn't work.

Was this reply helpful? Yes No
Verified answer

zmorek 3,272 on at

Like
a
(0)

Report
Copy link

Link copied!

Then set your Radio's Items property to: Table({Value:"Community",Title:"Comm"},{Value:"Residential",Title:"Resid"})

And the Items property of the gallery to:

Filter('My Data Source', StartsWith(Title, RadioButton.Selected.Title))

Was this reply helpful? Yes No
T_A_M 332 on at

Like
a
(1)

Report
Copy link

Link copied!

That did it. Thank you!!

Was this reply helpful? Yes No