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
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
Did you know that you could restore a deleted flow? Check out this helpful article.
Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.
At the monthly call, connect with other leaders and find out how community makes your experience even better.