Hello people,
I have a problem that causes me some serious headscratching. I created a canvas app that fetches a list from Sharepoint, there is a button to save this list as Excel file, by passing the list as JSON object to a flow. Everything works as it should. Now I created another flow that is supposed to do the same as this flow, just that it doesn't get triggered by the button but automatically everyday at 5am. This flow is receiving the error message: "Access is denied. (Exception from HRESULT: 0x80070005 (E_ACCESSDENIED))"
I'm owner for the sharepoint list with total access:
Flow that gets access denied:
Canvas app fetching the list successfully:
The data connectors fetching the list in the canvas app and in the flow are both my user account. I tried everything, reactivating the flow, creating new data connectors. I have no clue why the list can be fetched from the canvas app but not from the flow.
Hopefully someone can bring me on the right track. I wish you all good christmas holidays.