'The template language function 'formatDateTime' expects its first parameter to be of type string. The provided value is of type 'Null'.

(0) Share

Report

Posted on by AscendCOE

formatDateTime(utcNow(),'yyyy-MM-dd')

Is Equal To:

formatDateTime(triggerbody()?['Created'],'yyyy-MM-dd')

... where Created is a Sharepoint List default field of the same name.

Where is my syntax wrong?

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (0)

tom_riha 10,187 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!
Hello @AscendCOE ,

the triggerbody()? part seems wrong, try to use:

triggerOutputs()?['body/Created']

Was this reply helpful? Yes No
AscendCOE 15 on at

Like (0)

Report
Copy link

Link copied!

Hello @Anonymous
I recieved the same Error:

InvalidTemplate. Unable to process template language expressions for action 'Condition' at line '0' and column '0': 'The template language function 'formatDateTime' expects its first parameter to be of type string. The provided value is of type 'Null'. Please see https://aka.ms/logicexpressions#formatdatetime for usage details.'.

formatDateTime(utcNow(),'yyyy-MM-dd') Is Equal To formatDateTime(triggerOutputs()?['body/Created'],'yyyy-MM-dd')

Do you have any other thoughts? Should the functions be reversed?

Was this reply helpful? Yes No
MJain 2,450 on at

Like (0)

Report
Copy link

Link copied!

Hi @AscendCOE ,

I suggest you use compose action and put triggerOutputs()?['body'] in expression to see what is the output you are getting . If you get created field in this then you are good to use but check the output properly if you are looking for something else .

Thanks

Was this reply helpful? Yes No
AscendCOE 15 on at

Like (0)

Report
Copy link

Link copied!

Hi @ManishJain

I ran a compose on the function:
"formatDateTime(triggerOutputs()?['body/Created'],'yyyy-MM-dd')"

And the output was the same as the function. Based on your previous statement you're suggesting I am not referencing the field properly?

Was this reply helpful? Yes No
MJain 2,450 on at

Like (1)

Report
Copy link

Link copied!

Hi @AscendCOE ,
possibly yes , that is where if you do compose action and put triggerOutputs()?['body'] it will give you all fields to look at . Once you are able to figure it out remove this compose action and put it in formatDateTime .

Thanks

Was this reply helpful? Yes No