cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
cpmb82
Level: Powered On

Planner to SharePoint flow when task complete

Hi,

 

I am trying to set up a flow that updates a specific SharePoint item (the planner task title matches the primary field in the SharePoint list) but can't get it to update, any suggestions:

image.png

 

image.png

 

At this point I only want to update the Notes field so have left everything else blank!

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Planner to SharePoint flow when task complete

Hi @cpmb82,

 

Could you please share more details about the IBM PgMP Ref field in your sharepoint list?

 

I have made a test on my side and have have created a IBM PgMP Ref field in the sharepoint list with a single line of text type, you could refer to screenshot below to create the flow:

Capture.PNG

 

 

 

 

Best regards,

Alice

 

3 REPLIES 3
Super User
Super User

Re: Planner to SharePoint flow when task complete

@cpmb82:

 

Here is an example that I believe addresses your issue.  I chose to use an OData filter when retrieving the list items rather than filtering an array.

 

Please note that there are single quotes around the value from Planner in the OData filter.

 

Also, I am assuming that there is only one entry in the SharePoint list with a title that matches the Planner title.  So, there should only be one item returned for Get Items and the loop with only run once.

 

In addition, you need to provide values for all required columns even if you don't want to update them.  If you want the values to be unchanged, just set it to the value for that column in Dynamic Properties.

 

The following Flow ran successfully:

Planner.jpg

 

If this addresses your issue, please mark your Post as Solved.

 

Scott

 

 

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Scott
Community Support Team
Community Support Team

Re: Planner to SharePoint flow when task complete

Hi @cpmb82,

 

Could you please share more details about the IBM PgMP Ref field in your sharepoint list?

 

I have made a test on my side and have have created a IBM PgMP Ref field in the sharepoint list with a single line of text type, you could refer to screenshot below to create the flow:

Capture.PNG

 

 

 

 

Best regards,

Alice

 

cpmb82
Level: Powered On

Re: Planner to SharePoint flow when task complete

Thanks Alice, that worked great!!

 

Is it possible to edit the format of the completedDateTime to just show dd-MM-yyyy instead of 2018-09-20T08:14:50.2606137Z??

Helpful resources

Announcements
firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

Power Platform 2019 Release Wave 2 Plan

Power Platform 2019 Release Wave 2 Plan

Features releasing from October 2019 through March 2020

thirdimage

Flow Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

thirdImage

New Flow Community Board!

Check out the new Microsoft Flow Community Blog Topic Suggestion board!

fourthImage

Australia Summit

Travel to Melbourne and network with thousands of peers!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Flow Community Video Gallery!

Top Kudoed Authors
Users Online
Currently online: 186 members 3,668 guests
Please welcome our newest community members: