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 / Reminder on a date in ...
Power Automate
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

Categories:
  • Ellis Karim Profile Picture
    12,277 Super User 2026 Season 2 on at

    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.

  • margheritamart Profile Picture
    4 on at

    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
    12,277 Super User 2026 Season 2 on at

    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

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

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 July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
David_MA Profile Picture

David_MA 227 Super User 2026 Season 2

#2
11manish Profile Picture

11manish 221 Super User 2026 Season 2

#3
Mohsin Ali Profile Picture

Mohsin Ali 132

Last 30 days Overall leaderboard