Skip to main content

Notifications

Power Automate - Building Flows
Suggested answer

Sharepoint List - Automate Email Reminder for Date Entered/Days Since columns

(0) ShareShare
ReportReport
Posted on by 4
Hello,
 
I am quite new to automate and need some help with a work flow.
 
I would like the column "Days Since Last Action" to trigger an e-mail reminder to the "AssignedTo" at 7, 30, and 60 day intervals. The Days since is a numbers column, Date entered is date/time. 
 
 
Thank you!
  • rzaneti Profile Picture
    rzaneti 3,404 on at
    Sharepoint List - Automate Email Reminder for Date Entered/Days Since columns
     
    This is happening because, for some reason, the condition is returning as false. 
     
    Could you please share and image of your Condition inputs, similarly to what you did for the "Send an email" action?
  • CC-08012036-0 Profile Picture
    CC-08012036-0 4 on at
    Sharepoint List - Automate Email Reminder for Date Entered/Days Since columns
    Also,
     
    ActionBranchingConditionNotSatisfied
    The execution of template action 'Send_an_email_(V2)' skipped: the branching condition for this action is not satisfied.
  • CC-08012036-0 Profile Picture
    CC-08012036-0 4 on at
    Sharepoint List - Automate Email Reminder for Date Entered/Days Since columns
    @rzaneti , thank you for the reply - the flow works but skips the automated e-mail:
     
    {
      "type": "OpenApiConnection",
      "inputs": {
        "parameters": {
          "emailMessage/To": "@item()?['ProgramManagerTEST/Email']",
          "emailMessage/Subject": "@{item()?['Title']} is past due by @{outputs('Compose')} days in the Customer Submissions Registry.",
          "emailMessage/Body": "<p class=\"editor-paragraph\">@{item()?['Title']} , @{item()?['Days_x0020_Since_x0020_Last_x002']} , @{item()?['StartDate']}, @{item()?['Description']}</p>",
          "emailMessage/Importance": "Normal"
        },
        "host": {
          "apiId": "/providers/Microsoft.PowerApps/apis/shared_office365",
          "connection": "shared_office365",
          "operationId": "SendEmailV2"
        }
      }
    }
     

     
  • rzaneti Profile Picture
    rzaneti 3,404 on at
    Sharepoint List - Automate Email Reminder for Date Entered/Days Since columns
     
    I just want to confirm if you had a chance to test the solution recommended in my previous message.
     
    If it's working properly and answered your question, please mark it as Accepted Answer, so other users with the same issue can find it easily in the future :)
     
     
    -------------------------------------------------------------------------
  • Suggested answer
    rzaneti Profile Picture
    rzaneti 3,404 on at
    Sharepoint List - Automate Email Reminder for Date Entered/Days Since columns
    Hi,
     
    That's a great use case. I will use the following SP List as sample data for this solution;
     
     
    To start, you can add a Recurrence trigger (highlighted in orange) and set up the frequency to 1 day (highlighted blue). You can also set a time for the flow to run (highlighted in red). After that, add a Get items action (highlighted in green) and populate it with the respective List (highlighted in yellow). It will access all records from your List:
         
     
     
    Now you can add an Apply to each loop (highlighted in red) and pass the dynamic content from the body/value property of your Get items (highlighted in blue). This action will iterate all records from you SharePoint List and perform some steps to each one of them. I'm also including a Compose to simply print the values from each iterated record when the flow runs, but this is not a required step:   
     
    Inside the loop, add a Condition and in the left-side input, add the dynamic content of your days count column (days_late in my case). Set the center dropdown to is equal to (highlighted in green) and type your respective notification days qty in the right-side input (highlighted in orange). Add two more statements by clicking in New item (highlighted in red) and repeat the same process, just changing the quantity of days in the right-side input to match your 3 scenarios. Before moving forward, change the operator on the top-right corner to OR (highlighted in blue):
     
    In this Condition step, you will test if the quantity of days without action for each of the List records, and execute some task if the quantity of days is equal to 7, 30 or 60 (or, in my case, 2, 5 or 12). 
     
    Now you can add your Send email action to the True block of the Condition (highlighted in blue), since it will be executed only if the quantity of days match the values specified in the previous step. In my case, I'm instead simply adding a Compose action to print the actual Days late for each iteration (highlighted in red). You can leave the False block empty:
     
     
    After running the flow, you can see that the condition returns false when the qty of days is 22:
     
    But it returns true when the qty of days is equal to 12 (and for 2 and 5 as well): 
     
    Additional resources
    I'm also sharing a few resources related to the topics discussed in this solution, which can be helpful for you or any users that find this thread in the future.
    - Video: Dynamic contents in Power Automate: https://youtu.be/jpledJfaEPQ
     
    Let me know if it works for you or if you need any additional help!

    -------------------------------------------------------------------------
    If this is the answer for your question, please mark the post as Accepted Answer.
    If this answer helps you in any way, please give it a like.

    http://digitalmill.net/
    https://www.linkedin.com/in/raphael-haus-zaneti/
     

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

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,526

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,907

Leaderboard