Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Automate - Building Flows
Unanswered

Reminder on a date in sharepoint list based on a specific view

(0) ShareShare
ReportReport
Posted on by 4

Hello,

 

I have not been able to figure out how to narrow a notification in power automate based on a specific view. I would like to create a reminder email 20 days before on the 'Handover Date' field for items that are in specific view of a list. I can otherwise setup the criteria as Items that have these criteria Department = DD or CC and Status = Budgeted or New and send a list to specific stakeholders to alert that these items are due within 20 days.

Thanks!!!!

Marg

  • Ellis Karim Profile Picture
    11,078 Super User 2025 Season 1 on at
    Re: Reminder on a date in sharepoint list based on a specific view

    I would start with defining the filter queries. For that you can use OData Filter queries and Filter array actions.


    Snag_12937b03.png

     

    See this tutorial:  Get items OData Filter Query Simplified

     

    You could then create a flow to run every day (a scheduled cloud flow) that would send out a reminder email if your criteria is matched in the filters queries.

     

    Hope this helps.

     

     

    Ellis

  • margheritamart Profile Picture
    4 on at
    Re: Reminder on a date in sharepoint list based on a specific view

    Hello Ellis,

     

    Thank you for your answer but I did see this option and it doesn't help. This is because this option is narrowing by columns in a view while I am trying to narrow by selected filters in a view. Let's say, I have created a view that show me all the projects filtering per department, I would like to create a reminder when the handover date of a project is due. In practice, more than related to views, I realize that my question is more  "how I create a reminder on  a selection of items based on a number of criteria, like department name, status of the project and handover date" 

  • Ellis Karim Profile Picture
    11,078 Super User 2025 Season 1 on at
    Re: Reminder on a date in sharepoint list based on a specific view

    If you expand the Show advanced options, you can select a SharePoint view for your Get Items action:

     

    Snag_3f304cd.png

    Snag_3f32d05.png


    Ellis
    ____________________________________
    If I have answered your question, please mark the post as Solved.
    If you like my response, please give it a Thumbs Up.

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

Michael Gernaey – Community Spotlight

We are honored to recognize Michael Gernaey as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 566 Super User 2025 Season 1

#2
David_MA Profile Picture

David_MA 516 Super User 2025 Season 1

#3
stampcoin Profile Picture

stampcoin 492