Unanswered

Create Planner task from sharepoint list, and write back status, completion details back to sharepoint item using flow

(0) Share

Report

Posted on by utagesuraj

Hello,
I have a automate flow which is creating planner task from sharepint list item, but I am stuck with writing back the planner status, completion date, completed user details back to same item in sharepoint list, how can i do that through automate flow?

All responses (6)

Answers (0)

utagesuraj 7 on at

Like (0)

Report
Re: Create Planner task from sharepoint list, and write back status, completion details back to sharepoint item using flow

Hello Kyrie, Thanks for your inputs.
I tried with SP column internal name as PlannerTaskID,
but still flow is failing at O-data filter query, error is 'The query is not valid'.
Please find attached snaps for your reference.
PlannerTaskID eq 'Id' Id = The Id of the task

Filter Query Erro...

SP List Column Na...
v-mingkz-msft Microsoft Employee on at

Like (0)

Report
Re: Create Planner task from sharepoint list, and write back status, completion details back to sharepoint item using flow

@utagesuraj
1. What is your column name about task id in SharePoint list?
Does the column name is 'Planner Task ID'?
If so you can try:
Planner_x0020_Task_x0020_ID eq 'Dynamic Content'
2. If there are just two statuses of tasks, include completed and in progress?
If so, you can manually update the items status to completed in the second flow.
utagesuraj 7 on at

Like (0)

Report

Re: Create Planner task from sharepoint list, and write back status, completion details back to sharepoint item using flow

HI Kyrie, Thanks for your inputs.
I followed steps you suggested, got stuck with below error.
Also I wanted progress status to be written back to sharepoint item, but progress as field is not showing from Planner, how can I bring task status in SP item.
I have attached a snap of error

Flow Error.jpg
v-mingkz-msft Microsoft Employee on at

Like (1)

Report

Re: Create Planner task from sharepoint list, and write back status, completion details back to sharepoint item using flow

Hi @utagesuraj,
My flow is very simple.
In the 1st flow.
Use the SharePoint item the create task and write back the task ID in the item.

In the 2nd flow.
Set the trigger as when a task is completed.

Best Regards,
Kyrie
utagesuraj 7 on at

Like (0)

Report

Re: Create Planner task from sharepoint list, and write back status, completion details back to sharepoint item using flow

Hi Kyrie,
Can you please share me a full flow sample.
As you mentioned, I have created a planner task column in SP list, further I am able to proceed, since I already tried that with many other methods, looks like your flow may work over there
v-mingkz-msft Microsoft Employee on at

Like (0)

Report

Re: Create Planner task from sharepoint list, and write back status, completion details back to sharepoint item using flow

Hi @utagesuraj,
Do you want to write back the task status, completion date to the SharePoint.
You can create one more flow to update this information when a task is completed.
You should create a unique column in SharePoint list such as task id in order to update the same item.

Best Regards,
Kyrie