Answered

Update SharePoint item when Planner task marked complete

(1) Share

Report

Posted on by cbs545

Hello,

I'm trying to create a flow to mark the status of a SharePoint item as "Complete" when the item is completed in Planner. I've tried using this template and it doesn't work.

Please see attached photos showing how my flow is currently set up. Screenshot (1).png Screenshot (2).png Screenshot (3).png

Any ideas?

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (1)

abm abm 32,865 Most Valuable Professional on at

Like (0)

Report

Hi @cbs545

The issue is here

Above you are checking under the IF condition with value mapping from Sharepoint. That means value contains everything from your Get Items steps. Are you storing the Planner Id in SharePoint? That's the column value you need to compare or you could use the Filter Query in your Get Items something like this.

Assume your SharePoint got a custom column called PlannerId then use the query below

PlannerId eq 'here map the planner id'

Hope it make sense.

Thanks

Was this reply helpful? Yes No
cbs545 12 on at

Like (1)

Report

Thanks for the reply! Sorry, but that doesn't make much sense. I'm a little new to this so if you could simplify the language and give me more specific instructions on what needs to change, that would be really helpful. Thank you!

Was this reply helpful? Yes No
Verified answer

abm abm 32,865 Most Valuable Professional on at

Like (0)

Report

Hi @cbs545

Whenever a new planner task is created you need to store that in your SharePoint List. You may need another flow to do this. Once you stored the Id you can match with the correct record and update the list.

Thanks

Was this reply helpful? Yes No
cbs545 12 on at

Like (1)

Report

Thanks @abm! That fixed it. Your help and expertise was most appreciated! Subscribing to your YouTube channel.

Was this reply helpful? Yes No
abm abm 32,865 Most Valuable Professional on at

Like (0)

Report

Glad that all working as expected. Thanks for the subscription.

Was this reply helpful? Yes No