Skip to main content

Notifications

Power Automate - Using Connectors
Unanswered

Issues getting UPN using Get User Profile v2

(0) ShareShare
ReportReport
Posted on by 4

Hi all, 

 

I have run into an issue that I can't seem to resolve/find resolution to. I've tried a number of different recommendations including ensuring the library has all read except external users. so here we go...

 

Trying to set up a flow using SharePoint, O365User, and Planner in a Teams tab. The goal is:

-When a new doc is added to a library (in this case the Team's channel files tab library) the flow will run

-The assigned reviewer in the SP list is pulled from a custom column that pulls their email

-GetUserProfile(v2) is supposed to use the email to retreive their user info

-Planner takes the output of GetUserProfile(v2) to populate the UPN for the assigned user and creates the review task in planner

 

Just using the assignee's email in planner doesn't work, it wants a UPN. If I go into Delve and grab my ID and plug that in directly--the flow runs fine and assigns to me, so I know that's the value Planner wants. However--every time I try to run the flow I get a 403 or a 404.  I was getting 403s until I added all read except external to the SP list. 403 went away, but now I'm getting a 404 stating the resource couldn't be found.

 

Has anyone else had similar issues/found any way around this? I see plenty of posts where people are using GetUserProfile(v2) so I'm assuming the issue is on my end.


Thanks in advance,

-JP

 

 

  • JP63 Profile Picture
    JP63 4 on at
    Re: Issues getting UPN using Get User Profile v2

    It did not. I've tried it both ways, same result. I've also tried it by using a different piece of information from the SP list to pull the User Profile. It seems like the problem comes when the Flow tries to call the service to GetUserProfile...that's where it always breaks down.  Is it conceivable that there's something (permission or otherwise) preventing that service from being leveraged?

  • v-zhos-msft Profile Picture
    v-zhos-msft on at
    Re: Issues getting UPN using Get User Profile v2

    Hi JP63,

    Does the assigned to column  you created in the same library where you create the new file. As shown below:1.PNG

    I suggest you to change the trigger to when a file is created or modified for a try.

     

    Please feel free post back if you need more help.

    Best regards,

    Zhonys

  • bsafron Profile Picture
    bsafron 2 on at
    Re: Issues getting UPN using Get User Profile v2
  • JP63 Profile Picture
    JP63 4 on at
    Re: Issues getting UPN using Get User Profile v2

    Hi Zhonys,

     

    Thanks for the re:.  As far as the UPN--I understand planner wants that and not an email, as per above--when i do a separate test where I include what I assume is my UPN from Delve instead of using the GetUserProfilev2 it will run without fail. What I want to do is take the email from the custom SP column for assigned to, use it to call the user profile, and then trying to pass that recovered UPN value for Planner. The problem comes in when the GetUserProfilev2 step tries to run.  Here's the flow I'm trying to run and the result. In this case--i created the item and assigned to myself, so I'm not sure why it would come back as 'resource not found'?

     

    SP-Planner Flow Redac.jpg SP-Planner Flow 404.jpg

  • v-zhos-msft Profile Picture
    v-zhos-msft on at
    Re: Issues getting UPN using Get User Profile v2

    Hi JP63,

    According to your description, what confused you is the assignee's email in planner doesn't work, it wants a UPN.

    Could you please share a screenshot of the configuration of your flow? So I could get more details of the issue.

     

    Here are some similar cases, which may help you I think.

    https://powerusers.microsoft.com/t5/General-Flow-Discussion/On-new-SharePoint-items-create-Planner-task-and-assign-to/m-p/35787

    https://powerusers.microsoft.com/t5/General-Flow-Discussion/Create-planner-event-and-assign-user-ID/m-p/35795

     

    To test this issue, I create a flow with the same configuration and don't have the issue that you mentioned.

    1.png2.png

    Please feel free post back if you need more help.

    Best regards,

    Zhonys

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,475

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,767

Leaderboard

Featured topics