cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
priya93
Helper I
Helper I

Flow based on task app

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.

Captureflow.PNG

1 ACCEPTED SOLUTION

Accepted Solutions
yashag2255
Dual Super User II
Dual Super User II

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!

View solution in original post

15 REPLIES 15
yashag2255
Dual Super User II
Dual Super User II

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
Community Support
Community Support

 

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,

Community Support Team _ Barry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
priya93
Helper I
Helper I

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.

Capture890.PNG

 

yashag2255
Dual Super User II
Dual Super User II

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!

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. 

Capture891.PNGCaptureflow.PNG

yashag2255
Dual Super User II
Dual Super User II

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!

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

Captureflow23.PNGCapture891.PNG

yashag2255
Dual Super User II
Dual Super User II

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!

View solution in original post

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

yashag2255
Dual Super User II
Dual Super User II

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!

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

yashag2255
Dual Super User II
Dual Super User II

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!

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.

Captureflow102.PNG

yashag2255
Dual Super User II
Dual Super User II

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!

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.

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Users online (3,350)