"Column name" is not set or is invalid ? Need help fixing this

Help StudioX
,
1

Hey there guys im creating a flow that scrapes zillow in reference to leon pertou rpa course of Udemy and ive run into this issue.

here is a loom video of the problem in action:

If anyone can please explain this it would be very much appreciated!

2

Hello,

Can you show a picture of how you configured the filter ?

Regards,

Dragos.

3

Here you go:

image
image2020Ă—1004 197 KB

4

Thank you , now one might ask if the extract table data activity is actually extracting stuff :slight_smile: So could you please insert the extracted data table in a excel file . you can just use the write range activity :slight_smile:

Dragos.

5

If you can please share the project :slight_smile:

Regards,

Dragos.

6

how do i share the project sorry im new to UiPath and the community forum

7

cant add attachments as im a new user. can i email it to you? or an alternative way

8

Allow me to elevate you :slight_smile:

9

Try now to upload :slight_smile:

1 Like
10

Main.xaml (75.4 KB)
PropertyListing.xlsx (11.4 KB)

11

I’m getting the following error :

UiPath.UIAutomationNext.Exceptions.ApplicationOpenException: Could not find the UI element corresponding to this selector:

So can you archive the entire project and upload it :slight_smile:

Dragos.

12

when i comment out the filter table:

image
image1066Ă—794 43.4 KB

I get this error too: “Object reference is not set to an instance of an object” ??

image
image1751Ă—827 56.9 KB

im so bad at troubleshooting :smiling_face_with_tear:

13

zillow scraper.zip (8.1 MB)

do you mean like this?

14

Of course you get an object not set error , because the dt_FileteredDT does not exist until it gets created in the commented activity :smiley:

15

@Ryhan_Ahmed

That will throw the Object Reference error because the dt_FilteredDT you are using in Filter Datatable Activity, So you commented that will makes dt_FilteredDT is null Datatable, That’s why you are getting this error

Hope this helps you

Thanks

1 Like
16

oh i see haha so i have to fix the filtered data table activity lmao.

how do i fix it ?

17

how do i fix the initial " Column name is not set or is invalid ? " error

18

how do i fix the initial " Column name is not set or is invalid ? " error

19

the error is caused because the extracted data table has a column named Zillow Url and you have filter for “URL” , same for “Bathrooms” and “Baths”

image
image1920Ă—1030 105 KB

20

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