Answered

Change cell value in excel after creating Planner entry

(0) Share

Report

Posted on by mzolth

I've created a flow that creates a Planner task using "for a selected row". I click on a cell in a row or highlight cells from multiple rows, click on flow and it creates the task(s) in Planner.

Upon creating the planner tasks, I'd like to change a cell value within the selected rows to change so that it indicates that the row has already been sent to Planner.

Any help with this would be much appreciated.

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

mzolth 9 on at

Like (0)

Report

I figured it out. I utilized a unique key value from the planner (that had come from the excel file when the planner entry was created) to use to create an entry into the excel file.

Was this reply helpful? Yes No
takolota1 4,974 Moderator on at

Like (0)

Report

@mzolth

Nice job sticking with it to find an answer to your own problem.

It may be a lot if you are working with a simple use-case, but if you are working on or trying to prepare something more complicated, you may find some helpful things in this template for turning a SharePoint list into a project tracker with some Kanban or Planner-like user interface:

https://powerusers.microsoft.com/t5/Power-Automate-Cookbook/Project-Tracker-SharePoint-and-Teams/td-p/1788102

Was this reply helpful? Yes No