Skip to main content
Community site session details

Community site session details

Session Id :
Power Automate - Building Flows
Answered

Creating a Flow based on Modified date in a SharePoint list that generates a Teams message

(0) ShareShare
ReportReport
Posted on by 17

I am trying to create a flow that sends a Teams message to the creator of an item in a SharePoint list if that item has not been modified in 30 days or more.  From what I can tell the primary hurdle I am trying to overcome is the trigger, which is currently intended on being the Modified date of the item in the SharePoint list.  When I test the flow everything checks out but when I run the flow no Teams messages are generated.  In and of itself, that has me questioning how I am supposed to know if my flow actually works if it passes the test and doesn't work.  That aside, here is my current state:

 

Power_Noob_0-1679518101085.png

 

Power_Noob_1-1679518190178.png

 

and here is the text of the conditional function above:  

less(string(item()['UpdateByDate']),addDays(utcNow(),30))
 
 
I have piecemealed all of this together based on different threads I found here and there online.  I don't understand why I would filter the items in the "Get items" section and then also have a conditional statement in the "Apply to each" section.  Maybe that is part of the problem.  Any help you can offer would be most appreciated.  Thank you for your time.
  • Power_Noob Profile Picture
    17 on at
    Re: Creating a Flow based on Modified date in a SharePoint list that generates a Teams message

    You are a life saver.  Thank you so much!!!

  • Verified answer
    v-liwei-msft Profile Picture
    on at
    Re: Creating a Flow based on Modified date in a SharePoint list that generates a Teams message

    Hi @Power_Noob 

     

    Please try:

     

    vliweimsft_1-1679553632833.png

     

     

    Best Regards,

    Levi

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

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June 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 497 Super User 2025 Season 1

#2
David_MA Profile Picture

David_MA 436 Super User 2025 Season 1

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 244 Super User 2025 Season 1