Hi all
Can you please help me with how to write Odata filter in Get list item activity. I am trying to get all Excel files from SharePoint list.
That’s why I need to use filter property of get list item. What to write in that?
Hi all
Can you please help me with how to write Odata filter in Get list item activity. I am trying to get all Excel files from SharePoint list.
That’s why I need to use filter property of get list item. What to write in that?
Hi @Ish_Pandey
To retrieve all Excel files from a SharePoint list, you can follow these steps:
File_x0020_Type eq 'xlsx'
.Make sure to replace File_x0020_Type
with the actual internal name of the column that represents the file type in your SharePoint list. Also, adjust the file extension (xlsx
) according to your requirements.
Thanks!!
From where we can see what is the colum name from Office365SharepointList variable?
Pls see ss :
I am trying this but it’s not working. Region-Country is the file name which I need to get.
Error is : general exception while processing.
Get list items is used for getting the sharepoint list items and not files for files you need to use find files or folders activity please use it as needed
Cheers
Hi Anil,
Can you please let me know what to write in query if we need all Excel files to be downloaded from SharePoint which are modified in last 24hrs?
I am now using find files and folder activity what shoul I write in query?
You cannoy filter on time directly
If you want all excel files use “.xlsx” in the query…then you can get the modified time and all from the retrieved items…
And you sub folder should be the folder path from start of document library name till the folder where you have files
Cheers