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:
538
