Unanswered

Planner, Labels and SharePoint List item

Like (1) Share

Report

Posted on 27 Aug 2023 18:47:35 by MoragB1495

I have a form (“Social Test”) than on submission it creates a SharePoint item in list (“SocialList”). The SharePoint is then used to populate a planner task in a planner (“SocialPlanner”).

The Planner task is moved around in various buckets and has labels assigned by staff.

Once the task has been actioned by staff, I’d like the labels that are on each task to be inputted back to the corresponding SharePoint List item. I created a new flow to try do this (see screen grab)...

I have followed these few instructions / and these to get this flow to update the SP list, but I can only add a new item and I loose all the original details that were submitted to the SP list via the form.

See Screengrab below of the original items (1-4) and then the new items with the labels, but no data is taken into Type or Email.

How do I identify the original SP item (items 1-4 in screengrab above), and update the specific “LabelTag” column in SP, with the labels assigned in Planner?

I have the same question (0)

All responses (3)

Answers (0)

abm abm 32,506 Most Valuable Professional on 30 Aug 2023 at 16:55:08

Like (0)

Report

Re: Planner, Labels and SharePoint List item

Hi @MoragB1495

For the second flow can't you use the below trigger.

You may need to store the Group Id also in SharePoint.

Thanks

Was this reply helpful? Yes No
MoragB1495 30 on 30 Aug 2023 at 13:25:36

Like (0)

Report

Re: Planner, Labels and SharePoint List item

Thanks @abm! I have now updated my SP list after creation of planner with the planner task ID (PlannerID). That works grand.
Im stuck as to what to do next... ive followed these instructions but not sure how to marry up the planner task ID with the PlanID and then update the planner's specific label into the column "PlannerLabels". If that makes ANY sense!
SP list screen grab shown below along with 2nd flow.

Was this reply helpful? Yes No
abm abm 32,506 Most Valuable Professional on 27 Aug 2023 at 21:25:34

Like (1)

Report

Re: Planner, Labels and SharePoint List item

Hi @MoragB1495

You need a unique identifier to update the SharePoint list item. So here in your case you have planner and SharePoint. You mentioned that the SharePoint list is used to populate a planner task in a planner (“SocialPlanner”). As soon as you create the planner task (Believe this is via another Flow) update the Plan Id under SharePoint. This way you have a unique identifier to update the SharePoint List item.

Thanks

Was this reply helpful? Yes No