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


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.

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

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?


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(“”).ToString

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


Any idea how can I correct this ?