I have built a basic app which is going to be used on mobile, I have imported a list from SharePoint, but this only gives me the option to sort alphabetically, ascending or descending, our users want to be able to filter the list by various fields. One field is a drop down box of choices, and the other is an employee look up.
I've seen some filtering done on apps for pc but not for mobile, is this even possible?
Solved! Go to Solution.
Im afraid I'm a bit stuck then, I couldnt find any way to filter the data as such so I created a Combo box which drops down with the list of options from the field I wanted to filter by, if you select an option it shows all the items in the list that match this.
However by enabling this I can no longer sort the items in date order, they are automatically showing oldest first. Also when picking what options to add to the combo box, I cannot see all of the fields that are in my sharepoint list, so can only use this for certain filters?
This is the code for the combo box, can I add something to dictate how to sort by created date also?
Filter('Maintenance ONLY LOG!',
'Site Name' = ComboBox1.Selected.'Site Name'||IsBlank(ComboBox1.Selected.'Site Name'))
Keep up to date with current events and community announcements in the Power Apps community.
Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.
Check out the latest Community Blog from the community!