Getting the following error message
InvalidTemplate. Unable to process template language expressions for action 'Condition' at line '1' and column '2876': 'In function 'formatDateTime', the value provided for date time string '256' was not valid. The datetime string must match ISO 8601 format.'.
What I'm trying to do is to create a flow that takes a record from List A, copies it to List B and then delete the record from List A. My flow is based on a column that is a formula that adds days from another column. For example, the column in question, Archive 2, is basically a formula that adds 120 days from date column. This Archive 2 column is a date/time column set to Date only.
My flow syntax is:
formatDateTime(item()?['Archive_x0020_2'],'yyyy-MM-dd')
Is less than
addDays(utcNow(),-1,'yyyy-MM-dd')
So, when Archive 2 shows a date that is 1 day older than today's date, the flow activates. This flow works perfectly when the column in question is the standard SharePoint Created date, not sure why it's not working on this column
Any ideas?