Answered

Filter Gallery Based on Radio Control and Search Box

(0) Share

Report

Posted on by Phineas

5,331 Moderator

I have Gallery1 (SPList1/Collection1)

I have RadioControl1 (with three options - 'Subject', 'Status', 'Created By'.

I have ComboBox1, which I am using to search Gallery1.

How do I set the Gallery1 Items to display data based on the choice in RadioControl1 and the content entered into ComboBox1?

I have the following in FilterByCategoryRadioCntrl -
Items - ["Subject", "Status", "Created"]

I have the Following in ComboBox1 -
ComboBox1 - Switch(FilterByCategoryRadioCntrl.Selected.Value,
"Subject", RenameColums( Distinct(Collection1, Title), "Result", "Value"))
"Status", [" ", "Under Review"],
"Created By", RenameColumns( Distinct(Collection1, 'Created By), "Result", "Value"))

What do I need in Gallery1 so that is filters and switches based on the 'FilterByCategoryRadioCntrl' selection and 'ComboBox1' search content?

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (1)

Sort by

v-bofeng-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @Phineas ,

Please try:

If( FilterByCategoryRadioCntrl.Selected.Value="Subject", Filter(Collection1,Subject=ComboBox1.Selected.Value), FilterByCategoryRadioCntrl.Selected.Value="Status", Filter(Collection1,Status=ComboBox1.Selected.Value), FilterByCategoryRadioCntrl.Selected.Value="Created By", Filter(Collection1,'Created By'=ComboBox1.Selected.Value) )

Best Regards,

Bof

Was this reply helpful? Yes No
Phineas 5,331 Moderator on at

Like (0)

Report
Copy link

Link copied!

Got it all in.

Getting the following error - "Incompatible types of comparison at the equal sign. These types can't be compared: Record, Table."

I have this in Gallery1 -

If(
FilterByRadioCntrl.Selected.Value="Meeting Subject",
Filter(Collection1,'Meeting Subject' = ComboBox1.Selected),
FilterByRadioCntrl.Selected.Value="Status",
Filter(Collection1,'Status' = ComboBox1.Selected),
FilterByRadioCntrl.Selected.Value="Created By",
Filter(Collection1,'Created By' = ComboBox1.Selected))

The CombBox1 has -
Switch(
FilterByCategoryRadioCntrl.Selected.Value,
"Meeting Subject", RenameColumns( Distinct(Collection1,'Meeting Subject'), "Result", "Value"),
"Status", [" ","Under Review"],
"Created By", RenameColumns( Distinct(Collection1,'Created By'), "Result", "Value"))

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

Like (0)

Report
Copy link

Link copied!

Hi @Phineas ,

Please try:

The CombBox1 -
Switch(
FilterByCategoryRadioCntrl.Selected.Value,
"Meeting Subject", RenameColumns( Distinct(Collection1,'Meeting Subject'), "Result", "Value"),
"Status", [" ","Under Review"],
"Created By", RenameColumns( Distinct(Collection1,'Created By'.Email), "Result", "Value"))

Gallery1 -

If(
FilterByRadioCntrl.Selected.Value="Meeting Subject",
Filter(Collection1,'Meeting Subject' = ComboBox1.Selected.Value),
FilterByRadioCntrl.Selected.Value="Status",
Filter(Collection1,'Status' = ComboBox1.Selected.Value),
FilterByRadioCntrl.Selected.Value="Created By",
Filter(Collection1,'Created By'.Email = ComboBox1.Selected.Value)

)

Best Regards,

Bof

Was this reply helpful? Yes No
Phineas 5,331 Moderator on at

Like (0)

Report
Copy link

Link copied!

The ComboBox1 portion worked.

I am getting the same error(s) with the Gallery formula.

If I use 'Selected' I get -
Incompatible types for comparison. These types can't be compared: Text, Record.

If I use 'SelectedItems I get -
Incompatible types for comparison. These types can't be compared: Text, Table.

Current Gallery Items Formula -
If(CategoryRadioCntrl.Selected.Value="Meeting Subject",
Filter(Collection1,Title = ComboBox1.Selected),
CategoryRadioCntrl.Selected.Value="Status",
Filter(Collection1,'Status'.Value = ComboBox1.Selected),
CategoryRadioCntrl.Selected.Value="Created By",
Filter(Collection1,'Created By'.DisplayName = ComboBox1.Selected))

Was this reply helpful? Yes No
Verified answer

v-bofeng-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @Phineas ,

Please try;

Gallery1 -

If(
FilterByRadioCntrl.Selected.Value="Meeting Subject",
Filter(Collection1,'Meeting Subject' = ComboBox1.Selected.Value),
FilterByRadioCntrl.Selected.Value="Status",
Filter(Collection1,'Status' = ComboBox1.Selected.Value),
FilterByRadioCntrl.Selected.Value="Created By",
Filter(Collection1,'Created By'.Email = ComboBox1.Selected.Value)

)

Best Regards,

Bof

Was this reply helpful? Yes No
Phineas 5,331 Moderator on at

Like (0)

Report
Copy link

Link copied!

I need to add a search, based on whether the logged in user is an 'Associate' (captured in Label1.Text), or not an 'Associate'.

Shall I continue in this chat or start another?

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

Like (0)

Report
Copy link

Link copied!

Hi @Phineas ,

You could try:

Search(

If(
FilterByRadioCntrl.Selected.Value="Meeting Subject",
Filter(Collection1,'Meeting Subject' = ComboBox1.Selected.Value),
FilterByRadioCntrl.Selected.Value="Status",
Filter(Collection1,'Status' = ComboBox1.Selected.Value),
FilterByRadioCntrl.Selected.Value="Created By",
Filter(Collection1,'Created By'.Email = ComboBox1.Selected.Value)

),Label1.Text,"Associate")

Best Regards,
Bof

Was this reply helpful? Yes No