I'm fairly new to Power Automate and haven't been able to figure out how to do the following:
Email comes in with an attachment, I need to forward the email and attachment to a specific distribution group based on the first portion of the attachment's file name. The list of all the distribution groups are in a SharePoint List. I just don't know how to parse the attachment's file name so it can be used to look up the distribution group's email address. Example of a file name:
Shaws-Inventory_May 2020
Shaws is the identifier on my list and the distribution email connected with it will be used in the email that gets forwarded.