cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Radio button filter, and Search on Gallery

I want to add radio button filter to my gallery. But dont know how to add it to Items of gallery, which already contains stuff for search.

 

Gallery Items: SortByColumns(Search([@'[dbo].[PaymentVaucher]'], TextSearchBox1.Text, "RequestedBy","AccountingApproval"), "ID", If(SortDescending1, Descending, Ascending))

 

Value for radio button that I want to add to Items of gallery: If(!IsBlank(Radio2.Selected.Value), Filter('[dbo].[PaymentVaucher]', AccountingApproval = Radio2.Selected.Value), '[dbo].[PaymentVaucher]')

 

How would I combine both together?

 

1 ACCEPTED SOLUTION

Accepted Solutions
timl
Super User
Super User

@Anonymous 

You should be able to combine the two formulas like so:

SortByColumns(Search(
              If(!IsBlank(Radio2.Selected.Value), 
                 Filter('[dbo].[PaymentVaucher]', 
                        AccountingApproval = Radio2.Selected.Value), 
                 '[dbo].[PaymentVaucher]'
              ), 
              TextSearchBox1.Text, 
              "RequestedBy","AccountingApproval"), 
              "ID", 
              If(SortDescending1, Descending, Ascending)
)

View solution in original post

1 REPLY 1
timl
Super User
Super User

@Anonymous 

You should be able to combine the two formulas like so:

SortByColumns(Search(
              If(!IsBlank(Radio2.Selected.Value), 
                 Filter('[dbo].[PaymentVaucher]', 
                        AccountingApproval = Radio2.Selected.Value), 
                 '[dbo].[PaymentVaucher]'
              ), 
              TextSearchBox1.Text, 
              "RequestedBy","AccountingApproval"), 
              "ID", 
              If(SortDescending1, Descending, Ascending)
)

View solution in original post

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Users online (2,582)