Skip to main content

Notifications

Power Automate - Using Connectors
Answered

The request is forbidden by Graph API. Error code is 'accessDenied'. Error message is 'Access denied'.

(0) ShareShare
ReportReport
Posted on by 21

Hello,

 

I have created a simple approval workflow which is triggered by a Canvas App:

tj8000_0-1672915394910.png

 

In the condition I am writing the data into an Excel Business Online. The connector to the excel is with user "A" and it works perfectly fine when testing or when user "A" is triggering the approval workflow via the Canvas app. 

 

I am having the issue that when user "B" is triggering the approval flow, I am getting the error message "The request is forbidden by Graph API. Error code is 'accessDenied'. Error message is 'Access denied'." 

When executing the request with the same data and with user "A" it works fine.

 

User "B" does not have access to the Excel storing the data due to GDPR compliance.

 

I do understand, that Excel might not be the best way to store it, but given my current situation it is the best solution for me (plus I am not having a lot of data).

 

I assume the issue is, that the connection to Excel Online is not done with the connection specified in the flow and is done with the user starting the flow via the Canvas app.

 

Given this post https://powerusers.microsoft.com/t5/Using-Connectors/Flow-and-Excel-Error-messeage-Forbidden/m-p/289095#M5440 everyone needs access to the Excel.

 

Is my understanding correct? If yes, is there any way to store the data with a "dedicated user"?

 

 

 

  • jtan Profile Picture
    jtan 10 on at
    Re: The request is forbidden by Graph API. Error code is 'accessDenied'. Error message is 'Access denied'.

    The problem is you need Premium Account now to use Excel Online (Onedrive), is this change permanent?

     

    You can open the flow on web browser, then go to "Connections" and click Edit, it will ask you to sign in on Premium account.

  • Gimol Profile Picture
    Gimol 4 on at
    Re: The request is forbidden by Graph API. Error code is 'accessDenied'. Error message is 'Access denied'.

    I have created file in the flow and then accessing same file, still getting these errors.

     

  • tj8000 Profile Picture
    tj8000 21 on at
    Re: The request is forbidden by Graph API. Error code is 'accessDenied'. Error message is 'Access denied'.

    Thanks @barret. Then I need to see how to handle it. A potential workaround I am having in my head is to save the data in a file on OneDrive and then pick this file up to store it in my Excel. A perfect solution would of course be saving it to an actual database, or via an API, but unfortunately that's not possible right now 😞

  • Verified answer
    bblake8480 Profile Picture
    bblake8480 638 on at
    Re: The request is forbidden by Graph API. Error code is 'accessDenied'. Error message is 'Access denied'.

    No, by my understanding, if the user doesn't have access to the Excel file, you cannot use this workflow. Power Apps and Power Automate run based on the credentials of the user that runs them. In your case, that's the user that was using the canvas app. If they cannot be given access to the Excel file where the data is stored, they cannot use the app as you are wanting them to.

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,343

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,703

Leaderboard

Featured topics