I have a pretty easy flow that looks up information in a spreadsheet and then sends emails to each person listed in the spreadsheet. I would like to include an attachment on each of those emails. I have the file path of the documents included as a column in the spreadsheet but I'm not sure that's the right way to handle this.
Any advice would be appreciate!
Solved! Go to Solution.
"I have the file path of the documents included as a column"
Can you share an example of File Path currently stored on your Excel?
There is an action block called 'Get file content using path' but not sure if the format you currently store on Excel is compatible. I would suggest you to try adding this action block inside your 'Apply to each' and see if it works. If so, I guess we can use its outputs to add the attachment into the email
|Name||Amount||Invoice File Name||File Location|
@ChristianAbata Marked as solved! Any chance you can help me with formatting an amount? Currently showing up as 100.5 in email but i want it to show $100.50.
That worked except for when the amount cents end in zero. For example when the amount is $100.00 in the spreadsheet, the email only shows $100