cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
csommerfield
Helper I
Helper I

Simple get rows filter in SQL returning empty

Hello,

 

Not sure why this is happening and can't figure it out but im using a simple get rows odata filter and it returns empty even though I know the value exist. Any ideas?

 

If I take the top 20 rows, one of them I know is a return of property ID of p0503

csommerfield_0-1631285778498.png

If I filter on that row it's returning nothing

 

csommerfield_0-1631285348174.png

Thanks!

1 ACCEPTED SOLUTION

Accepted Solutions
csommerfield
Helper I
Helper I

I was able to get this working by using the column name without the brackets. So Property_x0020_ID instead of [Property ID]. 

View solution in original post

1 REPLY 1
csommerfield
Helper I
Helper I

I was able to get this working by using the column name without the brackets. So Property_x0020_ID instead of [Property ID]. 

View solution in original post

Helpful resources

Announcements
MPA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Top Solution Authors
Users online (1,585)