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

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!

Hello,

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

Regards,

Dragos.

Here you go:

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.

If you can please share the project :slight_smile:

Regards,

Dragos.

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

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

Allow me to elevate you :slight_smile:

Try now to upload :slight_smile:

1 Like

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

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.

when i comment out the filter table:

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

im so bad at troubleshooting :smiling_face_with_tear:

zillow scraper.zip (8.1 MB)

do you mean like this?

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:

@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

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

how do i fix it ?

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

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

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”

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