Skip to main content

Notifications

Community site session details

Community site session details

Session Id : 7GVm4nKBKddKw/7UDkyeiO
Power Automate - Building Flows
Unanswered

Send http request to SharePoint -- Access denied for users with edit rights

Like (0) ShareShare
ReportReport
Posted on 16 Dec 2020 16:56:38 by 169

I have a Flow that creates a subsite on a SP site collection based on user input from a list.  The flow works as expected when I, a SCA, Site Owner and SP Admin, submit the form.  I have an end user with 'Edit' permissions on the site collection who receives an access denied error.   Here are the details of the Send Http Request to SP...

 

flow-sendhttprequest.png

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Is there any way the request can be fulfilled under user credentials that just have edit rights or is there any kind of access token I can generate that passes my credentials?

  • annajhaveri Profile Picture
    8,531 Most Valuable Professional on 18 Dec 2020 at 09:53:53
    Re: Send http request to SharePoint -- Access denied for users with edit rights

    okay, so you were able to return the value from child flow to parent flow and from parent flow to PowerApps.

     

    In case if you need further clarification, below are screenshots you can include dynamic content to return value using respond to PowerApps/Flow

     

    Screenshot 2020-12-18 131003.png

     

    Also as you would be using HTTP to call the child flow, in order to get value returned by child flow, you can use ParseJSON action to parse the value returned to HTTP request action

    Screenshot 2020-12-18 131004.png

     

    Then you can assign the data from ParseJSON action to variable

    annajhaveri_0-1608285178987.png

     

    Once you have the value returned by Child flow in variable of Parent flow, you can again use the Respond to PowerApps action to return the value from parent flow to PowerApps

  • illmatic Profile Picture
    169 on 18 Dec 2020 at 08:25:38
    Re: Send http request to SharePoint -- Access denied for users with edit rights

    In case anyone falls upon this thread with the need to display dynamic content from their child flow into their parent flow, the method I used is as follows.


    • In parent flow, initialized a variable
    • Used 'Get Items' SP action to query list I needed dynamic content from.
    • Used 'Apply for all' action and input 'value' of previous action.
    • Set 'condition' if Title value in ListA matched Title value in ListB, then set variable to URL from ListB.
    • Used 'Respond to PowerApps' action, added 'text' output.  
    • Created 'returnMsg' as variable and set text to 'variable' 
  • illmatic Profile Picture
    169 on 18 Dec 2020 at 06:31:15
    Re: Send http request to SharePoint -- Access denied for users with edit rights

    Thanks, I have added the action to both Flows, but I think I'm a tad hung up on how to get the value of my input from the child flow into the parent flow.   My use case is, in the Child Flow, the output is a string variable which contains dynamic content which is only available in the child Flow.

     

    In the Parent flow, when I do the response, I don't see a way to call the output saved in the Child flow.

  • annajhaveri Profile Picture
    8,531 Most Valuable Professional on 18 Dec 2020 at 06:24:46
    Re: Send http request to SharePoint -- Access denied for users with edit rights

    Hello @illmatic ,

     

    In order to return data from flow, you need to return using Respond to PowerApps/Flow action in both flows, to get the value back in PowerApps. You need to add connection for the Parent flow only to the PowerApps.

     

    Thanks,

    Anna Jhaveri

  • illmatic Profile Picture
    169 on 17 Dec 2020 at 17:21:09
    Re: Send http request to SharePoint -- Access denied for users with edit rights

    Oh, thank you Anna for the guidance.  May I ask if I go this route, would I still be able to do a Respond to PowerApps action in the child flow to capture data and send back to my PowerApps or does this need to happen in the parent flow? And do I need to add connections for both of the flows to the PowerApps?  For me, I would be using the latter method to call with an http action.

  • annajhaveri Profile Picture
    8,531 Most Valuable Professional on 17 Dec 2020 at 16:17:57
    Re: Send http request to SharePoint -- Access denied for users with edit rights

    Yes your understanding is correct. when flow is triggered from PowerApps the flow runs under user context. You can create a new parent flow, which will call your actual flow, so you can call parent flow from PowerApps, and the parent flow calls the actual flow, this should resolve your issue, without making many changes. If your flows are in solution then you can use Call Child Flow action to call one flow from another flow. If you are not using solutions, then you can use http action  to call a flow from another flow.

  • illmatic Profile Picture
    169 on 17 Dec 2020 at 14:51:03
    Re: Send http request to SharePoint -- Access denied for users with edit rights

    Hey there, it's triggered by PowerApps.  My understanding is that PowerApps runs the flow under the context of the user who is accessing the PowerApps.   Since they don't have the same rights I do, this is why they're hitting the Access Denied.   I guess the workaround is to change the trigger to the SP list, and perhaps save the response from the REST call into two variables, one for success and the other for an error?   Then use those variables to update a column in SP list, and bring those values into the PowerApps form that way??   

  • annajhaveri Profile Picture
    8,531 Most Valuable Professional on 17 Dec 2020 at 10:45:51
    Re: Send http request to SharePoint -- Access denied for users with edit rights

    How is the flow triggered, what is the trigger of this flow, is it powerapps or something else?

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

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Congratulations to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Power Automate - Building Flows

#1
stampcoin Profile Picture

stampcoin 55

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 39 Super User 2025 Season 1

#3
VictorIvanidze Profile Picture

VictorIvanidze 26

Overall leaderboard
Loading started