Attaching documents to emails

[tiffany]

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!

[ChristianAbata]

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

[tiffany]

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

[efialttes]

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!

[tiffany]

Name	Email	Amount	Invoice File Name	File Location
Tiffany	xxx@testing.com	$10.00	22222.pdf	https://XXX.sharepoint.com/:b:/g/EbqkXaUniyVBpxuMVDS43_ABVaRp_ZZHo2iq_BtfGQDzPw?e=SMnr7R

[tiffany]

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

[tiffany]

@efialttes I think the Get File content using path worked?  Not sure what to do next with the outputs you mentioned....

[ChristianAbata · Accepted solution]

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

[tiffany]

That absolutely worked, thank you so much!!!

[ChristianAbata]

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

[tiffany]

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

[ChristianAbata]

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

[tiffany]

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

[ChristianAbata]

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

[tiffany]

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