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 :
Power Automate - Using Connectors
Unanswered

In a cast was not an entity type issue with date

(0) ShareShare
ReportReport
Posted on by 10

Hello,

 

I have an issue with my flow, I am trying to get all the data that the date is equal to today and I am using the below method, but when I run my flow this error shows up (The child type 'date' in a cast was not an entity type. Casts can only be performed on entity types. inner exception: The child type 'date' in a cast was not an entity type).

 

although my date format is the same in the flow and my excel sheet (yyyy-MM-dd).

 

Capture.PNG

 

 

I have the same question (0)
  • RobElliott Profile Picture
    10,313 Super User 2025 Season 2 on at
    Re: In a cast was not an entity type issue with date

    @Regash  you need to put your expression inside single quotes, and make sure you select ISO 8601 for the DateTimeFormat field otherwise it uses Excel's native dates which are stored as integers.

     

    iso8601.png

     

    Rob
    Los Gallardos
    If I've answered your question or solved your problem, please mark this question as answered. This helps others who have the same question find a solution quickly via the forum search. If you liked my response, please consider giving it a thumbs up. Thanks.

  • Regash Profile Picture
    10 on at
    Re: In a cast was not an entity type issue with date

    Thanks for your reply, I have tried your way but it is still the same error 

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

Coming soon: forum hierarchy changes

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Tomac Profile Picture

Tomac 532 Moderator

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 461 Super User 2025 Season 2

#3
chiaraalina Profile Picture

chiaraalina 256

Last 30 days Overall leaderboard

Featured topics