I want to track equipment usage and availability from projects at work. This will involve different equipment being used and different tests. For example, a cyclic test which will use 3 pieces of equipment (Equip1 for 3 days, then Equip2 for 1 day and Equip3 for 3 days) This is cycled every 7 days for the length of the test. I need to be able to see current capacity usage, future availability of equipment and ongoing free capacity of the equipment. Is there a way to have it so you enter the test ‘template’ ID, Start date, test duration and capacity used, then it automatically works out end date and populates the equipment used for that test including any cycles? So, I might have one test which is just 100 days in one piece of equipment (Equip1). But then another test which is 180 days of 7 day cycles between the 3 different pieces of equipment. Then I can have a calendar view for all the equipment showing what is in use and how much space is available in it? I’ll also need to select which piece of equipment is to be used for each type. (for example, for Equip1 we have 5 machines, labelled A, B, C, D & E). I need to include Capacity used, total capacity used per piece of equipment. How best do I set this up? Maybe set up to populate with existing testing and then add the option to request and add testing with availability checker later. Is Lists and Power Automate the easiest way to do this? I’ve been trying to use Co-Pilot and ChatGPT to talk me through it, but it isn’t working and they’re taking me in circles.
So far, I’ve set up lists in Microsoft Lists: Test list, Test template, Template Steps, Equipment Master and Equipment Schedule. But when I’ve created flows, they struggle to get the info from list and populate the schedule. I have limited knowledge of working with flows, so this is a bit more complicated than I have the experience for.
