Drive Item Read Range

Help Activities
,
1

Hello,

I have an Excel file in SharePoint that I would like to download and read. The issue is that the download file activity outputs a drive item:
image

which I cannot use in a read range activity.

Currently I have the download file activity inside a wait for download:

image
image1071×712 36.1 KB

Then I use the diExcelFile.tostring into the read range - however the issue I am having is that the wait for download does not work. Therefore I need a way of getting the output of the download file into the read range without using a wait for download.

Is there a way of doing this? Perhaps a way of converting the drive item into another variable the read range acitivity can take?

Thanks

2

Hi @E.T.S

Read range activity input is the Excel file path.

Give the local path of the folder where you want to download the file from SharePoint.

If the diExcelFile variable contains the name of the file. Then the input of read range concatenate with the local path of the folder where you have given in the download file activity and diExcelFile variable with the slash.

Hope it helps!!

3

Hi!

Thank you for your reply. I have calibrated the read range to include the name of the file like this:

image
image905×674 37.1 KB

Unsure how to calibrate to include the location of the file?

Thanks!

4

No don’t give like this in Read range field, try the below one

strDownloadLocation+"\"+diExcelFile.name.toString

If it’s now working share the values for both of the variables.

Hope you understand!!

5

@E.T.S

In the download location …you can pass the file only insteqd of folder then you can use the same variable directly

Or use Path.Combine(strDownloadLocation,diExcelFile.Name.Tostring)

Or you already know the name …as you would have used in find files or folders …so use same here

Cheers

Cheers