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
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)."
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
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
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 !
I think you can use the Outlook action to retrieve the email and its attachment. Have you tried this?"
WarrenBelz
146,771
Most Valuable Professional
RandyHayes
76,287
Super User 2024 Season 1
Pstork1
66,091
Most Valuable Professional