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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Get Items Filter Query...
Power Automate
Answered

Get Items Filter Query - Column does not exist

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

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! 

 

 

Categories:
I have the same question (0)
  • Verified answer
    Jcook Profile Picture
    7,781 Most Valuable Professional on at

    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

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

    Yep! This worked! Thank you so much! 

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the March Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Haque Profile Picture

Haque 573

#2
Valantis Profile Picture

Valantis 407

#3
11manish Profile Picture

11manish 387

Last 30 days Overall leaderboard