Skip to main content

Notifications

Power Automate - General Discussion
Answered

FormatDateTime createdon column in List Rows Filter rows

(0) ShareShare
ReportReport
Posted on by 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

 

Revlock97_0-1689577714852.png

 

div(sub(ticks(formatDateTime(utcNow(),'yyyy-MM-dd')),ticks(formatDateTime('createdon','yyyy-MM-dd'))),864000000000)

 

 
  • Verified answer
    v-jefferni Profile Picture
    v-jefferni on at
    Re: FormatDateTime createdon column in List Rows Filter rows

    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,

  • Revlock97 Profile Picture
    Revlock97 187 on at
    Re: FormatDateTime createdon column in List Rows Filter rows

    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!

     
  • v-jefferni Profile Picture
    v-jefferni on at
    Re: FormatDateTime createdon column in List Rows Filter rows

    Hi @Revlock97 ,

     

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

     

    Best regards,

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,526

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,907

Leaderboard