Read Range: Value cannot be null. (Parameter 'Workbook')

Help Community
,
1

Hello guys i have automation using office 365 scope activity and inside that scope i have a find files and folders. And then i want to read excel on that specific folder but it give me error like this Read Range: Value cannot be null. (Parameter ‘Workbook’)
What it does mean? *PS I have a value in that xlsx file
image

2

Hi @Kelvin1

Can you show the properties of read range please

Did you provide a input range ?

And is your find files returning a file or folder?

Cheers

3

Hi @Anil_G here is my properties of my read range
image

I didnt provide a input range, is it matter ?

my find files returning a file

4

I tried to provide the range but its still giving me error like that

5

Hi @Kelvin1

Can you print what is there in output and check i beleive that ia not having the required information

Cheers

6

@Anil_G Which output did you mean? i cant do read range, how can i print the output?

7

Hi @Kelvin1

I see you are using a variable output which I believe is the output from Find files for first occurrence. Can you check if that is retrieving the correct file

In log message try giving output.Name or output.WebUrl to check if it is getting the correct file or not

cheers

8

Hi @Anil_G i tried it , its give me error like this now Log Message: Object reference not set to an instance of an object.

9

Hi @Kelvin1

That means you are not getting anything from file files…your find files is not retrieving any data. You gave to first correct that. Please check the query and sub folder properties in find files

Cheers

10

I dont know why the system read the variable is null. When i start using the find files and folder i was uploading the file using upload file activity with that variable as a destination

11

@Anil_G Before that i already use that same find files and i did some upload file. Everythings goes smoothly, but idk why it giving me error now

12

@Anil_G even now i can did upload another file, do u know why this issue occur?

13

Hi @Kelvin1

Try giving the variable in Result field(variable1) and do variable1.count to know if find files is retrieving any files or not. Clearly your output variable is empty so find files is not giving any data. Check the properties to get the correct details

image

else please give a screenshot here of sharepoint and the properties of find files

cheers

14

Hi @Anil_G ah i see, i already solved the problem. There is an issue in sub folder in find files and folder

1 Like
15

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.