Forum Discussion
Updating specific List Column value with Flow?
ikoalosaurus Yes, that's doable, but why would you want to do that? Why spam someone with dozens of emails about people starting or ending their shifts?? How will the receiver of these emails get an overview of the big picture?
Wouldn't it make more sense to give that receiver of the emails a view where they can see who is currently on shift and who is not? That would be just a list view that they can pull up at any time, and they don't have to find and interpret the two dozen emails they have been sent from a workflow during the day.
Also, if you set the default view of the list to be filtered so people can only see the items where the <shift person> column equals [Me], they can just pull up the list, see their own record and edit it. That will greatly reduce the probability of Mark accidentally editing the item for Jane. You can also turn on versioning, so each and every item change can be traced back to who made the change.
You can create a site page for supervisors. This page can have a list view that shows all items, grouped or sorted by who is on shift. Set the permissions for this page so only a certain group of people can access it. That way, your regular Jane Bloggs will not easily be able to look at other people's shifts. It's not fool proof, but it requires quite a bit of SharePoint knowledge to unravel and expose,
ikoalosaurus Yes, that's doable, but why would you want to do that? Why spam someone with dozens of emails about people starting or ending their shifts?? How will the receiver of these emails get an overview of the big picture?
Wouldn't it make more sense to give that receiver of the emails a view where they can see who is currently on shift and who is not? That would be just a list view that they can pull up at any time, and they don't have to find and interpret the two dozen emails they have been sent from a workflow during the day.
Also, if you set the default view of the list to be filtered so people can only see the items where the <shift person> column equals [Me], they can just pull up the list, see their own record and edit it. That will greatly reduce the probability of Mark accidentally editing the item for Jane. You can also turn on versioning, so each and every item change can be traced back to who made the change.
You can create a site page for supervisors. This page can have a list view that shows all items, grouped or sorted by who is on shift. Set the permissions for this page so only a certain group of people can access it. That way, your regular Jane Bloggs will not easily be able to look at other people's shifts. It's not fool proof, but it requires quite a bit of SharePoint knowledge to unravel and expose,
Let me elaborate : )
This is a team of freelancers, meaning, people are not sitting in an office, there are people all around the world, working in different time zones, and most people have never seen each other, the idea is to have a public list where everybody can see if the person is actually working today. Because, even though there are defined working hours of every person, sometimes people just call the day off and other people are not aware if that person is present or not, except the manager of course.
For the whole team, it's very useful if we can all see who's actually present on that day and who's not.
I agree that the email notifications might not be the best notification system out there, but we need something which is using sharepoint and flow out of the box meaning no customizations, that can notify our whole team who's present , who's not. I was thinking, yeah we are not going to check those email on daily basis, but if we are looking for someone and for example they're away, we might check the inbox if that person actually started the shift (clicked on yes early in the morning).
So yeah, no supervisors, no filtered views, it should one default view for the list, visible by everyone, where we can actually see whether the person was online on that day.
Is there no way for the list to keep read permission level, and to somehow explicitly share each list item with the person so that they can edit it only that item, and no other items, keeping in mind that all list items are created by myself? I tried to share item with a person granting them edit access, they get the new option to edit the item, but once they change the value, the page "you don't have access" loads.
Let's pick this apart.
If this is an international team, then everyone would benefit from one place where they can see all the information at a glance. - Use a SharePoint list view that shows who's currently in and who is not in.
Can we assume that people want to work together and not sabotage each other? If versioning is turned on, there is an audit trail that shows exactly when a change was made, and by whom. If people mess around with records they should not change, well, that would be a career limiting move, no? Therefore, giving everyone edit access should not be a problem.
If this still is a problem, why don't you create a totally new list that has just one field for In/Out and let everyone have edit access to that list?
This really does not need a complicated flow.
Yesterday i asked all my people to create the entry for themselves. They did it. So right now, i have all the items in the list, created by the right people, and the current scenario is that each person can edit only their own item, meaning no changes on other people's items can be done.
Thank you Damien. Since i resolved the issue of people potentially changing someone else's item, what steps can i skip from your proposed workflow?
Now i need only this logic:
If Person XYZ changed the XYZ Column value to Yes in the List XYZ - an email is sent (or any other action).
Same for No.
Hi ikoalosaurus
Glad to hear things moving in the right direction.
You will only need STEP 1 and STEP 2A. Ignore the rest (lucky too as I had a loop I forgot to fix).
Essentially STEP 1 is to add the When an item is created or modified as a trigger.
STEP 2A is to add the condition saying that when the field is changed YES/NO, trigger the email.
That should be all you need to cover notifications of when someone comes on duty and off.
Let me know if that does the trick?
Cheers
Damien
