When a new item is created in a SharePoint list called Sample Setup Form, I would like to reference another SharePoint list called Office Managers to fill in the Office_Manager field in the initial Sample Setup Form list.
For example, If a new record is created in Sample Setup Form, and San Francisco is the Office_Location, then a Flow would automatically update the Office_Manager field with the name Zander Ford
Note: The Office Manager column in the Office Manager’s SharePoint list is a single “person” column.
