I am having trouble filtering my list rows because the expression I am using below throws the error;
"'formatDateTime', the value provided for date time string 'createdon' was not valid. The datetime string must match ISO 8601 format.'."
I don't know what is wrong with this format since it works perfectly in a compose outside of the List Rows (only difference is created on is inside an apply to each). I tried Item()?['createdon'] but it returns Null
div(sub(ticks(formatDateTime(utcNow(),'yyyy-MM-dd')),ticks(formatDateTime('createdon','yyyy-MM-dd'))),864000000000)
Hi @Revlock97 ,
I don't think the long expression is appropriate for filter rows. Please try and turn on the Pagination for this action, then use Filter array instead.
Best regards,
Hi @v-jefferni ,
Sorry my bad, actually it is not inside an apply to each. Before it was in an apply to each so that I may verify which record is 10 days or older
however since I may be handling thousands of data it would be a lot better to just filter the list rows directly. That is why I am try to find the right expression to use in the Filter rows since it is throwing that error. Thank you!
Hi @Revlock97 ,
Since it inside Apply to each, please use items('Apply_to_each')?['createdon'] instesd.
Best regards,