web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id : SgnBvgagD9+YHq0bFh1uJ8
Power Automate - Building Flows
Answered

Creating checklist in Update Task Details

Like (1) ShareShare
ReportReport
Posted on 6 Aug 2022 15:29:13 by 6

When I add action "update task details" to create checklist items (from Excel) in my planner (via Power Automate) for some reason, the newly created checklist items are being put into ALL my tasks. I don't want the checklist to show up in all my tasks. I have 5 tasks and want to update 2 tasks with checklists (checklist is different for each task/never the same). 

 

Here's is the Excel (table 1/tab 1) - used for "create a planner task" - these are my 5 tasks I want to drop into teams planner via power automate. I am able to create a flow and successfully added the below into my to do bucket in planners. so not issue here.

BeatriceL123_0-1659799748852.png

 

The issue is when I try to add the checklist using action "Update task details"

My Excel tab 2 (table 2) I need checklist 1-3 added to a task "call hotel" then I need 4-6 added to another task "create NF event" 

BeatriceL123_1-1659799748862.png

 

The flow I am running does not have an error message upon test. However, the output/final result is NOT what i want.

 

Issue: checklist 1-6 is appearing on task 2-5 but not Task 1 (see table 1 rows 3-6). This is obviously not what I want. What I want is checklist 1-3 added to a task "call hotel" and checklist 4-6 added to task "create NF event" 

 

My output is that checklist 1-3 is going to the right task (yay). But checklist 1-6 is showing up on 4 out of 5 task. So the final product is 10% right and 90% wrong. 

Planner: circle is right (I added three checklist items to "Call Hotel" but all the rest of my tasks gained 6 checklist items and THAT IS WRONG. There must be some type of loop causing it or I am not directing it properly - either way user error. I'm new to Power Automate.

BeatriceL123_2-1659799748863.png

 

Flow details

The expression used below is: 

if(equals(items('Apply_to_each')?['Completed'],'FALSE'),true,false)

BeatriceL123_3-1659799748864.png

 

 

BeatriceL123_4-1659799748865.png

 

Can someone with more experience please help me figure out what I'm doing wrong? 

Thank you so much

 

 

 

 

I have the same question (0)
  • Verified answer
    v-bofeng-msft Profile Picture
    on 09 Aug 2022 at 06:25:28
    Re: Creating checklist in Update Task Details

    Hi @BeatriceL123 ,

     

    Seems you have already got an answer, please check this link:

     

    Creating checklist in Update Task Details - Power Platform Community (microsoft.com)

     

    Best Regards,

    Bof

  • DineshK_ Profile Picture
    203 on 01 Apr 2025 at 11:37:16
    Creating checklist in Update Task Details
    @BeatriceL123 @v-bofeng-msft
    Hi Guys , i have the same issue now and can't able to see your solution here.
    Please help to share the solution again please ?
     
    2 issues :
    1. All the checklists are added into the tasks
    2. All the added checklists are in COMPLETED state even i have a TRUE & FALSE both values in Completed column.
         The expression used below is:
            if(equals(items('Apply_to_each')?['Completed'],'FALSE'),false,true)

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Chiara Carbone – Community Spotlight

We are honored to recognize Chiara Carbone as our Community Spotlight for November…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 788 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 452 Moderator

#3
developerAJ Profile Picture

developerAJ 302

Last 30 days Overall leaderboard
Loading complete