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?
Solved! Go to Solution.
@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)
)
@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)
)
User | Count |
---|---|
258 | |
108 | |
93 | |
57 | |
40 |