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