Hello,
I have created a simple approval workflow which is triggered by a Canvas App:
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"?
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.
I have created file in the flow and then accessing same file, still getting these errors.
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 😞
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.