Flow based on task app

[priya93]

Hi All,

I am running flow on Sharepoint task app. The scenario is whenever a task is assigned to people only the concerned people who has been assigned will be able to view or edit. I have succeeded to doing so. The next scenario is i want that if the "task status value" is equal to completed , the concerned people will not able to edit again .i have used the following flow. But it is taking long time to trigger as well as not working properly also.

[yashag2255]

Hi @priya93 

I would suggest you to use trigger conditions for such scenarios in MS Power Automate. You can find the guide to do this here: 

https://siddharthvaghasia.com/2019/08/06/trigger-ms-flow-on-condition-based-on-columns-value-with-sh... 

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!

[v-bacao-msft]

Hi @priya93 ,

Please consider the method provided by @yashag2255 to reconfigure Flow.

In addition, if the type of the Task status field is Choice, make sure to select Task Status Value as the parameter configuration in Condition.

Please take a try.

Best Regards,

[priya93]

Hi @yashag2255  & @v-bacao-msft ,
Thanks for above solution, it is working fine as i have put condition in setting option , put a condition @equals(triggerBody()?[' Task Status']?['value'],'Completed') , that is whenever a task status is completed it will restrict the user to only view , that is now user can only view the task.

But i want in my scenario that if task status is not completed then user can edit the task list, add comments. once it is completed no one can edit. Therefor i want a condition that is if the task status is not completed the user can edit the task list,if the task status is completed , the user can't edit the task.

[yashag2255]

Hi @priya93 

The SharePoint Triggers are all based on recurrence and so it might take some time to trigger the flow sometimes. 

About the scenario: 

1. If the person has marked the task as completed, they will not be able to edit it based on the configuration you have set for the flow and when it is not marked as complete the user can normally edit it right? 

If not, then you will have to go the condition way to trigger the flow every-time and check the status and perform actions based on that. 

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!

[priya93]

HI @yashag2255 ,
Thanks for replying. I have used the condition trigger as us mentioned, but as i have attached my screenshot in beginning, it is taking much time to trigger as well as it not working fine. 

[yashag2255]

Hi @priya93 

In the condition box, you need to select the Task Status Value from the dynamic selector and use the operand as "Equals to" instead of "Contains" and then type the exact choice option as used on the sp list. Can you try this once? Ensure that there is no trigger condition that is configured in this case. 

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!

[priya93]

Hi @yashag2255 ,

Thanks for replying. I have done changes as you suggested. Attached is the screenshot. But still in the action part it is skipping and giving outcome false in condition

[yashag2255 · Accepted solution]

Hey @priya93 

Can you check if there are any spaces after "Complete" in the condition or in the SP Column? Can you try to do this: When an item is created or modified-> Get item (use the id from the trigger to get the item) and then use the task status value from the outputs of the get item action and then compare with completed?  Also, can you confirm that the correct column is being used for the comparision? You can also check the task status value in the outputs of the trigger action after the flow is run to check if the correct column is being referenced. 

I just made a test on my side and it works as expected. 

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!

[priya93]

Hi @yashag2255 ,
If you have implemented the solution in your system, can you share screenshots it will be helpful to me.

[yashag2255]

Hey @priya93 

Were you able to resolve? 

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!

[priya93]

Hi @yashag2255 ,
Thanks for replying,
I have done changes in my flow like below. But still the person is able to edit form.

[yashag2255]

Hey @priya93 

Can you check the original permissions for the user that you are trying to make the item view only? Note that if the user has can edit permission by default on the List, irrespective of you providing the can view in the flow, they will be able to edit the item. You need to first remove the access from the list for the user and keep it as view only and then in the flow provide edit i the condition is not met and keep it as view only if the condition is met. 

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!

[priya93]

Hi @yashag2255 ,
Thanks for replying. i checked the user permission but as you told when the task status is not completed it is giving false result and going to yes part as you can see from screenshot. and skipping the statement, instead it should go to no part and execute the statement.

[yashag2255]

Hey @priya93 

As the condition is not met, the result is false and the Yes branch is skipped. You can check the no branch and you will see that the flow has been executing the steps in the no branch. 

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!

[priya93]

HI @yashag2255 ,
My flow is taking time time around 10 min to trigger . if i am creating task in task list then it is taking almost 10-12 min after which flow is executing. Can you help.