Unanswered

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

(0) Share

Report

Posted on by 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!

Categories:

General topics

I have the same question (0)

All responses (15)

Answers (0)

Rhiassuring 8,690 Moderator on at

Like (1)

Report

Possible? Absolutely.

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

Was this reply helpful? Yes No
jchestnut28 31 on at

Like (0)

Report

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"

Was this reply helpful? Yes No
Rhiassuring 8,690 Moderator on at

Like (1)

Report

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.

Was this reply helpful? Yes No
jchestnut28 31 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Rhiassuring 8,690 Moderator on at

Like (1)

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

substring(YourFileNameOutput,0,5)

Was this reply helpful? Yes No
jchestnut28 31 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Rhiassuring 8,690 Moderator on at

Like (1)

Report

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

Was this reply helpful? Yes No
jchestnut28 31 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
jchestnut28 31 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Rhiassuring 8,690 Moderator on at

Like (0)

Report

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?

Was this reply helpful? Yes No