Hi,
I am trying to get the file properties from a SharePoint file from within my flow. I have four pieces of information about the file.
- Site URL
- Source Relative URL
- Filename
- Full URL
This information is coming from the SharePoint Audit Log.
I have tried using the Send HTTP Request to SharePoint action, but whilst I can get information about the folder that the file sits in, I don't appear to be able to get any information about the file (the JSON output is []).
If I use the query
_api/web/GetFolderByServerRelativeUrl('subsitename/libraryname/foldername')?$expand=Folders,Files
I get the following (i have stripped out most of the output),
"Files": {
"results": []
},
"Exists": true,
"IsWOPIEnabled": false,
"ItemCount": 4,
So, it knows that there are files there, it just won't tell me anything about them.
Where am I going wrong? Is there a better way to do this?
regards,
Simon.

Report
All responses (
Answers (