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?
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
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?
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?
OK so this worked great but it doesn't seem to take into account the Yes/No "Item Returned" field. Whether there is a Yes or No in that column, the flow just runs endlessly. Did you forget to add in the last step, that takes into account the "Yes" answer, or did I miss something?
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.'.
Great. You solved my problem
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?
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
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?
Yes, that would work and save you from using it in your condition later on. Nice catch
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?
OK so this worked great but it doesn't seem to take into account the Yes/No "Item Returned" field. Whether there is a Yes or No in that column, the flow just runs endlessly. Did you forget to add in the last step, that takes into account the "Yes" answer, or did I miss something?
my days show -days over postive days
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.'.
date difference function can return difference in days ... no need to put such complicate formula... 🙂