I’m currently working on a flow that sends emails with attachments based on details from an Excel table. The table contains multiple rows, each with a recipient’s email address.
Here’s what I’m trying to achieve:
- If there are multiple rows for the same recipient, the flow should combine all their data and send just one email.
- Each row corresponds to a zipped folder stored in OneDrive, named according to one of the columns in the table.
- If a zipped folder is missing for a row, the email should still be sent with the combined data, simply skipping that attachment.
I’ve built a flow that mostly works—the emails are sent and attachments are included—but I’m running into an issue where the attachment path shows as invalid.
I’ve been working on this for the past three weeks and I’m still learning, so this might be something simple that I’m overlooking. I’ve attached screenshots for reference. Please let me know if anything is required from my end.
Any guidance or suggestions would be greatly appreciated. Thank you so much for your time and support!