Unanswered

Project Dependency Tasks Flow to notify Successor Task Assigned To their task is ready to work on

(0) Share

Report

Posted on by Dribblej

Hello,

Goal: Project for the Web: When a project task is completed that is a predecessor task, get successor task details and notify the assigned to user in teams.

Side note: I have successfully created flows for new tasks, completed tasks and modified tasks to alert in teams through the flow bot to the user. Also, when I create a view on the Project Dependencies tab I can see a related look into the project task entity that allows me to see its individual information depending on if it is a predecessor task or successor task.

Entities involved: Project Tasks, Project Task Dependency & Project

msdyn_projecttask(msdyn_projecttaskid) = msdyn_projecttaskdependency(msdyn_predecessortask or msdyn_successortask)

Summary: The project task id is the same id as the predecessor task id if it is a predecessor. The project task id is the id as the successor task if it is a successor task.

What I tried:

-When a Project task is completed CDS trigger: filter expression = msdyn_progress eq 1

-Get a record: Project with Item ID = Project Id

-List records: Project Dependency, here I don't know what filter to set to pull the record that is... projecttaskid = predecessortaskid

& the successor task id

-Take that Predecessor task and identify its successor task

- Get successor task information

-Then Get Resource assignment

- Then get bookable resource

-Then get system user

-post adaptive card.

Categories:

Building flows

I have the same question (0)

All responses (6)

Answers (1)

Dribblej 16 on at

Like (0)

Report

Here is another flow idea I Tried.

Power Automate will not allow me to save the "List Tasks Dependencies" step without deleting the filter query. I need it to pull the record where the msdyn_projecttaskid = _msdyn_predecessortask_value because this can point to the correct Successor task I want to make the alert on.

Any ideas. I have racked my brain a lot on this one.

"Flow save failed with code 'InvalidTemplate' and message 'The template validation failed: 'The inputs of template action 'List_Task_Dependencies' at line '1 and column '1329' is invalid. Action 'Apply_to_each' must be a parent 'foreach' scope of action 'List_Task_Dependencies' to be referenced by 'repeatItems' or 'items' functions.'.'."

Was this reply helpful? Yes No
ProFe on at

Like (0)

Report

Hi,

I'm trying to implement more or less the same flow, can I ask you if you managed to make it work ?

Thansk !

Was this reply helpful? Yes No
Verified answer

Dribblej 16 on at

Like (0)

Report

Was this reply helpful? Yes No
ghutchins 2 on at

Like (0)

Report

@Dribblej
Are you able to provide some guidance on how you structure the filter query in the list task dependency?

This post has been extremely useful, however we are trying to resolve this final aspect, if you could advise?

Was this reply helpful? Yes No
HotWheels 2 on at

Like (0)

Report

Hello, is the provided workaround still the best possible approach here or is there an easier alternative? Would like to see Microsoft implement this as a feature in their Project solution.

Was this reply helpful? Yes No
FlailingSnorlax 12 on at

Like (0)

Report

For anyone trying to decypher this flow you need to List the resource assignments here with the 'List rows (legacy)' action instead of 'Get a row'

Was this reply helpful? Yes No