Skip to main content
Community site session details

Community site session details

Session Id : HWOAddBk7uzjBRYxrpP1Nn
Power Automate - Building Flows
Unanswered

Create a Unique ID in Planner for use in update flow

Like (0) ShareShare
ReportReport
Posted on 4 Aug 2022 18:51:23 by 158

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. 

 

rixmcx59_0-1659638621258.png

  • ChadVKealey Profile Picture
    1,393 on 01 Dec 2022 at 20:46:42
    Re: Create a Unique ID in Planner for use in update flow

    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.

  • janybuny9 Profile Picture
    7 on 25 Nov 2022 at 14:35:20
    Re: Create a Unique ID in Planner for use in update flow

    thank you very much!!

  • takolota1 Profile Picture
    4,898 Moderator on 25 Nov 2022 at 14:30:13
    Re: Create a Unique ID in Planner for use in update flow

    @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

  • janybuny9 Profile Picture
    7 on 25 Nov 2022 at 12:57:25
    Re: Create a Unique ID in Planner for use in update flow

    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"

    janybuny9_0-1669374585112.png

    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...

    janybuny9_2-1669380696657.jpeg

    and then it works pretty fine

    janybuny9_3-1669380910380.png

     

    BR

    Jana



  • rixmcx59 Profile Picture
    158 on 08 Aug 2022 at 20:41:01
    Re: Create a Unique ID in Planner for use in update flow

    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?

  • ChadVKealey Profile Picture
    1,393 on 08 Aug 2022 at 19:23:18
    Re: Create a Unique ID in Planner for use in update flow

    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?

  • rixmcx59 Profile Picture
    158 on 08 Aug 2022 at 18:55:22
    Re: Create a Unique ID in Planner for use in update flow

    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

     

    rixmcx59_0-1659984712327.png

     

  • ChadVKealey Profile Picture
    1,393 on 05 Aug 2022 at 20:06:09
    Re: Create a Unique ID in Planner for use in update flow

    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').

  • rixmcx59 Profile Picture
    158 on 05 Aug 2022 at 19:43:45
    Re: Create a Unique ID in Planner for use in update flow

    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.

  • ChadVKealey Profile Picture
    1,393 on 05 Aug 2022 at 18:04:14
    Re: Create a Unique ID in Planner for use in update flow

    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.

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

Announcing our 2025 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for…

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 497 Super User 2025 Season 2

#2
David_MA Profile Picture

David_MA 436 Super User 2025 Season 2

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 244 Super User 2025 Season 2

Loading complete