Answered

Filtering a Gallery using radio buttons - need help with the logic

(0) Share

Report

Posted on by ChadVKealey

1,393

I have a gallery of devices (laptops, desktop PCs, etc.) that I want to present to users. There are two criteria that they may use (independently or together) to filter the gallery: Platform (Mac OS X or Windows) and Type (All-in-One, Desktop or Laptop/Tablet). Each criteria has a radio button that by default is blank but may be set to any one of the available choices.

Here is the current formula I'm using:

SortByColumns(Filter(colCurrentDevices,radioPlatform.Selected.Value in 'Operating System'.Value && radioDevType.Selected.Value in 'Device Type'.Value),"DeviceBaseCost",Ascending,"Title",Ascending)

I know that I need some kind of nesting logic in there to adjust what's displayed based on whether they've made a choice in the radio buttons or not, but I'm just spinning my wheels trying to figure it out.

Basically, with the radio buttons blank (no value selected on either), I want to display all of the devices. With one or the other, or both selected, the view should narrow down to only those devices meeting the selected criteria.

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

Jeff_Thorpe 6,085 Super User 2024 Season 1 on at

Like (0)

Report
Here is my attempt at the formula. I am doing this freehand, so there may be some typos.

SortByColumns( If( If(!IsBlank(radioPlatform.Selected.Value) && !IsBlank(radioDevType.Selected.Value), Filter(colCurrentDevices,radioPlatform.Selected.Value in 'Operating System'.Value, radioDevType.Selected.Value in 'Device Type'.Value), If(!IsBlank(radioPlatform.Selected.Value), Filter(colCurrentDevices,radioPlatform.Selected.Value in 'Operating System'.Value), If(!IsBlank(radioDevType.Selected.Value), Filter(colCurrentDevices,radioDevType.Selected.Value in 'Device Type), colCurrentDevices ) ) ) ), "DeviceBaseCost",Ascending,"Title",Ascending)

Was this reply helpful? Yes No
ChadVKealey 1,393 on at

Like (0)

Report
@Jeff_Thorpe , that was almost perfect, but had an extra If in there and was missing a closing '. What I ended up with (which works exactly as I need it to) is:

SortByColumns( If(!IsBlank(radioPlatform.Selected.Value) && !IsBlank(radioDevType.Selected.Value), Filter(colStandardDevices,radioPlatform.Selected.Value in 'Operating System'.Value, radioDevType.Selected.Value in 'Device Type'.Value), If(!IsBlank(radioPlatform.Selected.Value), Filter(colStandardDevices,radioPlatform.Selected.Value in 'Operating System'.Value), If(!IsBlank(radioDevType.Selected.Value), Filter(colStandardDevices,radioDevType.Selected.Value in 'Device Type'.Value),colStandardDevices ) ) ), "DeviceBaseCost",Ascending,"Title",Ascending)
Note: I changed the collection name to "colStandardDevices" because I ended up splitting them into two galleries (Standard Devices and Premium Devices) for clarity within the App.

Was this reply helpful? Yes No