I'm looking to build a flow with the following steps (in laymans terms)
- The trigger is when a new PDF file is added to a Sharepoint folder, where the title of the file contains a unique identifier (which is not a specific length, it's essentially an address but could be split with other identifiers by a space)
- Next step would be for PowerAutomate to then take a part of the title and search for this in an excel file to find an email address which would also be in Sharepoint (have considered making this a list instead if this is easier)
- Once the email adress has been matched, PowerAutomate would then attach the new file which was added and send to the corresponding email address with a subject/some body text.
The issues I am coming up against are:
- Trying to figure out how to split text using a column field name in Sharepoint rather than a specific string of text
- Which step to use in order to do the matching exercise from the list/excel file
Not sure if this whole process is possible in PowerAutomate.
