Unanswered

Automate Login to website with OTP

Like (0) Share

Report

Posted on 3 May 2023 03:06:17 by julian1994acuna

Hi, I am currently working on a project where I need to login to a customer portal and download the report. The flow goes like this:

1. Access Portal

2. Login via email

3. Receive OTP via email (based on login email)

4. Input OTP on portal

5. Download Reports

My current problem is I don't know how to get the OTP sent to email and input it in the portal to be able to login. Any idea how can I do it? Thank you

All responses (5)

Answers (0)

julian1994acuna 53 on 09 May 2023 at 09:08:14

Like (1)

Report

Re: Automate Login to website with OTP

Just an update, I am able to select specific value on the variable by using these:

"To retrieve a specific item of a datatable, use the following notation: %VariableName[RowNumber][ColumnNumber]%. Keep in mind that the RowNumber and the ColumnNumber should be 0 for the first item (row or column)."
julian1994acuna 53 on 09 May 2023 at 07:32:41

Like (0)

Report

Re: Automate Login to website with OTP

Hello,

I'm very new to Power Automate so I apologize in advance if I don't understand some of it.

I am able to retrieve the email. Now the problem is how can I extract the OTP code only? In my current flow, I am able to extract the OTP code only. But the issue is when I call the variable stored with the OTP value, I get 2 OTP Codes instead. How can I select only 1 value?

Variable:

My Flow:

Thanks and Regards,
Julian
julian1994acuna 53 on 09 May 2023 at 07:32:02

Like (0)

Report

Re: Automate Login to website with OTP

Hello,

I'm very new to Power Automate so I apologize in advance if I don't understand some of it.

I am able to retrieve the email. Now the problem is how can I extract the OTP code only? In my current flow, I am able to extract the OTP code only. But the issue is when I call the variable stored with the OTP value, I get 2 OTP Codes instead. How can I select only 1 value?

Variable:

My Flow:

Thanks and Regards,
Julian
Nived_Nambiar 17,621 Super User 2025 Season 1 on 07 May 2023 at 05:11:51

Like (0)

Report

Re: Automate Login to website with OTP

Hi @julian1994acuna

What you can do is

1. Launch the browser to open the website

2. Then make the bot to log in the website

3. Then make the flow to wait for the email regarding OTP to appear in mailbox (as general it may take time)

4. Retrieve the email data and then input OTP details

5. Download the reports

Refer this

Hope it helps !
Jdelavega 106 on 05 May 2023 at 21:43:33

Like (0)

Report

Re: Automate Login to website with OTP

Hi @julian1994acuna

I think you can use the Outlook action to retrieve the email and its attachment. Have you tried this?"