Hope this is the right place to post this interesting headache I've given myself 😉
Trying to automate the process of emailing budget sheet updates to our team
Have files which are named to include dept codes (FoE, FoB, C1, C2, C3 etc) along with date e.g. "Budget Update FoB 06 December"
All the dept codes are on a SharePoint list with emails of the team in that dept. (list is just populated with my name during testing)
What I'm trying to build is a flow where I add these files into a specific SharePoint folder each month and based on the match to the SharePoint list, it then emails the right dept with the file.
Familiar with how to email the files when they are added, but struggling with how to filter based on the name containing the matched data
screen shots attached of what I've tried so far, which keep giving me the error expression "Contains(Budget Update FOB 06 December,FOB)" is not valid. Have also tried using a condition filter within the flow, but it only achieves a non-match
Both the conditions I'm trying to match are dynamic, file name and contains 'list title' - could this be why?
if anyone can help point me in the right direction, I would be very very grateful!
SharePoint List
