Announcements
Hello.
I'm creating a apps for case management.
I would like to design the gallery data to be Filtered by the selected radio button.
And, I want to initialize the radio button selection status when the update button was pressed.
Do you know the way?
Hi @Anonymous ,
Have you solved your problem?
If you have solved your problem, please go ahead to click "Accept as Solution" to identify this thread has been solved for other users in this forum.
Best regards,
Hi @Anonymous ,
Could you please share a bit more about the formula you typed within the Items propertyof the Gallery?
Do you want to filter your Gallery items based on the Text Input1 box text and the Radio1 button selected value, and sort the result by Descending?
I have made a test on my side, please take a try with the following workaround:
Set the Items property of the Gallery to following:
If( !IsBlank(Radio1.Selected.Value), SortByColumns(
Filter('YourDataSource', StartsWith(Client, InputText1.Text), Category = Radio1.Selected.Value),
"Case No",
Descending
), SortByColumns(
Filter('YourDataSource', StartsWith(Client, InputText1.Text)),
"Case No",
Descending
) )
Note: I assume that you want to sort your Gallery items based on "Case No" column.
Or
Share
Report
All responses (
Answers (
If(
!IsBlank(Radio1.Selected.Value),
SortByColumns(
Filter('YourDataSource', InputText1.Text in Client, Category = Radio1.Selected.Value),
"Case No",
Descending
),
SortByColumns(
Filter('YourDataSource', InputText1.Text in Client),
"Case No",
Descending
)
)
Please take a try with above formula I provided, then check if the issue is solved.
Best regards,
Hi v-xida-msft
Thanks for a lot of advice.
I was abile to solve it with the following below function.
reset(radio1)
Could I ask other question?
This image is the Case Management I'm making.
I want to make the following three functions
1.Client name filtering when input text
2.Status filtering when checked Radio1 selected
3.Gallery is always sort by Descending
Please tell me the solution.
I'm thinking of input some function in the "Gallery1" but I have not done yet.
Thank you.
Hi @Anonymous ,
Could you please share a screenshot about your app's configuration?
Do you want to filter your Gallery items based on the selected value within the Radio button control, and want to reset the Radio button when the Update button was pressed?
I have made a test on my side, please take a try with the following workaround:
Set the Items proeprty of the Gallery to following:
If(
!IsBlank(Radio1.Selected.Value),
Filter('20190211_case5', Title=Radio1.Selected.Value),
'20190211_case5'
)
On your side, you should type:
If(
!IsBlank(Radio1.Selected.Value),
Filter('YourDataSource', FilteredColumn = Radio1.Selected.Value), /* <-- FilteredColumn represents the column in your data source, which you want to use to compare with the selected value within the Radio button control*/
'YourDataSource'
)
If you want to reset the Radio button control when you presses the "Update" button, please take a try with the following workaround:
Add the following formula within the OnSelect property of the "Update" control:
Reset(Radio1) /* <-- Radio1 represents the Radio button control in your app */
Or
Set the Reset property of the Radio button control to following:
IsReset
Add the following formula within the OnSelect property of the "Update" control:
Set(IsReset, true);Set(IsReset, false)
More details about the Filter function in PowerApps, please check the following article:
Best regards,
#1
WarrenBelz
791
Most Valuable Professional
#2
MS.Ragavendar
410
#3
mmbr1606
275
Super User 2025 Season 1
