create an excel table fails only when user runs the flow through the powerapp.

(0) Share

Report

Posted on by Zaid-Aboobaker

I have a powerapp that exports gallery data using filters via an export button. the button calls a flow that looks like this

the flow creates a table in an excel file in the users onedrive folder. the template has been placed on sharepoint just for ease of access but the flow fails on the table creation stage even though the file has been created in the users one drive home folder. I am therefore puzzled about it being an access denied error.

the steps in question are here: flow detail.png

the error is:

The request is forbidden by Graph API. Error code is 'accessDenied'. Error message is 'Access denied'.
clientRequestId: 1805012e-895f-45d6-88fe-a2e7e4f8b2cb
serviceRequestId: 324dab5f-30cd-4bc2-b8c0-33e14ca318b9.

and the flow works when i test it from the app with my ( the creators) account.

Any assistance would be appreciated. thanks

Categories:

General topics

All responses (2)

Answers (0)

Sort by

ss_bent 12 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Zaid,

Did you fixed this issue. I'm facing the same issue. If possible would you please let me know, how did you fixed it!

Thanks,

Shub
Suggested answer

Zeebaker 8 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Dude

This was some time back but if i recall, I gave up on creating the file on onedrive and sharing a link to the users one drive. Instead, ive used sharepoint to create a file, email it and then subsequently delete the file. Where i needed to convert a file to pdf using the one drive feature, I have created it on my root folder, converted and saved the pdf file to sharepoint, and then deleted the version on drive within the flow.