Hello, I'm trying to build a flow that will rename existing Checklist items within a Planner task with new titles, specified in an Excel Table. My plan has roughly 50 tasks in total. Some don't have checklists at all, but most do. The ones that do have either of 2 quantities of checklists, for example some will have 15 checklist items, and some will have 8. In Excel, I have a table with 4 columns. (Column 1 contains the current names of the 15 items, Column 2 the new names of the 15 items, Column 3 the current names of the 8 items, Column 4 the new names of the 8 items) What I'm trying, thus far unsuccessfully, to do is create a flow that will say for each Checklist item in each Planner task that matches the names found in either Column 1 or 3, renames it with the new names from either Column 2 or 4. Does that make sense? I feel like it does. Power Automate apparently can't figure out what I'm trying to do because no matter how I try to set it up, it just spins and spins eternally until I cancel the flow run. I THINK what it's trying to do is rename each Checklist item in each Planner task with each item listed in the specified table column, so instead of 1 for 1, it's trying to do 15 for 1 (15x) and then 8 for 1 (8x), and there's a limit of 20 Checklists per task, so it doesn't know what to do. I just want 1 for 1. If the name matches this name, replace it with this name. I cannot figure out how to write it accordingly. Please help!!
2
Share
Report
All responses (
Answers (
