How to use OData Filter option to select specific rows from Sharepoint List using GetList Items activity?

Help Activities
1

I am unable to create a OData filter for using Get List Items activity for getting data filtered from Sharepoint List. In below example, OrderNumber is column name and ‘PND.2160357396’ is column value to filter
“$filter= substringof(OrderNumber,‘PND.2160357396’)”

2

Hi!

The column name and your value need to switch places :slight_smile:
Use OData query operations in SharePoint REST requests | Microsoft Learn

image
image886×319 17.3 KB