You’re offline. This is a read only version of the page.
333
Hi,
I am trying to build a flow that does the following:
In the field "Assigned to" (which is a person field), when I select someone and assign them a task, the flow then automatically updates the task status to Available, and also populates the field "Assigned to email", with the assigned persons email.
I have managed to get this to work, but the way I have done it means that everytime I update anything in the list, it triggers the flow....
So once someone has been assigned and the flow has updated the status and added the assigned to email, it will no longer trigger based on any other changes made to other fields in the list - only when the assigned to field is filled in or modified.
@efialttes With a bit of googling, I have managed to make this work. I now have one more flow to change and I have my system working well thanks to your help!.
I have adopted this method for the other two flows that are part of this chain of updating the jobstatus.
Thanks again!!
@efialttes Ok this sounds about right. I have my trigger as being when an item is created or modified, check if AssignedTo is null, if so, go to the next step, otherwise do nothing. The next step then checks if StatusChange is equal to true
So I would need to swap the order of these two conditions?
And then in the Trigger Condition, as per your example, would I write the following: @equals(triggerBody()?['StatusChange'],true)
I am still getting my head around the logic, but I don't think I have it quite right, because when I look at what I have, it should mean that anytime the StatusChange column is set to Yes/True, then it will fire the flow......so perhaps I do something similar to yours with a @endsWith ?
Hi!
I guess you implemented the evaluation logic after the trigger by means of a Condition action block, right?
So if your logic shall be executed only when the new 'Yes/No' column is set to Yes, you can probably move the condition evaluation to the trigger itself. This feature is called "Trigger Conditions", meaning flow will only start execution if condition is met.
Please have a look to the following screenshot, the trigger is a different one, but the concept is the same
I have managed to get this working now by using a Yes/No column as @efialttes suggested.
So while the solution has been gained, I do have one last question;
My flows are seeming to be constantly triggered, even when items have not been created or updated. So is there a way to tell the flow to stop once it has achieved its set purpose?
Thanks for all the advice and help!
Hi!
Did you considered merging steps 4. and 5.?
It has pros and cons, obviously.
Merging means you do not need a 'flow triggered when item is updated' anymore, so current challenge wil be overcome. But, if from time to time you need a manual intervention on your SP list to assign tasks to teammates, you must remember to update Status column to 'available' also.
Hope this helps
@efialttes thanks for taking the time to look through my issue in such detail. I have started a trial list rather than working on my actual list so I can see what is happening more accurately with the data as well. So in doing so, I have tried building the flow from scratch again and I have got to this point:
When and item is created or modified and AssignedTo is equal to null, then do nothing, else, update items (add assigned to email and change status to available).
This works perfectly, but if I modify any other fields (change status to active) in the list once someone is assigned to the task, it changes the status back to available. I realise this is because the flow is seeing that the assigned to is not null, and therefore completes the action.
As you mentioned, having a Yes/No validation should fix it, so I am just working out how this would be done. As far as the overall process goes hopefully this helps;
So as far as the scenarios you have listed below, I would love to achieve all of them, but happy to leave out the swapping of staff allocation for the moment if that is making it more complicated, as it is not something that should occur much if at all.
Hi @BrendanZ1
In the condition, you should compare similar items. I guess it is just Modified in the right side which is a date time column. You can change to Assigned to Email in the left and Modified by Email in the right.
Hope this Helps!
If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!
it looks like the condition is not set properly with your requirement.
You may also check the run history to check the input value.
Hi again!
Now let's discus a little bit about your goal:
"when I select someone and assign them a task, the flow then automatically updates the task status to Available"
IN my opinion, this means:
1.- If item is already created with an 'Assigned to', person, flow shall update tasks status to Available. FRom your current procedure experience, can this scenario happen?
2.- If item did not have 'Assigned to' person defined yet, and this value is added, this modification shall trigger your flow logic to update tasks status to Available. FRom your current procedure experience, can this scenario happen?
3.- If item already had 'Assigned to' person defined, and item is modified, this modification shall NOT trigger your flow logic to update tasks status to Available.
4.- If an itemalready had 'Assigned to' person defined, and current person is replaced by another, this modification shall? shall not? trigger your flow logic to update tasks status to Available. FRom your current procedure experience, can this scenario happen?
So depending on the answers, I would suggest to add a yes/no new column (let's called 'Available set') whose default value is No, and is updated to yes by your trigger + a conditional trigger, so whenever this column value is yes, flow logic is not executed, or... activate version history on your Sharepoint list and use 'HTTP request to Sharepoint' to get current item value and previous version also. First approach is much more simple, Second approach is more elegant but more complicated to implement
Hope this helps
#1
Michael E. Gernaey
497
Super User 2025 Season 1
#2
David_MA
436
Super User 2025 Season 1
#3
Riyaz_riz11
244
Super User 2025 Season 1
Share
Report
All responses (
Answers (
