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 Automate - Building Flows
Answered

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!

 

I have the same question (0)
  • Verified answer
    ManishSolanki Profile Picture
    15,089 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,089 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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Chiara Carbone – Community Spotlight

We are honored to recognize Chiara Carbone as our Community Spotlight for November…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 614 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 401 Moderator

#3
chiaraalina Profile Picture

chiaraalina 282

Last 30 days Overall leaderboard