Hi,
I have a SharePoint online list which has a dropdown field called Approver. This approver dropdown should show the users whose Job Title is Vice President of respective dept.
For example: I am from logistics dept. Hence i should see only the Vice President from logistics department in the dropdown. Similarly, other dept should see only their dept VP.
I have details of all users department, jobtitle in SharePoint online user profiles, SQL Server DB.
Once the approver is selected, there should be an email sent to him on submitting the form.
Any technical advice if this can be achieved through powerapps (or) require REST API custom coding ? Sorry, I am new to powerapps hence unable to decide. Thanks