Answered

Create dynamic variable as attachment to send as e-mail message with Outlook (dynamic file name)

(0) Share

Report

Posted on by pmontray

I'm trying to attach a file in an Outlook email instance that has been downloaded and saved to my files generated from the first part of this same flow. I don't know how to add this file as an attachment. I've tried creating a variable since the file name will change each time this flow is run. The file path part is the location and name of the file I'm trying to attach to the Outlook email.

I set my variable to 'RootPath' - is that right for what I'm trying to do?

Using 'Send email message through Outlook':

I've run my flow, and it will send the e-mail but no attachment.

I also thought about setting the clipboard text as the path+name of the file, but I can't figure out how to make that as an attachment in the Outlook instance. I get an error saying it must be 'list of files' or no error at all, just no attachment gets sent.

I plan on running this weekly, so what's the best way to attach files on the outlook email message? Ideally it attaches the most recent file that has been added to a specific folder.

Categories:

Power Automate Desktop

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Agnius Bartninkas Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

You should simply put the entire path of the file that you have now used in Get file path part as the variable. You don't need a part of the path. You need the entire path. So, use Set variable to set the entire path to a variable value. Then use that variable as the attachment.

-------------------------------------------------------------------------

If I have answered your question, please mark it as the preferred solution. If you like my response, please give it a Thumbs Up.

I also provide paid consultancy and development services using Power Automate. If you're interested, DM me and we can discuss it.

Was this reply helpful? Yes No
Verified answer

MichaelAnnis 5,727 Moderator on at

Like (1)

Report
Copy link

Link copied!

You can view what %RootPath% is in the variable pane after running up to this point.

I think instead of get file path part, you just want to put the entire filepath you have in that first screenshot into the attachment, that should be good as a file. Except it’s missing an extension, so I would add the proper extension.

if that doesn’t work, then get files, put in the folder and the proper filter, advanced sort by last modified descending, then the top file can be referenced by %Files[0]%.

good luck!

Was this reply helpful? Yes No
pmontray 6 on at

Like (0)

Report
Copy link

Link copied!

The get files, advanced sort by last modified and descending worked!

Thank you so much. I used that and set variable to %Files[0]% and then as the variable in attachments I used %NewVar% and boom I received the e-mail with the latest attachment.

The only thing I need to figure out now is how to close the file (in this case it's excel) that is generated from the earlier steps in the same flow before the e-mail gets sent....

Was this reply helpful? Yes No