Issues getting UPN using Get User Profile v2

[JP63]

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

[v-zhos-msft]

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-t...

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

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

Please feel free post back if you need more help.

Best regards,

Zhonys

[JP63]

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'?

 

[v-zhos-msft]

Hi JP63,

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

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

[JP63]

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?