SharePoint will use information from Vacancy Title from HR list to filter the candidates from the candidates List to meet the filter criteria. Also,refer below the list schema for the same.
Filter selection criteria:
1)Any candidate that don't belong to the same department and division combination as the vacancy to be filled.
2)All staff members are eligible for any position of any level
3)In case of vacancy notice for a professional staff grade (A1 to A6): All candidates whose grade is 2 levels lower than the vacancy grade or higher
Example: If a A3 is advertised, candidates from A1 to A6 will be filtered in.
4)In case of vacancy notice for a general position (grades P3 to P7), all Candidates with the same grade or higher will be filtered in.
5)If no Candidates meets all the criteria from the vacancy Title, SharePoint will send a notification to HR
6)The shortlist of candidates filtered by Sharepoint based on the above criteria will be available .
List schema
HR List
Vacancy Title (single line of text)
HR Name (person field)Allow multiple selection enabled
Candidates List
Grade dropdown values (A1,A2,A3,A4,A5,A6,A7,P3,P4,P5,P6,P7,others)
Division (single line of Text)
staff members (yes/no) dropdown values
Additionally, I designed the form screen for data submission using PowerApps canvas apps.
Kindly help me with with flow steps and do the needful