Get email - subject line

(0) Share

Report

Posted on by tana1

131

Hi,

@trice602

We discussed about the workflow 2 week ago. I just tested with my coworker today. It seems to have some issue. Can you please help me?

Let me explain to you some background information:

The purpose of workflow is to screen out the inbox or subfolder of inbox emails (with attachments) and subject beginning with "RFP-200-594", then pursue two tasks

save the attachment into a folder
move the email to another folder (different folder than the currently existing folder)

Last time, we worked on it and I have tested it which was working in my computer. It looks like this:

Today, when we copied the same flow to my coworker's computer. It was partially working. What I meant is out of 48 email, only 15 emails were executed.

I was wondering if "RFP-200-594" in subject line was right? I checked his email folders, and left-over emails are most recent email and most of them has "RFP-200-594-XXX..." in subject line. Therefore, can you please help me if there is way to insert formula (beginning with "RFP-200-594" or contain text string "RFP-200-594" ) into subject line to capture the rest of email?

Thanks, appreciated.

Categories:

General topics

All responses (11)

Answers (0)

Sort by

SudeepGhatakNZ 14,396 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

you could just extract the first 11 characters from the subject using substring function
tana1 131 on at

Like
a
(0)

Report
Copy link

Link copied!

@SudeepGhatakNZ

Thanks for your reply.

Since I am a beginner learning Power Automate, I am wondering "Filter Array" is new action or new step? And in the "Get email (v3)", should I put anything under the field of Subject line? Thanks,

Below is what I have now
SudeepGhatakNZ 14,396 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

If you are only querying a subset of emails (like the unread ones) then a Filter should suffice. You don't need to provide a Search Query
tana1 131 on at

Like
a
(0)

Report
Copy link

Link copied!

So I will leave it empty? can you please confirm?
By the way, I don't know how to get to filter array screen. Tried it but don't know how. Can you teach me? Thanks,
SudeepGhatakNZ 14,396 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Filter array is an action just like Get emails if you look for it you'll get it.

Then just repeat what I have shown above. You will need to use the expression window to add the substring expression. It will be exactly what I have written
tana1 131 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks for your help! Appreciated!

This is what I have so far

If possible, can you please advise if that is right? I will test it tomorrow. Thanks,
SudeepGhatakNZ 14,396 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Looks good to me. However, why do you have two loops?
tana1 131 on at

Like
a
(0)

Report
Copy link

Link copied!

yes, one is to move attachment to a pre-set folder and second one is for moving the original email to another inbox subfolder. Is that alright?
SudeepGhatakNZ 14,396 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Looks good, see how you go!
tana1 131 on at

Like
a
(0)

Report
Copy link

Link copied!

@SudeepGhatakNZ

Thanks for your confirmation. Yes, I am just about to let you know the result of flow. We have tested and it seemed like it did not pick up the read email with subject line start with "RFP-200-594". May I know if you have easy fix for it? Thanks apprciated!