cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
accorti
Helper I
Helper I

Automate upload of Excel file to web app

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? 

1 ACCEPTED SOLUTION

Accepted Solutions
accorti
Helper I
Helper I

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.

View solution in original post

4 REPLIES 4
accorti
Helper I
Helper I

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
New Member

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

accorti
Helper I
Helper I

@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
New Member

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?

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Users online (2,130)