Hi All,
Complete newb here so be gentle, also, not sure if I'm asking in the correct community either.
I am trying to create a flow to help with keeping track of maintenance work on our equipment. I have added all of our assets to a Share Point list which amongst others, have the columns below..
- Service Date – Date and Time type
- Service Due Date – Date and Time type
- Service Intervals – Number type
- Service Completed – Choice type
I have created a flow to carry out the following using conditions, switches and update items. What I would like for it to do is when an engineer changes the 'Service Completed' option to Completed, for it to then check whether it is a 7, 14 or 28 day interval and add that number to todays date on to the 'Service Due Date' and for it to change 'Service Date' to today’s date.
It is working, but very inconsistently, not more often. Sometimes it works as expected and then it would randomly add 7 days to an item that should be 28 days, it would never add 28 days to a 7 day item though strangely. Sometimes, when it works and adds 28 days I would go back in to that item and it would have changed it to 7 on its own.
I don't think that it is stuck in a loop but you may be able to tell me differently? Please take a look at my flow and let me know where I am going wrong.
I think, what I have asked for it to do is the following:-
- When an item is modified
- and 'Service Completed' is changed to 'Complete' (Condition) triggerOutputs()?['body/ServiceComplete/Value'] The actual column is 'Service Completed' and not 'Service Complete', not sure if this would make a difference but it won't let me change it.
- IF 'Service Intervals' is 7 (or 14 or 28) (Switch) triggerOutputs()?['body/ServiceIntervals']
- Change 'Service Due Date' by +7days by using addDays(utcNow(),7)
- Change 'Serviced Date' to todays date using addDays(utcNow(),0)
I would greatly appreciate any help on this, I have been trying for way too long!
Thanks,
Craig
