SP Get Items Date Field Unavailable for ODATA Filter Query

[Lugho]

Hello, community:

This is a first time for me, so here's a question I can't seem to figure out on my own.

I'm using SharePoint 'Get Items' connector to retrieve records about to expire based on field 'Expiration Date' ('Date and Time' type). 

ODATA query keeps saying 'Bad Request' and field 'Expiration Date' does not exist when I know it does.

This is the ODATA, first two filters work fine:

(Extended_x003f_ eq 'No' and Status eq 'Approved') and Expiration_x0020_Date ge '@{addDays(utcNow(),15)}'

Thanks and greetings!

GH

[Mira_Ghaly]

@Lugho

To compare date fields in OData you need to format the date as yyyy-MM-dd

(Extended_x003f_ eq 'No' and Status eq 'Approved') and Expiration_x0020_Date ge '@{formatdatetime (addDays(utcNow(),15),'yyyy-MM-dd') }'

[Lugho]

Thanks for the reply, @Mira_Ghaly 

I still get the same error. I've tried with and without formatting the date.

Looks like field 'Expiration Date' is not found but I know it does exist.

Here's the field in SharePoint designer.

It's also a member of the view I'm using to limit columns in the Get Items connector.

This is the connector configuration.

Thanks!

[Mira_Ghaly]

@Lugho 

your query looks ok to me , can you try removing other conditions and keep only the expiration date condition , also from from history are you able to view the Raw Inputs of this step?

[Lugho]

Just made a test with just the Expiration Date condition.

This is the raw input:

This is the SP connector:

I can only think of use the filters that work and add a condition connector to just filter by Expiration Date.

I know this is the "wrong way" of setting conditions but ODATA won't seem to fully work for my needs.

Thanks!

[Mira_Ghaly]

@Lugho 

Can you try not to select a specific view?

[Lugho · Accepted solution]

I finally figured this one out! In ODATA, I must use SharePoint internal names that are normally the same as the "display names" in SharePoint Designer or when building list views.

In my case, for whatever reason, my 'Expiration Date' field was named just 'field3' as SharePoint's internal name.

Internal name can be found in the SP list settings page. Then click on the name of the field whose internal name is needed (or just hover over it) so in the address bar the address ends with 'Field=????' ('????' being the internal name).

Thanks and regards!