Share
Report
5When 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.
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"
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.
Flow details
The expression used below is:
if(equals(items('Apply_to_each')?['Completed'],'FALSE'),true,false)
Can someone with more experience please help me figure out what I'm doing wrong?
Thank you so much
All responses (
Answers (
