Unanswered

Cannot convert the literal '' to the expected type 'Edm.DateTimeOffset'.

(1) Share

Report

Posted on by anthonys123

457

My flow starts as a form (Manually Trigger a Flow). Part of the form has optional date picker fields for project due dates.

This flow creates a Planner bucket with six tasks which often do not have due dates. When the due dates in the form are left blank, I'm often getting the error below (but not every time).

{
 "error": {
 "code": "",
 "message": "The request is invalid:\r\nCannot convert the literal '' to the expected type 'Edm.DateTimeOffset'.",
 "innerError": {
 "date": "2021-04-16T13:34:18",
 "request-id": "IDretracted",
 "client-request-id": "IDretracted"
 }
 }
}

Screen Shot 2021-04-16 at 9.47.37 AM.png

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (0)

fchopo 8,003 Moderator on at

Like (1)

Report

Hi @anthonys123

Try to use the "null" value inside the due date field. Be careful, "null" should be written as an expression, and not as a string.

Hope it helps!

Ferran

Was this reply helpful? Yes No
anthonys123 457 on at

Like (0)

Report

@fchopo Sometimes there's a due date and sometimes there isn't. Null wouldn't work when a due date is set by the user. How might I compose a 'Due Date Output' from the user's input whether the field is filled or null?
I have six due dates and my flow is repeated 4 times. So, the cleaner the better.
Thanks!

Was this reply helpful? Yes No
fchopo 8,003 Moderator on at

Like (1)

Report
You could use an expression like:

if(equals(outputs('Get_response_details')?['body/submitDate'],''),null,outputs('Get_response_details')?['body/submitDate'])

Using your form's date question instead of "submitDate".

Hope it helps!

Ferran

Was this reply helpful? Yes No
anthonys123 457 on at

Like (0)

Report
@fchopo I'm stumped. Below, I'm working with a submission that has the date entered.
The question on my form is Final Due. When I open the Raw Input, I see;

"date": { "title": "Final Due", "type": "string", "format": "date", "x-ms-dynamically-added": true, "description": "Please enter or select a date (YYYY-MM-DD)", "x-ms-content-hint": "DATE"

The Raw Output is;

"body": { "text": "First", "text_1": "Last", "text_2": "4545 First St", "text_3": "Miami", "text_4": "Client Residence", "text_5": "Big Building", "date": "2021-06-25", "date_1": "2021-06-25", "boolean": true, "date_2": "2021-06-25", "boolean_1": true, "date_3": "2021-06-25", "date_4": "2021-06-25", "date_5": "2021-06-25", "text_8": "Anthony", "text_9": "Active"

I have tried the following;

if(equals(outputs('Get_response_details')?['body/Final Due'],''),null,outputs('Get_response_details')?['body/Final Due']) if(equals(outputs('Get_response_details')?['body/date'],''),null,outputs('Get_response_details')?['body/date'])

All variations are giving me the same error;

Correct to include a valid reference to 'Get_response_details' for the input parameter(s) of action 'Final_Due_1'.

Was this reply helpful? Yes No
SourabhRoy 2 on at

Like (0)

Report

This issue i have seen in many cases like date and Integer case. This happens because Flow is trying to post as empty string instead of null even though you have added null in expression.
In Logic app, we used to go to code view and remove curly bracket after @ symbol for the expression. In flow, you need to add full expression including @ symbol to work

Example: In code view if you add the above expression, it will look like below:
@{if(equals(outputs('Get_response_details')?['body/Final Due'],''),null,outputs('Get_response_details')?['body/Final Due'])}

You need to change like below then it will accept both null value and date value.
@Anonymous(equals(outputs('Get_response_details')?['body/Final Due'],''),null,outputs('Get_response_details')?['body/Final Due']) => just remove curry bracket after @ in expression

Was this reply helpful? Yes No