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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Get items date filter ...
Power Automate
Answered

Get items date filter query

(0) ShareShare
ReportReport
Posted on by 86

Hi all, 

 

I'm having issues with my power automate flow, i'm trying to get items from a sharepoint list called "solicitudes" when "Fechaderecogida" (text column) is one day greater than today. The value of "fechaderecogida" column comes from power apps in "dd-MM-yyyy" format.  I have built the flow but it's not finding anything when running it. Can someone help me finding the issue?

silviavg_0-1658845888512.png

 

Categories:
I have the same question (0)
  • Hardesh15 Profile Picture
    7,087 Super User 2024 Season 1 on at

    @silviavg pls take help from this https://www.gopenly.in/sharepoint-get-items-and-filter-query-in-flow-part-3/

    Please 'Thumbs Up' the posts that helped you and 'Accept as Solution' if my post answered your question.

    @Hardesh /Gopenly.in

  • Verified answer
    v-peijunz-msft Profile Picture
    Microsoft Employee on at

    Hi @silviavg,

     

    Based on your description, I have made a simple test for your reference.

    1. I have a SharePoint list called Ignoreblank, and it has a text column called Fech, with "dd-MM-yyyy" format.

    vpeijunzmsft_0-1658906977723.png

    2. Here is my flow:

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

    vpeijunzmsft_1-1658906977729.png

    vpeijunzmsft_2-1658906977732.png

    3. Result screenshot:

    vpeijunzmsft_3-1658906977733.png

     

    And a kindly reminder: you could pixelate your site address in your actions, which includes your personal information.

     

    Best regards,

    Sylvia

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the March Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Haque Profile Picture

Haque 608

#2
Valantis Profile Picture

Valantis 416

#3
11manish Profile Picture

11manish 348

Last 30 days Overall leaderboard