
Announcements
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.
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.
The correct API will be as follow:
_api/web/GetFolderByServerRelativeUrl('subsitename/libraryname/foldername')/listItemAllFields?$select=Id,Title&$expand=Folders,Files