Hi team,
User has created an access request form that requires multiple approvals. The approver for each step is dictated by the site and department selected from dropdowns in the form. User has linked a SP list as data source containing columns: SiteName (Text) | Department (Text)| Approver (People or Group).
There does not seem to be a way to filter the approver details in an Approver component based on the site and department selected. I have tried using AI assistant but no joy as the Approver is a required item and cannot be blank.
Is there a way to filter approvers in that component based on selections in the form? Would the type of data source or column type in the SP list dictate whether the approval filtering with work or not? Grateful for any help, even a yes it can work or feature not available, to avoid me going down the rabbit hole.
I like the idea of using the Approver component as it is cleaner than power automate but if there is no solution then I'll have to go the flow route and filter approvals that way.
Derek