Error in Power Automate Flow on HTTP Request to Dataverse with filtered dates

(0) Share

Report

Posted on by LR-06011629-0

Hello! I have a problem making an HTTP Request to Dataverse using a filter in a date column. The HTTP request is quite simple:

https://XXXXXXXXX.crm2.dynamics.com/api/data/v9.2/cr1d8_certificadoses?$filter=cr1d8_procesadocnt ne true and cr1d8_fechaemision gt 2024-07-31T23:59:00Z&$top=100000

The response obtained is:

{
	"error": {
		"code": "0x80040224",
		"message": "Could not convert constant 7/31/2024 11:59:00 PM expression to string."
	}
}

The thing is that the provided date in the URL has an ISO 8601 format (YYYY-MM-DDTHH:mm:SS), but it seems that internally converts the format to M/D/YYYY HH:mm:ss giving this error. I could not found anything in forums nor Copilot. This error started a couple days ago, the last execution that did not fail was on 02/01/2025. Since 03/01/2025 I get that error everytime.

What can I do to correct this? Thanks in advance!

Categories:

Building flows

I have the same question (0)

All responses (1)

Answers (0)

Suggested answer

wyattdave 493 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!

In my experience everything you have done is correct, I would look at raising a support ticket with Microsoft as suspect the problem is at their end.

Was this reply helpful? Yes No