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.
Conceptually, you use the Get Items action to get a list of the items. Use the filter settings to return only the items you want to change. Then use a for-each action to update each item.
Thank you.
This is what i'm trying to do.
There is a column of type yes/no, called "Available now" in my schedule shift list that i created.
I need a flow which will do something like this:
-Either automatically update the field to Yes of each worker when they do a trigger (which could be sending an email to a specified mailbox for example, or alternatively something else)
-Or, people click on the list with their item name, change the value from no to yes, and then flow sends an email to a specified mailbox.
Could you somehow help me how to achieve this?
Thank you
ikoalosaurus Both things you describe are possible, the latter is a bit easier, since the trigger is when a SharePoint list item is modified. I'm not so clear on the trigger for the other option.
Before we proceed, maybe you could make a decision about which approach you want to use?
Dear Ingeborg , thank you for the fast reply.
The only problem with the latter option is that, currently all the entries in the list (100 entries for 100 people) are created by myself, which means, they cannot edit their own entries unless i set the permissions so. If the entries were created all by themselves, they would be able to edit only their own entry (with their name). But, it's ok, i can live with that, i will give the permissions on the list so that everyoone can edit all items, assuming, they will edit only their own entry : )
So, the idea is :
Mark comes online at 8:00 in the morning, opens the list, finds his name in the list, and changes value of "Available Now" column from no to yes. An email is sent to the XY person saying "Mark has started the shift.
Later during the day, John starts the shift at 11:00 let's say, and the flow is the same.
Then, when Mark ends the shift at 16:00, he changes the value from no to yes and another email is sent saying "Mark has ended the shift".
Is that doable? : )
If that works, instead of yes/no column i could create multiple choice column with choices: yes, no, break, so that we include the break as well.
Cheers Ingeborg : )
Yes,
when List is updated or modified
Add Condition
If Value is Yes
Send Email
If Value is No
Stop Flow
In my view, the when item is modified isn't exactly instant so the email might be sent a while after the actual event.
