Hello all, I am having trouble trying to compose a unique ID using Checklist Item ID and Task ID. In the Plan The task id is not unique and the checklist item id is not unique but if you combine the two it becomes a unique id. My scenario is,
1. I have moved the planner data to SharePoint via workflow and combined Task and Checklist ID
2. I want to be able to check for changes in the Bucket Name or Checklist is Checked column before adding the record to SPO list
3. I need the UID to filter current Planner data to the Planner data with a condition
4. I am able to get Bucket Name using a filter array because Bucket ID exists in the tasks list but can't figure out how to get Checklist ID. below is my flow, it succeeded but the Input/Output showed "Click to download" then went to a blnk page.
I have rolled out a few projects using the board style list view in place of or addition to Planner. In one scenario, the group had been using a "requests" list for years, but NEVER actually updated the status of an item because they said they couldn't figure out how. With the board view, it's as easy as dragging. On the flipside, it's easy for people to accidentally update the status. With another group, they have an instant flow on their requests list that is used to create planner tasks for as needed (sort of components of the request). It's more of a cross-check mechanism, but allows the team the visibility they wanted to see and track tasks.
thank you very much!!
@rixmcx59 @janybuny9 @ChadVKealey
If anyone is trying to sync a lot of Planner over to SP lists, I highly recommend just using SharePoint’s built-in board view instead to get the kanbans/cards planner-like view without all this extra complexity.
Like this template: https://powerusers.microsoft.com/t5/Power-Automate-Cookbook/Project-Tracker-SharePoint-and-Teams/td-p/1788102
Hey, just try to create an unique ID by using timestamp... it works
first is: "when creating new item"
scnd is: "variable initialize"
thrd is: "update Tasks"
you have to put a variable initialize and tell'm how to show the timestamp,for example:
You have to know how the timestamp looks like and put it to the test value field. In the output field you can show'em how to get showed the unique number...
and then it works pretty fine
BR
Jana
Ok, removed the space, the internal name is correct. I only have 9 records in the SharePoint list but the odata filter should find the 9 that match correct?
I think you're missing a space after "eq" in your odata filter. Also, are you certain that is the internal name of that column and that there is an item in that list with that value in that column?
I am missing something, the input is a single UID and the output body is empty, seems like I need another apply to each, or some way to increment through all the UID's
Yes...it's a common misconception that you need to get all the items from a list to evaluate them. If you have a small list, that can work, but it's inefficient. The better option is to use the odata filter to get just those items that you actually need. In fact, when you use Get items without specifying an odata filter, the flow checker will (should) warn you about that. Also, writing those odata filters can be a challenge, but for text fields it's pretty easy. Just be sure to use the internal column name and put the value you're trying to match in single quotes (ie: 'value-you-want-to-match').
I will try that Monday morning, sounds very promising. Thanks for the direction and I will let you know how it goes. I guess I can remove the first get items since it's not being used.
So, you need to add a "Get items" step pointing at your SP list with an odata filter of <column-with-TaskID-and-ChecklistID> eq <value/variable-in-your-flow-with-TaskID-and-ChecklistID>. If that returns any items, then you know it exists; if it returns nothing, then it doesn't.
Michael E. Gernaey
497
Super User 2025 Season 2
David_MA
436
Super User 2025 Season 2
Riyaz_riz11
244
Super User 2025 Season 2