cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
tiffany
Helper I
Helper I

Attaching documents to emails

Hello,

 

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!

 

2020-03-25_9-35-42.jpg

 
1 ACCEPTED SOLUTION

Accepted Solutions

@tiffany  if is a ststic file you can do this.

cont.PNG



Did I answer your question? Please consider to Mark
my post as a solution! to guide others :winking_face:

Proud to be a Flownaut!


If you want you can follow me at www.christianabata.com Quieres contenido en español? Síguenos en Power Automate LA

View solution in original post

14 REPLIES 14
ChristianAbata
Super User
Super User

hi @tiffany  please could you tell me where are your files?



Did I answer your question? Please consider to Mark
my post as a solution! to guide others :winking_face:

Proud to be a Flownaut!


If you want you can follow me at www.christianabata.com Quieres contenido en español? Síguenos en Power Automate LA

Well it's not really a spreadsheet attachment.  They are pdf files, can that not be done?

efialttes
Super User
Super User

Hi!

"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

Thanx!



Each time you click on any of our inspiring answers 'Thumb up' icon...
...an ewok scapes from the stormtroopers.

Be grateful, Thumbs up! Save the Galaxy for free!


Escribo sobre Power Automate en:
https://medium.com/anyone-can-automate/

Proud to be a Flownaut!



 

 NameEmailAmountInvoice File Name File Location
Tiffanyxxx@testing.com $10.00 22222.pdf https://XXX.sharepoint.com/:b:/g/EbqkXaUniyVBpxuMVDS43_ABVaRp_ZZHo2iq_BtfGQDzPw?e=SMnr7R

They are on our sharepoint site.  But we can put them wherever to make this work.

I think the Get File content using path worked?  Not sure what to do next with the outputs you mentioned....2020-03-25_11-01-53.jpg

@tiffany  if is a ststic file you can do this.

cont.PNG



Did I answer your question? Please consider to Mark
my post as a solution! to guide others :winking_face:

Proud to be a Flownaut!


If you want you can follow me at www.christianabata.com Quieres contenido en español? Síguenos en Power Automate LA

View solution in original post

That absolutely worked, thank you so much!!!

@tiffany  you are welcome please considerer to mark my answer as solved. 😉



Did I answer your question? Please consider to Mark
my post as a solution! to guide others :winking_face:

Proud to be a Flownaut!


If you want you can follow me at www.christianabata.com Quieres contenido en español? Síguenos en Power Automate LA

@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.

@tiffany  sure you can concat your answer like concat('$','OLD VALUE NUMBER') your output is going to be $1234



Did I answer your question? Please consider to Mark
my post as a solution! to guide others :winking_face:

Proud to be a Flownaut!


If you want you can follow me at www.christianabata.com Quieres contenido en español? Síguenos en Power Automate LA

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

@tiffany  if you want to conserv .00 just add Float(),



Did I answer your question? Please consider to Mark
my post as a solution! to guide others :winking_face:

Proud to be a Flownaut!


If you want you can follow me at www.christianabata.com Quieres contenido en español? Síguenos en Power Automate LA

Can you send me an example?  I'm not tracking about where i would add the float in the expression.

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Solution Authors
Users online (2,910)