Power Platform Community Forum Thread Details

My programming skills have gotten rusty, so I can't figure out how to do this.

I'm doing a pretty standard Flow to save attachments sent to an email address in Onedrive. I would like for the name of the file to be NameofSender_EmailSubject_Date.pdf. The name of sender would be the local part of the email address (ie everything before the @ symbol), and the Date I would like formatted such that April 15, 2010 would be 41510.

I assume I need to initialize some variables to pull this information from the email as a string, but I can't figure out how to format into the form I want. Any help would be appreaciated.

Categories:

Building flows

Here is one solution to your issue. I assumed that the files were not PDF files coming in and needed to be converted. I also assumed that there could be more than one attachment. If those assumptions were in error, you can pull the steps associated with those concepts out of the Flow.

I use a variable to store the name part of the email address using the following expression:

substring(triggerBody()?['From'],0,indexOf(triggerBody()?['From'],'@'))

I use a variable to store the date portion of the file name using the following expression:

formatDateTime(triggerBody()?['DateTimeReceived'],'MMddyy')

I use a third variable as a counter that I can increment to use in the file name in order to account for multiple attachments.

If this isn't what you need please post here and I will adjust my Flow. If it is what you need, please post that also.