Date Field from Dynamics CRM is not recognized as Date Field in ISO Format

Like (0) Share

Report

Posted on 24 Nov 2021 18:58:22 by Thomas Fialek

Hi community,

I am trying to set an oData filter while listing rows for a table from Dynamics CRM. I would like to compare a date field from CRM with utcnow() with the operator "le" (less or equal). The date field from Dynamics CRM has the format "only date". I am not sure if that matters.

I am trying to use the formatDateTime on that date field from CRM, but I always receive the error message that The datetime string must match ISO 8601 format.

I'm a bit surprised that a date field has not the correct format to use a date function in power automate....

Anyways, someone has an idea how I can make these two date fields comparable?

Many thanks!

All responses (1)

Answers (0)

AnthonyAmador 2,553 Moderator on 26 Nov 2021 at 15:10:11

Like (0)

Report

Re: Date Field from Dynamics CRM is not recognized as Date Field in ISO Format

Hi @Tomeczek

I think the problem could be that you are not calling the CRMFIELD value correctly, is it a dynamic value? If yes, when you create the expression, you need to change the tab to dynamic content and select it from there.

If that's not the case, can you please show me what CRMFIELD contains? I did some research and it seems that if date is for example dd/MM/yyyy it gives the same error.

Hope this helps.
Kind regards.

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.