cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
jkeckard007
Helper III
Helper III

Flow to update Sharepoint list on completion of Planner Task

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.

Flow1.PNG

1 ACCEPTED SOLUTION

Accepted Solutions

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

View solution in original post

8 REPLIES 8
v-bacao-msft
Community Support
Community Support

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.

8.PNG

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.

9.PNG

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

Community Support Team _ Barry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

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.

FlowA.JPG

 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

FlowB.JPG

Respectfully

Jennifer

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

Community Support Team _ Barry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

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.

Filter.JPG

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.

44.PNG

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

45.PNG

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.

46.PNG

Please take a try.

 

Best Regards,

Barry

Community Support Team _ Barry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

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.

Querry.JPGquery2.JPG

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
Not applicable

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 

Helpful resources

Announcements
MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

Power automate tips 768x460 v2.png

Restore a Deleted Flow

Did you know that you could restore a deleted flow? Check out this helpful article.

Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

May UG Leader Call Carousel 768x460.png

What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.

Users online (1,639)