'The template language function 'int' was invoked with a parameter that is not valid. The value cannot be converted to the target type.'.

[Anonymous]

Hi, I have a flow that is connected to excel and uses the values to populate a sharepoint list. It is returning the date value as a number. I have read other post about this issue and input the following formula in the date values for the create item part of the flow: 

addDays('1899-12-30',int(items('Apply_to_each_2')?['Date']))

Yet, I am still getting an error, i also tried replacing 'int' with 'float' and i get the same error. The dates appears in excel as the following 'mm/dd/yyyy'. 

I also remade the flow to no avail. 

I am not sure what else could be the issue, any suggestions? 

[surfpaddy]

Apologies for delay in replying, I've been busy on other tasks.  Thankyou for the comment however I managed to get the data into the sharepoint list by running 2 flows.   Te first  

[ShriramP]

@surfpaddy Good to know! 🙂