I'm a beginner in PowerApps. Id like to know how to filter my gallery based of a value in a column.
The column I created (Status) has 3 options - I only need to show in the gallery values that is not equal to "Completed"
Hoping for you help. Thanks.
Solved! Go to Solution.
If your status column is Choice type, then please use below formula in items properties of gallery:-
Please mark this solution if it fulfill your requirement
SortByColumns(Filter(testing,StartsWith(Refrence,txtSearchField.Text) && (Status.Value="one")),"Title",Ascending)
Above formula is working at my end, you just needs to change the DSN and fields.
Check out the on demand sessions that are available now!
Stay up tp date on the latest blogs and activities in the community News & Announcements.
Features releasing from October 2020 through March 2021
Check out the Power Platform Community Highlights