hi all,
i'm trying to create a flow on a sharepoint task list (reflected from Ms Project File) to check outputs of a get items function, then send mail only if all predessors are completed, simple logic as below:
Solved! Go to Solution.
Hi @Ahmad_Hlawa,
For the flow effect you want to achieve, I suggest you take @LeeHarris measure of marking with variables. Here's a workaround for your test:
Step1: Initialize a variable to count the number of not complete tasks, I set the default value is 0.
Step2: Since I don't know what predecessors you used, so I use Get items instead, and add Apply tp each to judge every completion of the task.
-If the value is equal to 0, increase variable;
-If not, do nothing.
Step3: Judge the variables whether equal to 0, if yes, send the email.
For the issue of your reply, is it possible at the part of the red line marked? Is the value of the current item array? If yes, you can change the condition function (item('Apply_to_each')?['PercentComplete]) into (item()?['PercentComplete'])
Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Ahmad_Hlawa
You may be able to make use of the Terminate action within your apply to each loop. If the predecessor completion is not equal to 1 then simply Terminate the Flow to prevent any further actions being executed.
Alternatively, if you need to continue but just not send the notification. Initialize a boolean variable (called ProcessContinue) at the start of your Flow with a value of True and then set it to False in your apply to each loop if any of the Predecessors dont meet the condition criteria. Before you send your notification, check the "ProcessContinue" variable and if its False then don't send the alert.
Follow me on Twitter at @QG_LeeJHarris
Or on LinkedIn at in/leejharris
hanks for the quick reply.
let me go in more details to the issue.
i'll give a try to the proposed about the apply to each.
but the other issue, is that the flow don't understand the below function to get the predessor completion date?( function in the 2nd condition is (item('Apply_to_each')?['PercentComplete])
Hi @Ahmad_Hlawa,
For the flow effect you want to achieve, I suggest you take @LeeHarris measure of marking with variables. Here's a workaround for your test:
Step1: Initialize a variable to count the number of not complete tasks, I set the default value is 0.
Step2: Since I don't know what predecessors you used, so I use Get items instead, and add Apply tp each to judge every completion of the task.
-If the value is equal to 0, increase variable;
-If not, do nothing.
Step3: Judge the variables whether equal to 0, if yes, send the email.
For the issue of your reply, is it possible at the part of the red line marked? Is the value of the current item array? If yes, you can change the condition function (item('Apply_to_each')?['PercentComplete]) into (item()?['PercentComplete'])
Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Announcing a new way to share your feedback with the Power Automate Team.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
User | Count |
---|---|
75 | |
22 | |
18 | |
17 | |
13 |
User | Count |
---|---|
127 | |
37 | |
29 | |
28 | |
25 |