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?
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?
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?
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.'.
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?
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?
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
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?
Great. You solved my problem
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... 🙂