Answered

Connecting flows for Microsoft Planner to sharepoint list

Like (1) Share

Report

Posted on 7 Nov 2019 12:34:56 by Community Power Pla...

Hi,

We use Planner to manage tasks and PowerBI for reporting. The problem I am having is PowerBI cannot connect to Planner, my solution was going to be to use flows to duplicate the information from planner to a sharepoint list so I can connect to it in PowerBI. However the triggers for Flows with Planner seem to be really limited?

I want to be able to update my sharepoint list whenever a task is updated. But the only options are when a planner task is created, completed, or assigned to me? Am I missing?

help!

All responses (3)

Answers (1)

shawn_fielding on 20 Nov 2019 at 14:01:33

Like (0)

Report

Re: Connecting flows for Microsoft Planner to sharepoint list

I want to do the EXACT same thing. If you come up with any flows that help you with this process please share them or just contact me and I will do the same.
v-bacao-msft on 14 Nov 2019 at 05:39:01

Like (1)

Report

Re: Connecting flows for Microsoft Planner to sharepoint list

Hi @Anonymous ,

You can find out from the Online doc that the currently supported trigger in the Planner connector does not contain When a task is updated:

https://docs.microsoft.com/en-us/connectors/planner/#triggers

As @JatinSanghvi mentioned, from the Planner task API point of view, the properties of the Task/Task details do not contain properties like Modified time/Modified by/version, so I am afraid that such a trigger will not be supported.

Best Regards,
Verified answer

JatinSanghvi on 07 Nov 2019 at 20:00:30

Like (0)

Report

Re: Connecting flows for Microsoft Planner to sharepoint list

@Anonymous, I am not aware of a workaround for the missing trigger. Unfortunately, based on the information I have, the Planner APIs do not make it possible to support a trigger that can track update events on Planner tasks, hence the engineering team does not have a plan to support such trigger in future.