I am developing a "job board" type application for an organization using PowerApps and SharePoint Online. The structure of the app is as follows:
- Two SharePoint Lists: One list to collect the application data. One to collect the job announcements when new ones are created.
- PowerApps Forms (one for the applicant to apply for a position and one for the administrator to create the job listing)
- PowerApps Galleries (one to show the applications of the logged in user ("My Applications") and one for administrators to view all the submitted applications ("All Applications")).
- The Applications Gallery have subtitles that list: Job Title, Job ID, Job Classification, Employee Name, etc.
What I need the app to do:
I would like to include a dropdown above the Applications Gallery which would contain the job titles for the positions people are applying for AND have the ability to sort the Applications Gallery by the job titles within the dropdown.
Basically, as job announcements are created in the system, I need the app to dynamically add the job titles to the dropdown which, in turn, the same dropdown will sort the gallery by the job title when an administrator selects one.
Is this a possibility in PowerApps? Thanks to all!
