Automate upload of Excel file to web app

[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? 

[accorti · Accepted solution]

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]

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

[accorti]

@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]

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?