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 / Filter query Get items...
Power Automate
Unanswered

Filter query Get items SharePoint Date

(0) ShareShare
ReportReport
Posted on by 52

Bajda_0-1717411076874.png

Date eq 'formatDateTime(utcNow(), 'dd.MM.yyyy')'

 

Bajda_1-1717411135791.png

 

Flow Test:

Bajda_2-1717411175582.pngBajda_3-1717411182639.png

There is no item in the body, there should be 3 items. Can you help me?

 

Thanks in advance!

 

Categories:
I have the same question (0)
  • Verified answer
    ManishSolanki Profile Picture
    15,091 Super User 2025 Season 2 on at
    Re: Filter query Get items SharePoint Date

    Hi @Bajda 

     

    Pls try below format in formatdatetime function:

    formatDateTime(utcNow(), 'yyyy-MM-dd')

     

     

     

     

    If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.

     

  • Bajda Profile Picture
    52 on at
    Re: Filter query Get items SharePoint Date

    Always no data 

  • ManishSolanki Profile Picture
    15,091 Super User 2025 Season 2 on at
    Re: Filter query Get items SharePoint Date

    Pls try to increase the size of pagination. Click (...) & select "Settings" from sub menu:

    ManishSolanki_0-1717413095140.png

    Toggle on 'Pagination' switch & enter 100000 in 'Threshold' textbox:

    ManishSolanki_1-1717413150586.png

    Click "Done" to save changes & retest the flow.

     

     

     

    If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.

     

     

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

Forum hierarchy changes are complete!

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…

Leaderboard > Power Automate

#1
Tomac Profile Picture

Tomac 497 Moderator

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 477 Super User 2025 Season 2

#3
chiaraalina Profile Picture

chiaraalina 242

Last 30 days Overall leaderboard