Hello.
I have App that collects data from user.
Then user clicks button and Power Automate flow to validate data and save it into .xlsx file on OneDrive triggers.
Everything works well as long as I start the flow and all of connections are my credentials and my OneDrive path with files.
Once I share the PowerApp to some user then the user is able to work with PowerApp and PowerAutomate flow starts correctly but then once it gets onto Excel Connector step there is an access error:
{
"status": 403,
"message": "The request is forbidden by Graph API. Error code is 'accessDenied'. Error message is 'Access denied'.\r\nclientRequestId: 11eb3eb1-37b9-4c6b-a0c8-349479ba3289\r\nserviceRequestId: 5ff24ef9-027b-4d06-a94f-8d0946501b91",
"error": {
"message": "The request is forbidden by Graph API. Error code is 'accessDenied'. Error message is 'Access denied'."
},
"source": "excelonline-eus.azconn-eus.p.azurewebsites.net"
}
This is the step where it fails.
I believe it is related to the fact that user is trying to access foreign OneDrive and doesn't have an access (correct me if I am wrong). The thing is how to fix it? It is common thing that users need an access to the same OneDrive so that shouldn't be a blocker of any kind... but I really cannot see any way to share that permission/connection.
