web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate - Building Flows / Condition for Modified...
Power Automate - Building Flows
Unanswered

Condition for Modified in SharePoint list

(0) ShareShare
ReportReport
Posted on by TBeglin 4

Hi,

I have a SharePoint list that I want to filter and organise based on the 'Modified'

On 'Get Files' I have created a filer Query using the following

Modified ge '2020-01-01T00:00:00Z' and Modified le '2020-12-31T23:59:59Z'


This works fine and is getting all files I need.

When I want to get said files into month folders I am using the following

SnippingTool_mSRPvuRBoR.png

This does not work and all files return as true.

Any help!

 

I have the same question (0)
  • tom_riha Profile Picture
    tom_riha 10,185 Most Valuable Professional on at
    Re: Condition for Modified in SharePoint list

    Hello @TBeglin ,

    I'd add a 'Compose' action right before the condition and store the 'Modified' date there. Just to confirm what value enters the condition and if it returns true/false for that value. That might provide some hint why the condition is not working as you expect. 

    You could also try to convert the values into dates with the formatDateTime(...) expression, maybe it will help.

    image.png

  • TBeglin Profile Picture
    TBeglin 4 on at
    Re: Condition for Modified in SharePoint list

    Compose outputs look good

    TBeglin_0-1612888960039.png

     

     

    Same results I'm afraid, all files return as true.

  • tom_riha Profile Picture
    tom_riha 10,185 Most Valuable Professional on at
    Re: Condition for Modified in SharePoint list

    Hmm, I just tried that on my environment and I can't force it to not-work.

    Another thing I'd try is to change the format on both sides of the condition, get rid of the time part and use only the 'yyyy-MM-dd':

    formatDateTime([ModifiedDynamicContent], 'yyyy-MM-dd') <= the right side of the condition

formatDateTime('2020-01-01T00:00:00Z, 'yyyy-MM-dd') <= the left side of the condition

     

  • TBeglin Profile Picture
    TBeglin 4 on at
    Re: Condition for Modified in SharePoint list

    Invalid expression for both commands

     
    I'm still scratching my head over this!

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

News and Announcements

Welcome to the Power Platform Communities
Forum hierarchy changes happening today, December 5th!
Explore Copilot Studio Forums, Blogs & Galleries!

Quick Links

Coming soon: forum hierarchy changes

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Tomac Profile Picture

Tomac 532 Moderator

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 461 Super User 2025 Season 2

#3
chiaraalina Profile Picture

chiaraalina 256

Last 30 days Overall leaderboard

Featured topics

Share your ideas and struggles with building Power Automate flows!
Start and wait for an approval action

Product updates

Microsoft Power Platform Community release plans