Approval Based on List Lookup?

(0) Share

Report

Posted on by JDupre

Hi all!

I am trying to create a flow for course override requests. I have a Microsoft form that a student submits, those populate to a list. See below:

The teacher approver column gets loaded by a "Search Users (Office 365)" based on the "teacher" input on the form.

I would like the chair column of the "CATS Override Request" list to load based on a search from another list (FACULTY LIST, see below) that searches for the teacher name, finds the corresponding "chair" name, and then searches for that user. I'm stuck and have no idea what to do. (I'm fairly new at this, sorry!)

All responses (1)

Answers (0)

Ryan_B 446 on at

Like (0)

Report
Re: Approval Based on List Lookup?

I think this should be fairly straightforward. You could use a Get items action for the Faculty List that performs a filter query based on the teacher input from the form. Then use the outputs from this action to populate your Chair Approver column.

Here is what your filter query would look like, just swap out the Response Id part with your teacher input field from the form:

Title eq 'Response Id'

Then use an Update item action to populate your Chair Approver column with the Get items output for the Chair column. Your flow should look something like this:

Where it says Title, that should be your Chair output from the Get items action.