How to get OTP from particular email Address?

[PALKUMARI_PATEL]

I want to get OTP from email list but first how should I unread email that is from “abc@xyz.com” ? Then How should I get OTP from that email body?

Can someone explain me or if possible send me an example flow.
Note : If I have multiple unread emails.
Thank You

[shreyash_shirbhate]

Hi @PALKUMARI_PATEL,

If you have multiple email then you should be having the unique subject for the OTP email right?
SO you can read the email in the above way.

And can you please paste the body here? So that I can help you out with the expression.

Thanks!

[PALKUMARI_PATEL]

Hey @shreyash_shirbhate Thank for responding.

How to filter that email? I mean where ?

And email body is :

Dear PAL,

Your One-Time Passcode is 123456

This code can only be used once and is valid only for 10 minutes. This does not replace your password.

You recently tried to access a secure application from Windows system using Chrome Browser.

If you did not attempt access to a secure application using your credentials, please report the incident to xyz@abc.com

Thank you,
ABC

[shreyash_shirbhate]

@PALKUMARI_PATEL

How to filter that email? I mean where ?

Hi, You can do filter according to the subject. Write the filter condition in the filter property in the properties panel.

Check this for the same.

Get Outlook Mail Messages Filter Filter By Subject

I want to use the filter option on the Get Outlook Mail Messages activity. I am trying to get all emails that contain the subject “Billing”. What I currently have is “[Subject]=‘Billing’” but this does not return anything. What am I doing wrong? I do not want to use a for loop to iterate over emails unless I can mark the ones without Billing as unread. Thank you SOLUTION: "@SQL=urn:schemas:httpmail:subject LIKE '%Your Item%'" OR "@SQL=""http://schemas.microsoft.com/mapi/proptag/0x1000001E""…

[shreyash_shirbhate]

After filtering the email try the below regular expression which will retrieve you the OTP.

@PALKUMARI_PATEL

Regex.Match(YourEmailBodyOutput, [a-z0-9]\d[a-z0-9]).Value

and save the above in String Variable.

Check the match Image:

[PALKUMARI_PATEL]

It only about subject, can I use Sender email address instead of subject to filter?

[PALKUMARI_PATEL]

Got it. If you can provide me a flow that would be a big help. thanks

[shreyash_shirbhate]

You can multiple condition in it @PALKUMARI_PATEL

[shreyash_shirbhate]

Can you please send me the subject here? @PALKUMARI_PATEL

[PALKUMARI_PATEL]

Subject is :

But concern about if other emails have same subject for OTP then ? So that’s why I want to read only particular email address .

[Sam_Abraham (Sam Thomas Abraham)]

Hi @PALKUMARI_PATEL ,
You can verfy whether the particular mail came from a mail id using the expression below"
mail.From.Address.Contains(“”)

Please refer the below link for reference

How to filter emails based on sender s email addresses

[PALKUMARI_PATEL]

Hey @Sam_Abraham Thanks for sharing, I am able to get the emails I want.

[shreyash_shirbhate]

You can always select the top one which is unread.

You will see this option in properties panel. @PALKUMARI_PATEL

in top section do it 1.

Thanks.

[shreyash_shirbhate]

Hi @PALKUMARI_PATEL,

Can you please mark the appropriate post as a solution so that it will be helpful for other forum members!

Thanks!