I am looking to filter an odata request within power automate to return only records where the modifiedon date is greater than a specified value. I have thus far tried the following without success:

$filter=ModifiedOn%20gt%20datetime'2023-05-23T00:00:00.0000000Z'

{ "error": { "code": "", "message": "The query specified in the URI is not valid. Unrecognized 'Edm.String' literal 'datetime'2023-05-23T00:00:00.0000000Z'' at '14' in 'ModifiedOn gt datetime'2023-05-23T00:00:00.0000000Z''.", "innererror": { "message": "Unrecognized 'Edm.String' literal 'datetime'2023-05-23T00:00:00.0000000Z'' at '14' in 'ModifiedOn gt datetime'2023-05-23T00:00:00.0000000Z''.", "type": "", "stacktrace": "" } } }

$filter=ModifiedOn%20gt%20cast('2023-05-23T00:00:00.0000000Z','Edm.DateTimeOffset')

{ "error": { "code": "", "message": "The query specified in the URI is not valid. The binary operator GreaterThan is not defined for the types 'System.Nullable`1[System.DateTime]' and 'System.Object'.", "innererror": { "message": "The binary operator GreaterThan is not defined for the types 'System.Nullable`1[System.DateTime]' and 'System.Object'.", "type": "", "stacktrace": "" } } }

$filter=ModifiedOn%20gt%20'2023-05-23T00:00:00.0000000Z'

{ "error": { "code": "", "message": "The query specified in the URI is not valid. A binary operator with incompatible types was detected. Found operand types 'Edm.DateTimeOffset' and 'Edm.String' for operator kind 'GreaterThan'.", "innererror": { "message": "A binary operator with incompatible types was detected. Found operand types 'Edm.DateTimeOffset' and 'Edm.String' for operator kind 'GreaterThan'.", "type": "", "stacktrace": "" } } }

$filter=ModifiedOn%20gt%20datetimeoffset'2023-05-23T00:00:00.0000000Z'

{ "error": { "code": "", "message": "The query specified in the URI is not valid. Unrecognized 'Edm.String' literal 'datetimeoffset'2023-05-23T00:00:00.0000000Z'' at '14' in 'ModifiedOn gt datetimeoffset'2023-05-23T00:00:00.0000000Z''.", "innererror": { "message": "Unrecognized 'Edm.String' literal 'datetimeoffset'2023-05-23T00:00:00.0000000Z'' at '14' in 'ModifiedOn gt datetimeoffset'2023-05-23T00:00:00.0000000Z''.", "type": "", "stacktrace": "" } } }

Any suggestions for how to achieve this would be much appreciated. Thanks.

How can I add a new channel to action dashboard panel IN Freedom UI. I wanted to create a custom module in action dashboard on click of that I need to show some contact information.

 

I am looking for assistance with a challenge I am facing in the Freedom UI of Creatio regarding the display of decimal field values in a label.

The issue I am encountering is that when I try to display a decimal value in a label on the Freedom UI page, the value is not being comma-separated as expected. For example, if the decimal value is 23,586.06, the label only shows 23586.06 without the comma. Similarly, for the value 1,000.00, the label displays only 1000 instead of 1,000.00.

What I am aiming for is to have the decimal values displayed with commas for better readability. For instance, the value 23,586.06 should be displayed as 23.586.06, and 1,000.00 should appear as 1,000.00 in the label on the Freedom UI page.

I have tried several approaches to address this issue within the Freedom UI but have not been successful in achieving the desired result.

Does anyone have a solution on how to create Excel reports with Time type columns? I tried to use "Excel reports builder" but it gave me an error "Unable to cast object of type 'System.TimeSpan' to type 'System.IConvertible'.Couldn't store <00:39:00> in ___ Column. Expected type is DateTime." I want to make a pivot table and graph, so the usual unloading of the registry is not enough for me. 

Hi Community!

Our customer is generating documents in their old CRM system in an interactive way.
This means they can merge the data from the CRM with the report template into a Word document, then edit that document in Word and save the final result to CRM as PDF.
 

As far as I know, this is not possible in Creatio 8, but is very important for the customer!

Is there any way to achieve this goal? I searched the marketplace but haven't found a proper solution.

Thanks,

Robert