How to Send Automated Past Due Date Emails Using Power Automate | DateDifference() | 2024 Tutorial

[@mron4161]

11:55 Very discouraging. Every video I follow with a similar structure fails at this step. When I select my "Rented by Email" in Get Items, it then adds an Apply to each right above the email, with "Current item" already in it, then the flow fails. Please help.

[@mariakravchenko2631]

got the ActionConditionFailed. The execution of template action 'DateRented' is skipped; there are no items to repeat. do you know where could be the issue?

[@mattnorthrip]

Hi Michael. How would you deal with Null values in your date rented column?

[@michaelalex2322]

You have to write a custom formula in Power Automate. It's an if statement with an equals statement inside. If it equals nothing, return null else the date.

[@parent9562]

Hi, I was hoping someone may be able to help me please? I want to create a workflow to have an email sent out automatically every day with all sharepoint list entries from the previous day. Any assistance would be awesome. Thanks

[@surendra1619]

Great. You solved my problem

[@vze1nv918]

Thank you for this! I have a thought for another video like this: how about how to create an automation that weekly (say, every Monday morning) sends an automated email to each person in the Rented By column, detailing which of their Equipments are past due? One email, but with multiple line items, one for each Equipment that's past due?

[@jasonmelchert155]

Thanks for the video. I noticed you didn’t have any items that were Yes in the returned column in your list. Would you filter those out in the get items step?

[@michaelalex2322]

Yes, that would work and save you from using it in your condition later on. Nice catch

[@EllieCarter5225]

hmmm.. I could not get it to work. Error: Action 'Condition' failed Error Details: Unable to process template language expressions for action 'Condition' at line '0' and column '0': 'The template language function 'greater' expects two parameter of matching types. The function was invoked with values of type 'String' and 'Integer' that do not match.'.

[@TheIconRichie]

my days show -days over postive days

[@nn_2104]

date difference function can return difference in days ... no need to put such complicate formula... 🙂