cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
jevaun-bcmg
Frequent Visitor

ODATA date Filter Query to MySql does not return a result

ODATA Filter query to MySQL does not return any results.

 

Created_On is the column name and here is what i have tried:

 

  • Created_On eq 2022-04-26T00:00:000Z
  • Created_On eq 2022-04-26
  • Created_On eq formatDateTime(utcNow(), 'yyyy-MM-ddT00:00:00Z')
  • Created_On eq utcNow('yyyy-MM-ddT00:00:00Z')

Attempted both queries with and without '' single quotes. Does not return error but doesn't return results.

The MySql server is linked to power auto via on premise gateway.

 

I am able to successfully execute filter queries on other string and integer columns, my only issue is filtering by date. 

0 REPLIES 0

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (4,884)