u/PriceProfessional117

I have an Accounts Payable business request for a flow that will work in a shared mailbox and auto forward to other emails based on the vendor name.
I've setup an AI Builder to extract vendor name from an attachment and do a hard coded routing but need some guidance on the next steps.

The vendor name needs to reference a master data list i.e. Vendor = Contoso then send to AP@Mail.com, Vendor = Contoso UK then send to APUK@mail.com etc

I'm thinking a SharePoint master data list where you add/update the vendor and email but feel like there should be a more elegant way to do this?

Anyone built or seen any build guides for something like this?