Using Power Apps to login to website and pull data

(0) Share

Report

Posted on by atpham

Hello, I am new to Microsoft Power Apps. Can it be used to do the following:

1. Login to a website with my credentials.

2. Click on specified links and set specified parameters on the website to generate Excel exports.

3. Download and save those Excel files on my computer.

4. Repeat everyday automatically.

Thank you!

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Sort by

Verified answer

Pstork1 69,417 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

There's no way to easily do that using Power Apps. But you can try using Power Automate Flow UI. That should work. https://docs.microsoft.com/en-us/power-automate/ui-flows/overview

Was this reply helpful? Yes No
yuxi666 Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Hi @atpham

>1. Login to a website with my credentials.
>2. Click on specified links and set specified parameters on the website to generate Excel exports.
>3. Download and save those Excel files on my computer.
Please reference this :embed-apps-dev function-param
>4. Repeat everyday automatically.
Please reference @Pstork1 's post.

Best Regards.
yuxi

Was this reply helpful? Yes No
mogulman 764 on at

Like (1)

Report
Copy link

Link copied!

If I was tasked to do this I would create an Azure Function app (timer trigger) in C# using Visual Studio. It would contain 3 functions:

1. Extract website data using Selenium. You can get a Nuget package that supports Selenium. You also need a webdriver. I would use Chrome. You'll need to run Chrome in silent mode.

2. Create Excel workbook using EPPlus. You don't need Excel installed.

3. Write workbook to an Azure storage location or email workbook.

Was this reply helpful? Yes No
mogulman 764 on at

Like (0)

Report
Copy link

Link copied!

If you want to do this on your desktop (not cloud based) and have experience with Excel VBA there is a package you can use to do it called SeleniumBasic. The release is dated but Chrome still works if you update webdriver. I use this a lot to automate web related tasks and it works great. As an example, I like to read so I created an Excel addin that automatically searches library daily for upcoming books so I can be first in line for new releases.

Was this reply helpful? Yes No
Pstork1 69,417 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Selenium will also work with Power Automate UI for a web browser on your desktop. Probably easier than writing C# code for an Azure function.

Was this reply helpful? Yes No