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
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
Are you new to designing flows? What is your biggest struggle with Power Automate Designer? Help us make it more user friendly!