I currently have a PowerApps form that is used to populate a SharePoint list. The Sharepoint List then populates a Planner Plan. This all occurs through Flow. For instance, I currently have a Flow that does the following:
PowerApps fills out Sharepoint -->
When a new item is created in Sharepoint -->
Create a task -->
Update a task -->
Update task details.
This flow works great. If someone were to update the task/issue in the PowerApps form, it automatically updates the Sharepoint list item. However, what I need is for the Planner to then get the same update to the specific task. I tried making a Flow that did the following:
When an item is created or modified in SharePoint -->
Get my profile (V2) -->
List tasks -->
Apply to each -->
Update a task -->
Update tasks details
What happens is the following: I update one task in my PowerApps form and all of a sudden EVERY SINGLE PLANNER TASK is updated to the same exact thing. I only want it to update the one task that I am changing. Does anyone know how to do this? Thanks in advance.
HI @kelseyh231 ,
Do you want to update the specific task in Planner when a corresponding item is modified in SharePoint?
I have made the following flow for your scenario.
Images for your reference.
Hi @v-yamao-msft, your solution was very helpful. I performed the test to see if it works and my only issue now is that the flow does not stop running. It has been running for 8 minutes now, the change was updated, there should be no other changes, but it is still running. Is there a way to stop it? Thank you!
Hi @kelseyh231 ,
Please update your flow likes below.
I made another test and I found that we should initialize an Array variable but not a string variable.
So in the action Initialize variable, set the Type to Array.
In the Apply to each action, replace the Append to string variable with action Append to array variable.
It should work properly then.
Please take a try with it.
Three Super User rank tiers have been launched!
Features releasing from October 2020 through March 2021
We are excited to announce the launch of Power Virtual Agents Community. Check it out now!
We've updated and improved the layout and uploading format of the Power Automate Cookbook!
Fill out a quick form to claim your user group badge now!