Hi,
I have a flow that should get list of all files in a Sharepoint directory and put the the list in a pre-existing table in an Excel file. Often there can be hundreds, even thousands, of files in the folder and I found that using the Excel connector took about 2 seconds to add each row, which is way too slow to be practical. After researching I found that it can be done using the MS Graph API and an HTTP POST request. However, when I try it the flow works until it gets to the HTTP request then stops with the error - "Either scp or roles claim need to be present in the token.".
The MS Graph permissions I have added to my app are Files.Read, Files.ReadWrite, Files.ReadWrite.All and Files.ReadWriteAppFolder. I think I read somewhere that I need to use Application Permissions not just Delegated permissions, but I do not know what that means and also the application permissions require Admin Consent. I work in a large corporation and do not even know who that would be and whether they would give me the required permissions. I do not understand why I should need administrative consent to add rows to a table in an Excel file that I created and own. Also, I need to know which permissions I need for the MS Graph API.
Here is the HTTP Post Request in full - what is wrong with it?
