If I try using this I always this option I always get the same error “Get List Items: An unspecified error has occurred.” but the column exists and has datetime as datatype:
The activity gives other option to filter but is asking for a IEnumerable argument and I don’t know what kind of expression should I pass here. For what I understand this activity should accept oData filters.
Can someone help me understand how the filters work in this activity and maybe give me some example of a working filter.
In this case I need to filter the Sharepoint list by the creation date to get the items that are greater than Today.AddDays(-1) and lower than Today.
Yes, if I use the activity without any filter I get all the items from that list and the value of the ‘Created’ column is in fact datetime.
I can get all the items and filter the results after but if the activity has the option to filter it should be more effective and give better performance.
I searched online and can´t find any example or information on how to use the filter by giving the ienumerable argument.
Your unspecified error may be occurring because the SharePoint List column you are Filtering on has not been indexed. If the error also contains " The request is unprocessable because it uses too many resources", you may need to index your column. I had a similar issue with a plain text field and this resolved the issue. Here is the link on how to add an index to a SharePoint Column. Add an index to a list or library column