Unanswered

Concurreny Control, first to last excel but not in planner tasks

(1) Share

Report

Posted on by RR-30080144-0

Example

Problem I'm trying to solve: Can you please share how I can tell flow/power automate to keep the tasks being sent to planner from an excel worksheet to present in planner from top to bottom. Or said another way the first row in excel will be the first/top task in planner, so on and so forth.

In excel have 3 rows with a header called Task Title

In Excel Task Title

To Do 1

To Do 2

To Do 3

I create a flow in power automate and turn concurrency control ON WITH degree of parallelism 1. The result is

In Planner Task Title

To Do 3

To Do 2

To Do 1

I create a flow in power automate and turn concurrency control OFF. The result is THE SAME

In Planner Task Title

To Do 3

To Do 2

To Do 1

Can you please share how I can tell flow/power automate to keep the tasks being sent to planner in the correct order from top to bottom, 1 then 2 then 3.

Categories:

General topics

I have the same question (0)

All responses (4)

Answers (0)

Suggested answer

Nived_Nambiar 18,129 Super User 2025 Season 2 on at

Like (1)

Report

Concurreny Control, first to last excel but not in planner tasks

Hi,

That is default nature of planner task- whenever you add the tasks to planner list, the first added task will go to bottom and latest added will be at top. Then we need to sort it manually- to make things look like as we need.

So we can do same in power automate, by first creating last To Do List (i.e in your case To Do List 3) and then other ones, then automatically others will appear in same order as you need.

For that i would recommend either to add the To Do List in excel in following order

To Do List 3

To Do List 2

To DO List 1

and then run your flow- it will work.

Else try this approach

I would recommend to add a No column which would be an auto number like below

Now refer the flow design as shown below

1. Use List rows to list rows in table by using No column in descending order

2. Now use apply to each action to create task in planner as shown below

Now see the flow results by running the flow

Also there is no need to enable concurrency here

Hope it helps !

Thanks & Regards,
Nived N
LinkedIn: Nived N's LinkedIn
YouTube: Nived N's YouTube Channel
Blog: Nived Nambiar's Blogs
Found my answer helpful? Please consider marking it as the solution!
Your appreciation keeps me motivated. Thank you!

Was this reply helpful? Yes No
RR-30080144-0 8 on at

Like (1)

Report

Concurreny Control, first to last excel but not in planner tasks

Thank you so much for the reply and we are so close to solving this. However, I tried to implement your sort order row solution and got an error.

Here is what I did and the error result.

Step 1

I added a cheater row in excel with the rows numbered and with a title/header "Order Of Tasks"

Step 2, I went into the LIST OF ROWS PRESENT IN A TABLE, clicked advanced parameters and added the title of the cheater column "Order of Tasks" to the Order by Field.

Step 3 was the error message. It appears the flow did not like something about the cheater row?

Thank you again for your continued help, much appreicated!

Was this reply helpful? Yes No
RR-30080144-0 8 on at

Like (1)

Report

Concurreny Control, first to last excel but not in planner tasks

If anyone else comes across this, please note my error. the word DESC means descending, you need to add the title of your column and then the word either desc. This flow is now working

Was this reply helpful? Yes No
Nived_Nambiar 18,129 Super User 2025 Season 2 on at

Like (1)

Report

Concurreny Control, first to last excel but not in planner tasks

Hi, if the error is resolved, kindly mark the correct answer as verified answer so that it will help others.

Was this reply helpful? Yes No