FormatDateTime createdon column in List Rows Filter rows

(0) Share

Report

Posted on by Revlock97

187

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)

Categories:

General topics

I have the same question (0)

All responses (3)

Answers (1)

v-jefferni Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @Revlock97 ,

Since it inside Apply to each, please use items('Apply_to_each')?['createdon'] instesd.

Best regards,

Was this reply helpful? Yes No
Revlock97 187 on at

Like (0)

Report
Copy link

Link copied!

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!

Was this reply helpful? Yes No
Verified answer

v-jefferni Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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,

Was this reply helpful? Yes No