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,
Thank you Damien. I'm slowly getting there, but missing 2 things, still completely new to Flow : )
This is what i created so far (See the picture).
With this flow i can get an email (empty for the moment) when the value is changed to Yes, which is great.
However i still need to define two things:
- I want to define same rule when someone sets it to No and then the action will be sending another email. How exactly do i do it? Another condition or?
- In the subject and body of the email what variable do i need to put in order to mention the exact person that changed the value?
Hi ikoalosaurus
Nice work, you already have what you need in the flow.
Your condition already accounts for Yes or No as when the item is modified it checks to see if it's Yes (if it's No it goes the other way).
Just put an email into the No area.
In terms of the values you put in, when you click into the subject and body of the email, look in Dynamic content under When an item is created or modified and you will see options for Modified by DisplayName to use.
Let us know how you go?
EDIT: Just noticed that you are using Yes for the condition. Use True instead as that's the value it picks up.
Cheers and best wishes
Damien