How to use filter option in Get List Items Sharepoint activity wrt filtering specific column values

[ashokkarale]

@ChagantiAkhil,

Try this thread if it works. Unfortunately I don’t have a setup to try & test this.

OData Filter For "Contains" On Get List Items Activity (Sharepoint)

Issue: Was successful getting the OData filter in this activity to work for “eq” specific field and search string but when trying to test with contains function it is not working. What I’ve tried: “contains(fields/Status,‘New’)” “fields/contains(Status,‘New’)” “$filter=fields/contains(Status,‘New’)” etc and keep getting error: Invalid Request Using the Get List Items activity under Sharepoint Lists Activities (UiPath.MicrosoftOffice365.Activites What I would like: Need correct format f…

Thanks,
Ashok