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

Announcements

Welcome to the Power Platform Communities
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Error on Get Items flo...
Power Automate
Unanswered

Error on Get Items flow when trying to capture last modified date from my sharepoint list

(0) ShareShare
ReportReport
Posted on by DineshK_ 207

Hi All,

 

I was working on the flow to get the last modified date from my SharePoint list and notify by email if the last modified date is overdue in 5 or 7 days.

Below the flow details and SharePoint list snaps , please help to fix this asap.

 

DineshK__0-1713959464603.png

DineshK__1-1713959710981.pngDineshK__2-1713959763734.png

 

 

Categories:
Power Automate Desktop
I have the same question (0)
  • eetuRobo Profile Picture
    eetuRobo 4,579 Super User 2026 Season 1 on at

    What does the formatted date time function look like? 
    I would guess the problem is in the time format.
    Try formatting it like this: yyyy-MM-ddTHH:mm:ssZ

    eetuRobo_0-1713961164739.png

     

  • eetuRobo Profile Picture
    eetuRobo 4,579 Super User 2026 Season 1 on at

    I think the reason is actually lt needs to be le

     

    Copy paste:

    Modified le '@{formatDateTime(utcNow(), 'yyyy-MM-dd')}'

    Edit: Actually lt is less than and le is less or equal so forget what I said at first in this post.

    The problem is probably the lack of single quotes around your formatDateTime function.

    eetuRobo_0-1713962258334.png

     



  • DineshK_ Profile Picture
    DineshK_ 207 on at

    Hi , Thanks for your response 🙂

    Actually there is no single quote before & after expressions .

     

    DineshK__0-1713962972851.png

    Updated again as "Modified le" but still issue exists.

    DineshK__1-1713963077645.png

    I have given the time format as per the sharepoint list format.

    Still confusing on what blocking this 😞

     

  • eetuRobo Profile Picture
    eetuRobo 4,579 Super User 2026 Season 1 on at

    Sorry for not being clear.
    I mean that you NEED to have the single quotes for it to work.

    So try adding single quotes around your expression. 

    Without the single quotes I get similar error:

    eetuRobo_2-1713964118097.png

     

    eetuRobo_0-1713964072466.png


    With the singe quotes around the FormatDateTime expression it works:

    eetuRobo_3-1713964130915.png

    eetuRobo_1-1713964095894.png

     

  • DineshK_ Profile Picture
    DineshK_ 207 on at

    Thanks a lot , it works ..

    But when it reached to Apply to each , there is no action on it .. 0s for the flow execution.

    I doubt on the flow too.

    Should we use same format on this flow ?

    DineshK__0-1713966698711.png

     

    Curently i have used the below expressions :

    formatDateTime(item()['Modified'], 'yyyy-MM-dd')
    addDays(utcNow(), -5, 'yyyy-MM-dd')
  • eetuRobo Profile Picture
    eetuRobo 4,579 Super User 2026 Season 1 on at

    The expressions look fine to me. 
    Have you made sure that the sharepoint actually has item that is modified exactly 5 days ago?
    Does the Get items -action return items that are modifed exactly 5 days ago?

     

    Did you make sure that the apply to each is using the Get items values that it returned.
    eetuRobo_0-1713968600181.png
    It seems like you are using something else(Modified dynamic content) than the Get items Value in your apply to each.

    eetuRobo_1-1713968660011.png

     

     

  • DineshK_ Profile Picture
    DineshK_ 207 on at

    Hi ,

     

    Have you made sure that the SharePoint actually has item that is modified exactly 5 days ago? No , currently 2 days ago , there is no entry less than 5 days in last modified column.

     

    In Get Items nothing defined except filter query ..

    DineshK__0-1713970231627.png

     

    DineshK__1-1713970301940.png

     

  • eetuRobo Profile Picture
    eetuRobo 4,579 Super User 2026 Season 1 on at

    So does the Get Items return any items after being successful? You might want to add compose with length function to see if that Get items returned something while you are testing: 

    length(outputs('Get_items')?['body/value'])
    eetuRobo_1-1713974131713.png

     

    Also as an idea: I think you could already do the add days function in the Get items -actions filter query:

    eetuRobo_0-1713973814666.png

     

  • DineshK_ Profile Picture
    DineshK_ 207 on at

    Actually the scenario is to send a reminder mail when the last modified date is overdue by 7 days.

    I have enabled modified date & time column in sharepoint list .

    So we have to pick the last modified column values and compare it to our flow and if the condition satisfies then mail should trigger as a reminder to check the overdue data.

     

    Currently in the Get Items have nothing except the filter query which i have mentioned in trail messages.

     

    I am very new to Power automate so its very hard to understand all the things 😞

     

    Thanks

    DK

  • eetuRobo Profile Picture
    eetuRobo 4,579 Super User 2026 Season 1 on at

    Okay but does the Get Items return any values when it succeeds? If not then that's the reason why apply to each doesn't do anything since there is nothing to loop through. I would suggest adding Compose -action where you just have this function: length(outputs('Get_items')?['body/value'])

    If its 0 then the get items is not returning any values and either the site address or list name is wrong in the sharepoint get items -action or the filter is still wrong.

    To troubleshoot test the flow without any ODATA filter. Does it return any items then?
    Then put the Modified lt FormatDateTime() back to the ODATA filter and check if that returns anything

    I recommend watching this video for troubleshooting tips (especially timestamp 3:05-4:10)
    https://www.youtube.com/watch?v=8i7-IEKJhzU

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

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
David_MA Profile Picture

David_MA 248 Super User 2026 Season 1

#2
11manish Profile Picture

11manish 204

#3
Haque Profile Picture

Haque 179

Last 30 days Overall leaderboard

Featured topics

Known issue with browser automation in Power Automate for Desktop on Google Chrome 146 and 147
Share your ideas and struggles with building Power Automate flows!
Survey: Power Automate mobile app
How to Ask for Help with Your Power Automate Workflow
Flows are not visible for users who sign in with their personal accounts
Start and wait for an approval action
Restore a deleted flow
List of actions cheat sheet for Power Automate Desktop
Welcome to the Power Automate forum!

Product updates

Microsoft Power Platform Community release plans