Power Platform Community Forum Thread Details

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

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!

I have used a filter query on the "Get Items" for SharePoint to filter the data column for the list for the list for the past month, and used a filter to filter task by created date for the past month.

I also attempted to use a string variable to get the Task information in "TrackTasks"

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

In my test flow below I am currently receiving emails to the address supplied - the first email contained one task title and ID but was not in the specified date range. It when sent more emails, each separate email had an additional incorrect task added to it!