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 : 25dloC/Wf3wXC4cZE7BgYt
Power Automate - Building Flows
Answered

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

Like (0) ShareShare
ReportReport
Posted on 22 Mar 2023 20:53:43 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.
I have the same question (0)
  • Power_Noob Profile Picture
    17 on 23 Mar 2023 at 15:08:45
    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 23 Mar 2023 at 06:39:58
    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

Responsible AI policies

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

MS.Ragavendar – Community Spotlight

We are honored to recognize Ragavendar Swaminatha Subramanian as our September…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 954 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 650 Moderator

#3
trice602 Profile Picture

trice602 327 Super User 2025 Season 2

Last 30 days Overall leaderboard