[Conditional Approval Flow] Forms output > Match value to a list and return a person > Assign approval to that person
I've read similar topics covering conditional approvals, but not found one close enough to what I'm looking to do.
I'm still missing something which will match the value given in the form to a defined person who will approve it.
This is the what I want to achieve:
Someone fills in a request form (MS Forms). This form contains a cost code field.
Each cost code has a defined owner. So if the form is filled in with code code 5000, the approval should go to the owner for 5000.
It seems that others have done something similar with a Sharepoint list, which contains a column for cost code, and then one for the owner. This list would be static and doesn't need to be updated by the Flow, just used as a lookup. The flow would then match the cost code in the form to one in the list, and then return to associated owner.
The approval step can then reference the associated owner and assign the approval to them.
In summary, Form > Get Form Responses > Look at sharepoint list and return owner > Assign approval to owner
It's the sharepoint integration that I'm currently stuck on.
Any help would be much appreciated, feel like I'm missing something obvious!