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 Automate - Building Flows
Under review by Community Managers

Under review

Thank you for your post! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Create Flow to use an Excel sheet to create Tasks and checklists in Planner for the teams.

Posted on by
I want to leverage Power Automate to link and update the data in my Excel spreadsheet to the task in the planner.
 
At present, my flow has been created and can automatically update my tasks when the file is updated. However, the main problem I am currently facing is the checklist in the task. Every time I update my spreadsheet file, if the content in my list is increased, my checklist will also increase. But the problem is that when the checklist items is shorten, duplicate items will appear. I don't know how to solve this problem. Please provide your support, thank you.
 
Excel Sheet:
 
Flow:
 

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!

Leaderboard > Power Automate

#1
David_MA Profile Picture

David_MA 124 Super User 2026 Season 1

#2
Ellis Karim Profile Picture

Ellis Karim 52 Super User 2026 Season 1

#3
Haque Profile Picture

Haque 50

Last 30 days Overall leaderboard

Featured topics