Answered

Automate upload of Excel file to web app

(1) Share

Report

Posted on by accorti

I am new to Power Automate RPA, but have experience with RPA using Python (desktop and selenium). I would like to use Power Automate RPA to create a flow that uploads and excel spreadsheet to a web app everyday. The excel sheet will be updated daily and stored in the same location each time.

I have tried using both the desktop and website flows (separately) to do this. When using the Website app, I've successfully navigated to the website and gotten to the point of upload, but when the flow gets to the point of upload, I receive an error saying it cannot find that file path (to my desktop folder).

Can Power Automate not mix web addresses and local file path addresses?

Categories:

Power Automate Desktop

All responses (5)

Answers (1)

Sort by

Verified answer

accorti 35 on at

Like
a
(0)

Report
Copy link

Link copied!

Solved:
1. Needed to enable allow urls in the Selenium IDE extension for chrome to allow access to my local files.
2. Needed to add an extra \ as the proper escape character for the file path.
sagar_ap 6 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello accorti, I have a need similar to yours. Would you mind sharing your code?
accorti 35 on at

Like
a
(0)

Report
Copy link

Link copied!

@sagar_ap I no longer have access to the files as it was for a client of mine from a few years back. If you post your current configuration I'm sure myself and /or others on the forum could help support.
sagar_ap 6 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello accorti.
Thank you for your response.
My company has O365 and thus also power automate.
I want to open a file at 8 AM, refresh all connections and then upload the entire file to fabriq, a web platform for manufacturing. fabriq is capable of reading the KPI given in the file.
The upload usually takes place by clicking on a button which reveals a menu,
then clicking on the third item in the list,
then clicking browse and selecting the file.
How doable do you think automating this process is?
Shaun256 2 on at

Like
a
(0)

Report
Copy link

Link copied!

Did you figure out how to connect? We started using Fabriq and would love to connect to it.