Skip to main content

Notifications

Power Automate - General Discussion
Unanswered

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

(1) ShareShare
ReportReport
Posted on by 8

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:
  • Nived_Nambiar Profile Picture
    Nived_Nambiar 17,010 on at
    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.
     
     
  • RR-30080144-0 Profile Picture
    RR-30080144-0 8 on at
    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
  • RR-30080144-0 Profile Picture
    RR-30080144-0 8 on at
    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!
     
     
     
  • Suggested answer
    Nived_Nambiar Profile Picture
    Nived_Nambiar 17,010 on at
    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!

     

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

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

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

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,304

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,703

Leaderboard