How to Extract the Sharepoint URL After a File is Uploaded?

Help
, ,
1

Hello,

i have uploaded the file in the sharepoint now i need to copy the uploaded url and paste into the excel particular cell any one can help how to do that.

Thanks in advance.

2

Yah
Use a assign activity like this
str_filepath = Directory.GetFiles(“yourfolderpath”).OrderByDescending(Function(a) New FileInfo(a).CreationTime).ToList(0).ToString
This will give last created or inserted file in the specified folder where str_filepath is a variable of type string

—now use EXCEL Application scope activity where mention the file path of excel and use a WRITE CELL activity where mention the input as str_filepath and mention the cell range we want

Cheers @Shriharsha_H_N

3

Hello @Shriharsha_H_N

Is your uploaded URL available in the browser URL section after the file is uploaded? or else, is it available in the web page itself?

4

Hi,

I use this assign activity inside the sharepoint app scope.
but it seems failed to get the URL of the file that I wanted to retrieve.

my folder path = Directory.GetFiles(“https://xxx.sharepoint.com/sites/xxx/salesops/Shared%20Documents/xxx/9.%20PO%20Tracking/Downloaded%20PDF/ONE/”).ToString

under this path, i have already deposited one pdf file.

image

Any idea how can I correct this ?

Thanks.

5

Hi @Palaniyappan,

I use “Find Files And Folders” before assign activity (like you wrote) and unfortunately it doesn’t work for me.
image

image
image739×29 3.33 KB

Any ideas what could have gone wrong?