web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Comparing a SharePoint...
Power Automate
Answered

Comparing a SharePoint List Task ID column to a Planner Task ID

(0) ShareShare
ReportReport
Posted on by 195

Hi,

I am trying to create a flow that runs monthly that compares a SharePoint List Task ID with a Planner Task ID. Any that do not have a match I would like an email to be sent with the task ID and title of task.

 

The reason for this is that we want to do a check to make sure that any list item that has been run to automatically create a task, has not had the task accidentally deleted from the planner.  Or a task wasn't created directly onto the Planner - as all tasks come directly from new list items via an automated flow. Unfortunately even with staff training this occasionally happens!

 

My flow so far which does not work....!

 

(Please also note that the SharePoint list I mentioned does get updated automatically with the TaskID in a column when the task is created)

 

Screenshot 2022-10-19 112921.png

Categories:
  • Verified answer
    grantjenkins Profile Picture
    11,063 Moderator on at

    You'd need to check both ways. Planner Tasks that aren't in SharePoint, and SharePoint Tasks that aren't in Planner.

     

    Below is how I'd do it where you get an HTML table for each scenario that you can email out. Note that I've just got a Manual trigger, but you would have your Schedule. I'll go through each of the actions.

    grantjenkins_2-1666436069984.png

     

    List tasks and Get items return all the Planner tasks and SharePoint (SPO) tasks respectively.

    grantjenkins_1-1666436009314.png

     

    Select Planner Tasks and Select SPO Tasks just get the properties you want. Note that they both need to have the same Properties including names so we can do our comparison across both later. You can add more properties, but you just need to ensure they are the same across both, including the order.

    grantjenkins_3-1666436150405.png

     

    The Filter array actions are where we filter to show only the ones that are not included.

     

    Filter array Planner tasks not in SPO uses Output from the Select Planner Tasks action for the From, and Output from the Select SPO Tasks in the comparison.

     

    Filter array SPO tasks not in Planner users Output from the Select SPO Tasks action for the From, and Output from the Select Planner Tasks in the comparison.

     

    They both use item() for the does not contain value.

    grantjenkins_4-1666436420342.png

     

    Create HTML actions build up our tables with the relevant data so we can send it in our email.

     

    Create HTML table Planner tasks not in SPO uses Filter array Planner tasks not in SPO.

     

    Create HTML table SPO tasks not in Planner uses Filter array SPO tasks not in Planner.

    grantjenkins_5-1666436581024.png

     

    Compose Table Style is just some CSS that we can use to style our Tables a bit nicer. You can adjust this to your liking. It's not required but does make the tables look nicer than the standard style.

    grantjenkins_6-1666436646775.png

     

    Finally, we can use Send an email to send both the Tables with the Styling applied. I have the Output from the Compose Table Style first, then the appropriate HTML table Outputs.

    grantjenkins_9-1666436882151.png

     

    The email output would look something like that below:

    grantjenkins_10-1666436928578.png

  • roxy1 Profile Picture
    195 on at

     you so much @grantjenkins I really appreciate your time in helping with this, and your screenshots. I am having issues now filtering the tasks by created date but I will do a new post for this query!

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Leaderboard > Power Automate

#1
Mohsin Ali Profile Picture

Mohsin Ali 426

#2
11manish Profile Picture

11manish 345 Super User 2026 Season 2

#3
M Bilal Khan Profile Picture

M Bilal Khan 308

Last 30 days Overall leaderboard