web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Automate Login to webs...
Power Automate
Unanswered

Automate Login to website with OTP

(0) ShareShare
ReportReport
Posted on by 53

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

I have the same question (0)
  • Jdelavega Profile Picture
    106 on at

    Hi @julian1994acuna 

     

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

  • Nived_Nambiar Profile Picture
    18,138 Super User 2026 Season 1 on at

    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

     

    Nived_Nambiar_0-1683436304744.png

     

     

    Hope it helps !

     

  • julian1994acuna Profile Picture
    53 on at

    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:

    julian1994acuna_1-1683617466697.png

     

    My Flow:

    julian1994acuna_0-1683617400731.png

     

    Thanks and Regards,

    Julian

     

  • julian1994acuna Profile Picture
    53 on at

    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:

    julian1994acuna_1-1683617466697.png

     

    My Flow:

    julian1994acuna_0-1683617400731.png

     

    Thanks and Regards,

    Julian

     

  • julian1994acuna Profile Picture
    53 on at

    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)."

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the April Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Vish WR Profile Picture

Vish WR 1,027

#2
Valantis Profile Picture

Valantis 809

#3
Haque Profile Picture

Haque 645

Last 30 days Overall leaderboard