Skip to main content
Question

Using the SharePoint package Get list item(s), can we apply a filter?

  • February 5, 2026
  • 1 reply
  • 91 views
DeLo
Forum|alt.badge.img+5
  • DeLo
  • Navigator | Tier 3

I know there are ID and Title filters available, but what about a way to apply a CAML Query? This would eliminate needing to retrieve ALL list items, then looping the results with IF conditions. Is there a way? If not, is it coming?

Sometimes, SharePoint lists have over 100k list items in them. And that takes minutes to retrieve.

    1 reply

    Aaron.Gleason
    Automation Anywhere Team
    Forum|alt.badge.img+14
    • Aaron.Gleason
    • Automation Anywhere Team
    • February 5, 2026

    ​@DeLo A few minutes to retrieve 100K items? Your SharePoint runs faster than ours!  😅

    I’m sorry to say there doesn’t appear to be any away to perform a CAML query. The filtering, as you saw, is limited to List item ID, List item title, and Folder.

    HOWEVER, there are Python libraries available. If you don’t mind doing some Python coding, you might be able to perform the queries you want.

    https://github.com/vgrem/Office365-REST-Python-Client/blob/master/examples/sharepoint/lists/read_items_with_caml_query.py

    Modifying the script to return a JSON-encoded list of values instead of printing them to the console would allow for integration with Automation Anywhere, providing a list of just your filtered items.

    Aside from that, if you think a product enhancement is in order, you may start a support ticket by emailing your request to support@automationanywhere and request the enhancement.

    Hope this helps!

    Terms & ConditionsCookie settingsAccessibility statement