You’re offline. This is a read only version of the page.
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)
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
Share
Report
All responses (
Answers (
552
