Flow to update Sharepoint list on completion of Planner Task

[jkeckard007]

I have a MS Flow that runs when a Planner Task updates.  It is suppose to get the items from a Sharepoint list with the same Title as the Title from the Planner task.  However when it does the filter it does not return any values yet I know the item exist in the sharepoint list.  Can some one help. See screen shot.

[v-bacao-msft]

Hi @jkeckard007,

Could you share all the screenshots of your Flow configuration?

I am not sure what your trigger configuration is. Planner-related triggers are only created, assigned, completed, and there seems to be no updated.

In addition, you could configure the "value Title" directly in Filter Query without setting variables.

I did a test on my side, like expected, got the same Title item. In addition, I used your method and was able to get the same Title item.

You could resolve the problem from these aspects:

1.After Flow runs, look at the conditions in Get items-Filter Query, and then see if the list actually contains the same title item.

2 .Or try to configure the "value Title" directly in Filter Query.

Please take a try and feel free let me if issue still exists.

Best Regards,

Barry

[jkeckard007]

I actually have two flows ones that is on when the item is created that creates the task from a sharepoint list and makes a planner task.

 So I know the item exists in the Sharepoint List.  Then another flow that updates the sharepoint list when the item is complete in Planner this is the one I am having the issue with.

Flow B

Respectfully

Jennifer

[v-bacao-msft]

Hi @jkeckard007,

Are you still experiencing the same issue when trying to configure "value Title" directly in Filter Query?

Have you exported the specific configuration of Filter Query?

I did a lot of testing on my side and still can't reproduce the problem you mentioned.

Please let me know if you need further assistance.

Best Regards,

Barry

[jkeckard007]

Yes I am still experience this I am not sure what you mean by export but I assume you want to see the output of the filter.  Here it is.  A empty result.

I have tried it by setting Title as a variable as well and it is the same result.  I even tried based on a different planner same result.

[v-bacao-msft]

Hi @jkeckard007,

What I mean is to see what the Get item-Filter Query specifically outputs after Flow is run.

Or what is the value of "value Title" here, and then go to the SharePoint list to see if there is an item with the same Title.

Or you could use Filter Array and use the output of Get items. Get items does not need to be configured with Filter Query.

Use Get item and configure the ID of the item obtained from the Filter Array.

Configure Update item, use the ID output by Get Item, the field to be updated is configured using the output of the trigger, and the field that does not need to be updated is configured using the output of Get item.

Note: The Dynamic content configured in "Apply to each" is only selected from the options output from Get item or trigger.

Please take a try.

Best Regards,

Barry

[jkeckard007]

No matter which way I try the array is coming back empty when I filter on the Title  Which is the issue.  I know there is an item with the same title because I create a Item in the list that then creates a Planner Task with the same title.  I even tried using the Planner ID and the array still returns empty. I have other qury that work just fine I am not sure what I am doing wrong with this one.

[jkeckard007 · Accepted solution]

I finally got this working using a Filter the Array action. I filtered the SharePoint list down to items not Complete then filtered the array by the title.

Thanks

Jennifer

[Anonymous]

Are there any way to reverse this? Like for example when someone would accidentally press the completion button on planner and it updated the status of the item and move it a new list. So when they would undo the completion it would change status and go back to the list it originally were in?

@v-bacao-msft