cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
stiwari
Level: Powered On

Unable to fetch user id after passing obtained access token of my sharepoint app in Microsoft flow

Went through these tutorials to assign item-level permissions using Flows:

https://noellawlor.wordpress.com/2018/01/18/setting-sharepoint-item-list-permissions-with-flow/

and a follw-up to 

https://powerusers.microsoft.com/t5/Using-Flows/Item-Level-Permissions-not-setting-in-sharepoint-onl...

 

I am unauthorized to fetch the user ID in flow. 

 

Here's what I did:

usernameclaim.PNG

 

get_user_id.PNG

 

After running the workflow:

unauthorized.PNG

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: Unable to fetch user id after passing obtained access token of my sharepoint app in Microsoft flow

Hi @stiwari have you considered using the builtin "Sent HTTP Request to SharePoint" action? That way you won't have to worry about the oauth elements, you just need to get your REST call right. Happy to provide guidance on that action if you need any help.





Did my reply help? Please give it a thumbs up.
Did I answer your question? Please mark my post as a solution!


Proud to be a Flownaut!





Community Leader: Black Country PowerApps & Flow User Group

View solution in original post

5 REPLIES 5
Super User
Super User

Re: Unable to fetch user id after passing obtained access token of my sharepoint app in Microsoft flow

Have you tried running the call within Postman to see if you get the same result?





Did my reply help? Please give it a thumbs up.
Did I answer your question? Please mark my post as a solution!


Proud to be a Flownaut!





Community Leader: Black Country PowerApps & Flow User Group

stiwari
Level: Powered On

Re: Unable to fetch user id after passing obtained access token of my sharepoint app in Microsoft flow

Postman says

{
"odata.error": {
"code": "-1, Microsoft.SharePoint.Client.InvalidClientQueryException",
"message": {
"lang": "en-US",
"value": "The query string \"loginName\" is missing or invalid."
}
}
}

 

What I read from Microsoft Flow docs, to get user id by REST API in flow, you have to pass your login name in this URL format:

https://<sharepoint-sitename>/_api/web/siteusers(@v)?@v=’<login-name>'

and various examples have used 'CreatedBy Claims' to get the <login-name>

stiwari
Level: Powered On

Re: Unable to fetch user id after passing obtained access token of my sharepoint app in Microsoft flow

Here is one more good example following my question:

get_user_id.PNG

 

I replaced '' with %27 and am passing the encodeURIcomponent(variables['email']) value as a request parameter and still says 'Unauthorized'. I did the same thing in Postman and it fetched me the result. I don't what's going wrong. No way to debug and no way to see what's going wrong. Sharepoint Online is such a frustrating creation of Microsoft. I have been stuck into Item-Level permissions for 2 weeks and still 25% success. 

 

Also to let you know that I tried encoding UserClaims and passed the same way as I have asked in the original question but it's still unautorized.

Super User
Super User

Re: Unable to fetch user id after passing obtained access token of my sharepoint app in Microsoft flow

Hi @stiwari have you considered using the builtin "Sent HTTP Request to SharePoint" action? That way you won't have to worry about the oauth elements, you just need to get your REST call right. Happy to provide guidance on that action if you need any help.





Did my reply help? Please give it a thumbs up.
Did I answer your question? Please mark my post as a solution!


Proud to be a Flownaut!





Community Leader: Black Country PowerApps & Flow User Group

View solution in original post

stiwari
Level: Powered On

Re: Unable to fetch user id after passing obtained access token of my sharepoint app in Microsoft flow

I didn't feel the need to use HTTP connector and try the Oauth steps. "Send HTTP Request to Sharepoint" does all that without prompting you for access tokens.

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

firstImage

Incoming: New and improved badges!

We've given our badges an overhaul and also added some brand new ones!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

Top Kudoed Authors (Last 30 Days)
Users online (4,790)