Creative SharePoint Calendar and Power Automate Solution
Hey Community, I have a unique calendar to track data on company vehicles that I need help with. I'll explain how we were doing it and how I would like it to change. This is going to be a detailed explanation so thank you for reading. Currently we track departure and return miles for each vehicle we issue out. We were doing all of this in On Prem using Infowise to do the logic, but we have migrated over to Online and now I want to restructure the logic with Power Automate. In On Prem, we had a separate list that stored the vehicle names and that was linked to the calendar via an Infowise Master-Detail Lookup field. Then we had a separate list that would store the departure mileage of each vehicle. In the calendar, whenever someone would log the RETURN miles, an infowise action would run and that return miles number would be dropped into the DEPARTURE miles list for the correct vehicle. This was so that when a new reservation was made for that vehicle, the previous return miles would be the new departure miles. See attached picture to see the On Prem version of the calendar list. Ex: the white cargo van was issued out with departure miles at 1000, when it comes back it its return miles are 1050. This 1050 gets put into the return miles list and conditional logic drops that number into the field for the white cargo van and not another vehicle. When the white cargo van is issued again, an infowise action runs and autopopulates the Departure miles field with the 1050 number from the return miles list. And so on. Now that we are in SPO, we don't have Infowise and I want to restructure the logic with Power Automate. Is there a better way to accomplish this with Power Automate than how we did it with Infowise and storing values in other lists? I'm thinking we could make use of variables and storing the return miles into a variable and recalling that variable for the departure miles on a new reservation. But it would have to be conditional to make sure the vehicle name is the same and its not getting data from another vehicle. Just trying to make it to where we don't have so many extra lists to pull and store data in. There's got to be an efficient way to accomplish this with Power Automate. I just don't quite know where to start. Any ideas? Thanks for reading through!