Trying to reply to email with attachment based on email subject and jpg name.

[jchestnut28]

I'm trying to create a flow that will reply to an email with an attachment based on the account number that's in the subject line and jpg attachment name.

I set up an online form submission that emails me sign requests and the account number is in the subject line of submitted emails. For example "Rene Garcia - 12345 • Beer Market". When I finish the signage design I export a jpg and name it "12345_PTR_24x36_012623". I would like to make a flow for when I export and save the jpg to my "Proof" folder on onedrive, to reply to the most recent email with that account number with the body text "Ok to print?". Is that possible? Thanks!

[Rhiassuring]

Possible? Absolutely. 

Are you able to show us what you've done so far in your flow?

[jchestnut28]

Well, I haven't really done much besides, starting with an existing flow I found.
"Send specific files created in OneDrive for Business as email attachments"

[Rhiassuring]

I'd say that you'd want a trigger that watches your OneDrive, first of all.  Probably the "when a file is modified" and point it at the specific folder. I don't think it counts as 'created' since it'll already be created, and you're just moving it in.

When it triggers, get the first 5 characters - as that should be your project #, right? 

Get file content for that particular file. 

Get Emails - Top: 1, Subject Filter: your project #. 

Reply to Email - Message ID will come from your "Get Emails". It'll turn into an Apply to Each, but it'll only be 1 since you selected Top 1.  Add your File Name and File Content into those spots, from your "Get File Content" from earlier.

[jchestnut28]

Thank you for the response! I followed your message and I think I got it, but it failed on the get file content. Not sure how to only get the first 5 numbers.

[Rhiassuring]

To get the first 5 characters, you can use a Compose action, and then use the expression 

substring(YourFileNameOutput,0,5)

[jchestnut28]

Still getting stuck on the Get File Content step. Not sure why.

[Rhiassuring]

"Get File Content" should point to the File Identifier, not to the File Name. 

[jchestnut28]

Thanks for your help on this.

I updated to the File Identifier and it ran through the flow. But It's returning a string that I can't use to search in outlook for. I left the substring text as file name but that is pulling that string instead of the file name.

[jchestnut28]

Ok, so I was able to get the account number from the jpg with this method.

Onto the next step. I'm trying to get it to search my inbox for that email but I don't think it's finding it and replying to it.

[Rhiassuring]

 I know it's a dumb question but are you sure you have an email in your inbox (not in a folder) that has that project number (123456) in the subject line?

[jchestnut28]

That was it! I thought it did a general search in my inbox for 123456. I didn't know I had to point it to a specific subfolder in my inbox.

I updated the Get Emails to the subfolder where all the forms get moved to when they arrive in my inbox. It found the email!

Almost there, but I'm running into an issue. I'm using Jotform and the email I receive is from noreply@jotform.com. Usually, when I reply to these email submissions, outlook switches to the correct email address. See diagram.

In the Reply to email v3 settings, I’m using Reply To for the To, but when I check the sent email, it also includes the noreply@jotform.com email. Is this a bug? How can I remove that original email and just use the Reply To setting?

[Rhiassuring]

I would leave out the "To" and see what happens, since it's a Reply.  I can't test since I don't use JotForm. Let me know how it goes though.

[jchestnut28]

I removed the "To" and it only replied to the noreply@jotform.com email instead of the submitter's email. 

Here are the input and output for the last two steps, Get Email and Reply to if this helps.

[VictorIvanidze]

It looks like a bug. You have 2 options:

1) Leave it "as is". The messages to noreply@... will be just ignored

2) Use a GRAPH request instead of "Reply to email (v3)" action.

[jchestnut28]

I'm not familiar with a graph request but I guess I can just leave it as is. Thanks for your reply!