Hoping someone can help, this has me stumped!
I have an excel spreadsheet/table of contact information, from which I have successfully used a flow to populate individual word documents from a template and save them in a folder in OneDrive.
I now need to send an email to each contact with their specific word document attached (would like to avoid using PDFs if I can).
I followed the youtube tutorial by Leila Gharani about adding custom attachments, but it seems to return the condition as false for MOST records. The file names match, I've tried both creating them with a concatenate formula and entering them manually, also tried with and without the extension. Sometimes I can get one or two to work.
I created a fresh spreadsheet with fewer records to test and got 100% success, but when I use my existing spreadsheet it fails. Both files are in OneDrive folders.
Any ideas?
Helpful resources
Power Automate News & Announcements
Keep up to date with current events and community announcements in the Power Automate community.
Community Calls Conversations
A great place where you can stay up to date with community calls and interact with the speakers.
