Flow triggered when a Task in ‘Project for the web’ is marked as complete

[MicrosoftAdmin]

Hi guys,

Thanks in advance for any assistance here.

I'd like to create a new Flow triggered when a Task in ‘Project for the web’ is marked as complete. Does anyone know a way to achieve this?

I see Planner appears to have this functionality built in, see screenshot:

I see 2 Flow Templates available from Microsoft for Project for the web (New Flow Templates for Project for the web - Microsoft Tech Community) Neither natively appear to have functionality to start a flow when a task is complete.

Thanks in advance,

[Moximox]

Hi

Project for the web stores its data in dataverse.  So just create a flow with a dataverse trigger and choose the appropriate project for web table that you wish to trigger on. 

[MicrosoftAdmin]

Thanks for this Moximox,

The most appropriate trigger i see is Dataverse "When an action is performed". I can drill down and see the task table, but I dont see any way to trigger from update of any records in the table. Any idea?

When a task is marked as complete, the msdyn_progress record is set to 100, this is what i want the trigger to be:

Thank you

[MicrosoftAdmin · Accepted solution]

Hi All,

I have achieved this using the following flow. Note that the 'Filter Rows' selection declares OData filter:

msdyn_progress gt 0

This prevents the flow from running if any modification *other than mark as complete* is made.