Unanswered

upload files to websites using full path from excel column

(0) Share

Report

Posted on by PhenomenonX

hallo,
can you please give me the link to the tutorial of how to simply upload a file (.pdf) by clicking the web button(upload file)

the problem is how to get the path of the file (D://folder/file.pdf) from the excel column, I am tired of looking
thank you so much, guys.

Categories:

Power Automate Desktop

I have the same question (0)

All responses (7)

Answers (0)

Henrik_M 2,021 Super User 2024 Season 1 on at

Like (0)

Report

Was this reply helpful? Yes No
PhenomenonX 6 on at

Like (0)

Report

hi thank you for variables basics in Power Automate, but you didn't answer my request, can you please read it , to you so much for your help

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Hello @PhenomenonX

For the Excel part of your quetion, please see the sample flow below:

I have only one column in my Excel file, so I can retrieve as "All available values from worksheet" in this case.

If you have only one column, you can refer the file path value with %ExcelData[RowIndex]% format. If there are more than one column, you have to use %ExcelData[RowIndex][ColumnIndex]% format. Both index number is started from 0.

Thank you.

Was this reply helpful? Yes No
PhenomenonX 6 on at

Like (0)

Report

On a website there an (upload file ) button, I need to upload a file(.pdf), and I want to use the full path of the pdf file (C://folder/file.pdf) from the excel column

question: how Microsoft Power Automate Desktop deals with simple uploading files to the websites using files path listed in the excel column?

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Hello @PhenomenonX

Q1) What values are stored in your Excel cells? Isn't the full path of the PDF file stored in the cell?

Q2) What do you mean in "simple uploading files to the websites"? I believe there is no such generic method to upload file to web server other than sending HTTP POST request.

Give us more details of your problem, please.

Thank you.

Was this reply helpful? Yes No
PhenomenonX 6 on at

Like (0)

Report

values why are you asking for things I don't ask for? this is a general flow
any way
2) what I mean by upload, let say I want to upload a file to Mediafire, the Mediafire web page there is a button, I have to click it, and the windows will popup (open file ) window, I choose file, and it's done!! I want to automate this using file text path from excel sheet column ( c://folder/file.pdf) pdf or any extension image, its general operation (upload)

is this strange for you, you never upload files?

i know how to add read excel flow, and I don't need any popup message shows the pdf path,

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Hello @PhenomenonX

You can use action "Send keys" to send key conbination Ctrl-V (Paste) to the foreground window.

If the character input cursor is not in the appropriate field, send the TAB key as many times as necessary to focus the cursor into the "File name" field before sending the Ctrl-V key.

If you send out the Enter key after that, it will behave as if you clicked the [Open] button.

You will find other threads on this community discussing the same topic as yours, if you search by key word "Upload File".

Upload Local PDF to Website - Power Platform Community (microsoft.com)
Upload files to a website in a loop? - Power Platform Community (microsoft.com)
How to upload a File from Select File Button - Power Platform Community (microsoft.com)
Solved: Help with uploading files using Power Automate Des... - Power Platform Community (microsoft.com)

"File upload" has different user interfaces on different websites, and the behavior after clicking the "Upload" button is not the same, and the problem must be addressed on a case-by-case basis. That's what I wanted to mention. 🙂

Good luck.

Was this reply helpful? Yes No