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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / How to use terms from ...
Power Automate
Answered

How to use terms from a Sharepoint list and checklist items from a planner task

(0) ShareShare
ReportReport
Posted on by 10

HR creates list item in SharePoint, this triggers a flow, which makes a copy of a template task with a checklist.
There are 5 checklist items.
The checklist Items should be shown only if e.g.:
Laptop Yes ==> Checklist Item => Prepare New Laptop
Mobile Phone Yes==> Checklist Item => Prepare New Mobile Phone
...

 

 

Step1 Start Flow
==> When an item is created
Step 2 Retrieve item
==> Get Item
Step 3 Retrieve buckets from scheduler plan
==> List tasks
Step 4 Filter the template bucket
==> Filter Array
==> From => value
==> value Title is equal to {Template Task Name}
Step 5 Create a task
==> Create a task
Step 6 Update the task
==> Update task details

Here I'm stuck, how do I get the correct Checklist items into the new task using the condition?

 

 

 

LarsHouben_0-1716450351933.png

Thanks in advices 

Categories:
I have the same question (0)
  • v-mengmli-msft Profile Picture
    Microsoft Employee on at

    Hi @LarsHouben ,

     

    Do you mean that update the task when the task's name is same as created item's Title? Otherwise, the flow will create a new task with Title.

    If so, please try this, you can add a condition before creating or updating the task.

    length(body('Filter_array'))
    first(body('Filter_array'))?['id']

    vmengmlimsft_0-1716452104802.png

     

     

     

     

    Best regards,

    Rimmon

  • LarsHouben Profile Picture
    10 on at

    Hi @v-mengmli-msft 

    Thanks for the quick response!

    The flow works fine, only:

    I have 4 Yes/No fields in Sharepoint and I have 5 checklist items in the planner task.
    1 Checkitem should always be in the newly created task,
    Checklist item: create the new employee in Entra ID
    The other 4 checklist items must meet a condition.
    1st condition:
    ==> Laptop Yes/No ==> If yes, the checklist item ==> Prepare Laptop ==> must be created in the new task
    ==> Cell phone Yes:No If yes, the checklist item ==> Prepare cell phone ==> must be created in the new task.
    And then 2 more conditions

  • Verified answer
    v-mengmli-msft Profile Picture
    Microsoft Employee on at

    Hi @LarsHouben ,

     

    You can add multiple conditions to check each Yes/No column. If yes, update task and add check list item.

    vmengmlimsft_0-1716456777180.png

     

     

     

    Best regards,

    Rimmon

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the March Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Vish WR Profile Picture

Vish WR 873

#2
Valantis Profile Picture

Valantis 820

#3
Haque Profile Picture

Haque 505

Last 30 days Overall leaderboard