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
Solved! Go to Solution.
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.
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?
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
This is the formula am using in my compose2
This is the formula am using in my compose2
And normal short date format am using
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.