Share
ReportHi,
I have a list row action where I am trying to only pull records where the expiry date + 15 days is equal to the current date
So Initialized a variable called CurrentDate and set to utcNow()
Then Initialized another variable after above action called 'FormattedCurrentDate' and set it to:
formatDateTime(variables('CurrentDate'),'yyyy-MM-dd').
So far so good.
Then, in my list Rows action in Filter rows I put the expression
Then, in my list Rows action in Filter rows I put the expression
addDays('scor_expiry',15,'yyyy-MM-dd') eq FormattedCurrentDate.
'scor_expiry' is a Date field in my table that I want to compare on...
'scor_expiry' is a Date field in my table that I want to compare on...
However I get the error:
Unable to process template language expressions in action 'List_rows' inputs at line '1' and column '9851': 'In function 'addDays', the value provided for date time string 'scor_expiry' was not valid. The datetime string must match ISO 8601 format.'.
Unable to process template language expressions in action 'List_rows' inputs at line '1' and column '9851': 'In function 'addDays', the value provided for date time string 'scor_expiry' was not valid. The datetime string must match ISO 8601 format.'.
Any help on this is appreciated
Categories:
All responses (
Answers (
33,004
