How to create a 'flow' that creates a shift when List item is modified
Hi,
I want to create a ‘flow’ that would automatically create a new Shift when a user updates certain columns in a List. For example;
column 1 (title/item column) : Manager
Column 2 (yes/no column) : yes
Allocated (person column): Jane Doe
Date Column (with time) 1: 7-Oct-20 1:00PM
Date Column (with time) 3: 7-Oct-20 5:00PM
I want a flow to be ‘triggered’ when column 1 = yes and I want it to create a shift from 1PM (date column 2) - 5PM (date column 3) on 7 October for (item column 1) Manager (i.e. ‘manager’ is the person assigned to the shift) .
I then want to create a second flow (or as part of the same flow if possible) whereby the ‘allocated person’ (‘person column) is sent an email confirming that ‘Manager’ has a shift from 1PM - 5PM on 7 October.
Is any of the above possible??
In case it isn’t already apparent, I have very little understanding of how to ‘code’ / create strings etc.