Showing results for 
Search instead for 
Did you mean: 
Regular Visitor

Flow from Planner to Excel - not adding or updating unassigned tasks



I am very new to power automate and I have built a flow that measures the work of an entire department.

The problem that I am having is once I input the "Get User Profile v2" to bring in the assigned display name the flow stops bringing in or updating all of the unassigned tasks. 



If "Get User Profile V2" is not flowing into the spreadsheet all tasks update

If "Get User Profile V2" is flowing into the spreadsheet only allocated tasks get added or updated.


I have tried composing the data from 'get user profile v2" with an IF(Equals(-display name-, null), null, -display name-) formula (similar to what I have to formate the start, due, and completed date) and having the spreadsheet pull the output of that compose, however, it doesn't appear to do anything.


Any help is appreciated. Images of the flow are in the link.


Helpful resources

MPA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

V3_PVA CAmpaign Carousel.png

Community Challenge - Giveaways!

Participate in the Power Virtual Agents Community Challenge

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

R2 (Green) 768 x 460px.png

Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.

Top Solution Authors
Users online (1,351)