Obtaining the Assigned Username from Planner and Adding to Excel

(0) Share

Report

Posted on by Ben_Sully

To explain the flow, wherever this user is assigned, it lists the teams it is part of, lists the planners from those teams and looks for tasks with a coloured label assigned. The difficulty was pulling through who the task was assigned to. To do this I initiated a string variable at the start called "Assigned To" which is blank. I then put in the set variable the expression "item()?['_assignments'][0]['userid']". The flow works as intended but always states it has failed and I believe the code is the failure point. Can anyone help with this problem?

All responses (1)

Answers (0)

ManishSolanki 15,085 Super User 2025 Season 1 on at

Like (0)

Report

Re: Obtaining the Assigned Username from Planner and Adding to Excel

Hi @Ben_Sully

Pleas replace 'Get user profile (V2)' action with 'Get User' action of Azure AD connector to get the display name or other properties of user based on its Id:

If this helps, please remember to give a 👍 and accept my solution as it will help others in the future.

Thanks