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

Help Activities
, ,
1

Hi,

I’m currently working with Classic Sharepoint activities to get the list items from a site. So, Get List Items activity has a property to filter the list. While I’m adding a column name and value, I’m getting a syntax error as: “Literal only supports value types and immutable type System.String. The type system.object cannot be used as literal”.
Has anyone faced this issue?

Appreciate your help.

2

@ChagantiAkhil,

Kindly share more details like which activity/property/how you are passing etc to understand the issue in detail. Can share screenshot also if possible.

Thanks,
Ashok :slight_smile:

3

Here is the screenshot:

image
image1149×429 34.1 KB

4

@ChagantiAkhil,

Ok. Tried passing just Boolean True without “”?

5

Hi @ChagantiAkhil

Please refer below thread which might helps your issue

6

Yeah, I tired with most of the combinations: New Case - “True”; ‘New Case’ - True; ‘New Case’ - “‘True’”; “New Case” - “True”; “‘New Case’” - “‘True’”

None of them worked!!

7

I tired hardcoding all the values, but still facing the same issue

8

@ChagantiAkhil,

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

Thanks,
Ashok :slight_smile:

9

The activity is not allowing to use OData references. It is showing a Filter builder.

10

@ChagantiAkhil

Try like below

This image shows a Filter Builder window for a "Get List Items" action in Microsoft OneDrive & SharePoint, with a filter set to retrieve items where the "New Case" column equals "True". (Captioned by AI)
This image shows a Filter Builder window for a "Get List Items" action in Microsoft OneDrive & SharePoint, with a filter set to retrieve items where the "New Case" column equals "True". (Captioned by AI)921×686 18.4 KB

Hope it helps!!

11

It still gives the same error message !!
“Literal only supports value types and immutable type System.String. The type system.object cannot be used as literal”

12

@ChagantiAkhil
Can you try by updating the dependencies to the highest version by making runtime rule as lowest applicable

13

It is working. Thankyou @pravallikapaluri

Also, I noticed one more thing related to this activity: It is having a limitation on how many records to pull when we apply a filter.

1 Like
14

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.