cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Kastore
Resolver II
Resolver II

Automate Planner Task name - Sequenced number

Hello everyone,

 

i have been searching and in touch with our IT guy but we have not yet found a solution on the internet or in this forum. 

 

We basically transfered to MS Planner recently and have a task list. We always name the task the same way e.g. HR_000.

Due to transfering from system A to Planner we are now stuck with already existing tasks (e.g. HR_120) and would want to have a way to add the "Department + 3 digits starting from a specific number" before the name of the task.

 

I already found some ways to increment a variable but i am stuck with this.. alot ._. 

 

Could someone help me with this?

 

Task:

1) Create new planner task

2) Add sequenced number to the task name starting at a specific number (HR_121 Task Name, HR_122 Task Name)

 

1 ACCEPTED SOLUTION

Accepted Solutions
Kastore
Resolver II
Resolver II

After doing some rethinking we got a solution:

 

1) Create an excel sheet in either sharepoint or onedrive

2) Set a starting number -> click on that cell -> make it a table (table1)

3) go to ANOTHER column and enter =sum(A:A). Make that cell a table as well (table2)

 

Power Automate:

1) Trigger: "When creating a new task in planner"

2) "List cells in Table" - set Table to Table1

3) "Add row into table" -> set Table to Table1 -> set the value in Column to 1 

4) "List cells in Table" -> set Table to Table2 (the sum)

5) "Apply to all" -> pick "value" -> Planner "Update Task" -> Set ID to ID and titel to "FREE_TEXT column1"

 

That should have you set up ready to go

 

 

View solution in original post

1 REPLY 1
Kastore
Resolver II
Resolver II

After doing some rethinking we got a solution:

 

1) Create an excel sheet in either sharepoint or onedrive

2) Set a starting number -> click on that cell -> make it a table (table1)

3) go to ANOTHER column and enter =sum(A:A). Make that cell a table as well (table2)

 

Power Automate:

1) Trigger: "When creating a new task in planner"

2) "List cells in Table" - set Table to Table1

3) "Add row into table" -> set Table to Table1 -> set the value in Column to 1 

4) "List cells in Table" -> set Table to Table2 (the sum)

5) "Apply to all" -> pick "value" -> Planner "Update Task" -> Set ID to ID and titel to "FREE_TEXT column1"

 

That should have you set up ready to go

 

 

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

Power Automate Designer Feedback_carousel.jpg

Help make Flow Design easier

Are you new to designing flows? What is your biggest struggle with Power Automate Designer? Help us make it more user friendly!

Top Solution Authors
Users online (3,545)