
Announcements
I am using Get Items for Sharepoint list. I want to filter a number column with name ID1 using the OData filter
ID1 lt 570000 does not work
Field=_x0049_D1 from the browser bar when in the List settings page
_x0049_D1 lt 570000 does not work
Odata_x0049_D1 lt 570000 does not work
ODATA_x0049_D1 lt 751777 does not work
Each one gives a variation on this message
Column 'ODATA_x0049_D1' does not exist. It may have been deleted by another user.
Can you suggest the correct syntax
Steve
Realised that if I created a sharepoint item from the get items list I would be able to see the column name by hovering over the dynamic input for ID1
items('For_each')?['OData__x0049_D1']
Correct ODATA FILTER is - OData__x0049_D1 lt 751777
There was an extra _ after OData i.e 2 underscores between OData and x0049_D1