Answered

Process email messages in outlook doesn't run according to order

(0) Share

Report

Posted on by foxngn84

Hi All,

I set a certain actions from launching outlook to process email with certain action. After when it's done all the necessarily processes with each email, it should move that said email to another folder.

First time i completed this flow it able to run & process email from first to last, but now it just randomly process my email list, and for each action it just keep looping the first email.

May i know what's wrong with the flow?

Categories:

Power Automate Desktop

I have the same question (0)

All responses (15)

Answers (1)

Sort by

Agnius Bartninkas Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Why exactly do you need the mouse clicks and the {Return} key? Do you do some more actions in Outlook itself, other than Retrieving the emails and moving them to a folder?

Was this reply helpful? Yes No
foxngn84 95 on at

Like (0)

Report
Copy link

Link copied!

Hi,
The mouse click event was due to PAD unsure why unable to detect the ui element to click. As I need this action to navigate to a email subfolder. All the require email was in this subfolder.

It needs to navigate to subfolder > open each email > scroll down to copy link > launch excel & paste the link > once done, move the email to another subfolder.

Was this reply helpful? Yes No
Agnius Bartninkas Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

You do not need any of that. You can retrieve emails from a specific sub-folder and the resulting list will contain the email messages with their subjects and bodies. You can retrieve the link from there. Will be much more efficient and stable than automating the UI of Outlook.

-------------------------------------------------------------------------
If I have answered your question, please mark it as the preferred solution.
If you like my response, please give it a Thumbs Up.
If you are interested in Power Automate, you might want to follow me on LinkedIn at https://www.linkedin.com/in/agnius-bartninkas/

Was this reply helpful? Yes No
foxngn84 95 on at

Like (0)

Report
Copy link

Link copied!

Yes, i do note that, but how should i get it to open each of the email? As the link inside the email is a button, i have to navigate into the email to get that hyperlink(highlighted in red) by right click & copy it.

kindly advise how should i loop each email and do all the actions? To be honest the last step to move the email to another subfolder is optional, as long as the loop working.

Was this reply helpful? Yes No
Agnius Bartninkas Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

You do not need to physically open the email. You will have a list of emails from the Retrieve emails action. Loop through those and read the Body of the email as %CurrentItem.Body%. This will contain some HTML code that will also have the link. You will then be able to use Parse text to get it.

Was this reply helpful? Yes No
foxngn84 95 on at

Like (0)

Report
Copy link

Link copied!

Thanks. But each of the 4 color button contains dynamic links. How can i pinpoint it to only get the link for the view button?

Was this reply helpful? Yes No
Agnius Bartninkas Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

If you can share the body of the email in plain HTML, I can probably tell you how to parse it. Not really able to do that without seeing it first.

Was this reply helpful? Yes No
foxngn84 95 on at

Like (0)

Report
Copy link

Link copied!

I tried to just copy that part of the View button, will this be sufficient?

<td style='background:#0077CC;padding:12.0pt 12.0pt 12.0pt 12.0pt;
border-radius:20px'>
<a
href="http://de**s.com/.....7213e1ff499">View PO</a>
</td>

Was this reply helpful? Yes No
Agnius Bartninkas Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Use the Parse text action on the body with Regular expressions enabled and use the following pattern as the text to search for:
http[^"]+(?="[^//]*View PO)
This should return the URL for the View PO button, while ignoring other URLs.

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

If you are interested in Power Automate, you might want to follow me on LinkedIn at https://www.linkedin.com/in/agnius-bartninkas/

Was this reply helpful? Yes No
foxngn84 95 on at

Like (0)

Report
Copy link

Link copied!

Thanks for the help so far, I did try to use this to parse text, but not sure why the result return empty.

Was this reply helpful? Yes No