web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id : aQnFlT9Ljlxx/sddc0X6nB
Power Automate - Building Flows
Answered

Get Items Filter Query - Column does not exist

Like (0) ShareShare
ReportReport
Posted on 12 Aug 2020 18:06:40 by

I have a flow that continues failing. The error message received is on the action "Get Items" from a SharePoint list. The error message says that the column does not exist or that it may have been deleted or moved by another user. 

 

The column name is '_date'. 

 

cameron0208_4-1597255098481.png

 

I have verified the internal name of the column in the SP list settings. As you can see in the image below at the very end of the URL 'Field=_date'

cameron0208_1-1597254886889.png 

cameron0208_2-1597254969890.png

 

I downloaded the output from the Get Items action to verify the column name. In the download, it shows the column name as 'OData_date'.

cameron0208_3-1597255014440.png

 

However, when changing '_date' to 'OData_date' in the flow, it still fails with the same error message about the column not existing. 

 

cameron0208_0-1597254854531.png

 

The column is visible in the main 'All Items' view

cameron0208_5-1597255354194.png

 

And the column type is 'Date and Time'

cameron0208_6-1597255375499.png

 

Here is the SP list (client names redacted)

cameron0208_7-1597255477147.png

 

Any help is much appreciated! 

 

 

  • Community Power Platform Member Profile Picture
    on 12 Aug 2020 at 19:44:26
    Re: Get Items Filter Query - Column does not exist

    Yep! This worked! Thank you so much! 

  • Verified answer
    Jcook Profile Picture
    7,779 Most Valuable Professional on 12 Aug 2020 at 18:12:08
    Re: Get Items Filter Query - Column does not exist

    Hello @Anonymous 

     

    From your output of get items. It looks like your column name is:

    OData__date

     

    There are 2 underscores.

     

    Please try this and let us know results

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Announcing our 2025 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for…

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 497 Super User 2025 Season 2

#2
David_MA Profile Picture

David_MA 436 Super User 2025 Season 2

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 244 Super User 2025 Season 2

Loading complete