want to sync my excel with my sharepoint list

[KAILASH_ORDU]

Am having a table as shown below 

when am trying to sync this table using power automate am getting below error

It will be a great help if anyone help me out in this issue

[HSheild]

@KAILASH_ORDU 

The error is saying that in the Compose_2 action you are trying to use the int() expression with a parameter that cannot be converted to an integer.  Are you able to share the expression you are using within the Compose_2 action?

[DeviKrishna]

Hi @KAILASH_ORDU ,

Sure we can help. Please share your flow section compose_2 which is throwing the error. Also what is the data type of the parameter you are passing to the int in this step.

If you like my response, please give it a Thumbs Up.

My Blog: Dynamics 365 Key Topics – https://d365topicsbydk.com/

My Youtube Channel : https://www.youtube.com/channel/UCxSIryP2ah2VpEFr-Z72t1A

Regards
Devi

Regards

Devi

[KAILASH_ORDU]

This is the formula am using in my compose2 

if(empty(items('Apply_to_each')?['IN TIME']),null,addDays('1899-12-30',int(items('Apply_to_each')?['IN TIME']),'MM/dd/yyyy'))

[KAILASH_ORDU]

This is the formula am using in my compose2 

if(empty(items('Apply_to_each')?['IN TIME']),null,addDays('1899-12-30',int(items('Apply_to_each')?['IN TIME']),'MM/dd/yyyy'))

And normal short date format am using

[HSheild · Accepted solution]

Hi @KAILASH_ORDU 

Thanks for providing the formula.  The problem in your formula is in the red text below.  You are trying to convert a Date to an Int.  That is not going to work.

if(empty(items('Apply_to_each')?['IN TIME']),null,addDays('1899-12-30',int(items('Apply_to_each')?['IN TIME']),'MM/dd/yyyy'))

It is not clear what you are trying to do.  If you can explain what you are trying to achieve with this formula we will be able to give you guidance on how to better construct it.