I would like to filter the Sharepoint Online List based on the Modified date, to get only the last modified records. I am using the ADF Lookup component.
I was trying different queries, however non of them work and I am getting all elements in the list (or an error).
Modified ge '@{formatDateTime(addDays(utcNow(),-1),'yyyy-MM-ddTHH:MM:ssZ')}'
Modified ge '@{formatDateTime(addDays(utcNow(),-1),'yyyy-MM-dd')}'
Modified ge DateTime'@{addDays(utcNow(),-1)}'
$filter=Modified ge '@{formatDateTime(addDays(utcNow(),-1),'yyyy-MM-ddTHH:MM:ssZ')}'
ADF code:
"typeProperties": {
"source": {
"type": "SharePointOnlineListSource",
"query": {
"value": "Modified ge '@{formatDateTime(addDays(utcNow(),-1),'yyyy-MM-dd')}'",
"type": "Expression"
},
"httpRequestTimeout": "00:05:00"
},
"dataset": {
"referenceName": "sp_dataset",
"type": "DatasetReference",
"parameters": {
"list_name": "sp_list"
}
},
"firstRowOnly": false
}
How it's possible to filter the Sharepoint List from the ADF?
