Sharepoint: Get List Item Connection

Help Studio
, ,
1

Want to get sharepoint list items using “get list item connection” activity using either ID or else using variable for column name in filter.

  1. When giving ID, I am getting error “An unspecified error has occurred”.
  2. Not able to pass column name in filter if changing site url to variable.

Need urgent help on this. Any help is much appreciated

2

Hi @Netra_Singhal ,

  1. SharePoint Application Scope:
  • Site URL: "https://yoursharepointsiteurl"
  • Credentials: (Configured through Windows authentication or OAuth)
  1. Get List Items Activity:
  • ListName: "YourListName"
  • Filter: Use a CAML query
<View>
  <Query>
    <Where>
      <Eq>
        <FieldRef Name='ID' />
        <Value Type='Number'>123</Value>
      </Eq>
    </Where>
  </Query>
</View>

For dynamic filtering:

ColumnName = "YourColumnName"
FilterValue = "YourFilterValue"

FilterQuery = $"<View><Query><Where><Eq><FieldRef Name='{ColumnName}' /><Value Type='Text'>{FilterValue}</Value></Eq></Where></Query></View>"

Important Notes:

  • Ensure that your SharePoint site URL is correctly set.
  • Verify that the credentials provided have access to the SharePoint list.
  • Make sure the column names and data types in the CAML query match those in your SharePoint list.

Regards
Sandy

3

Hi @sandyarpa767 , Thanks but as specified in the question, I am only looking to use “Get List Item Connection” activity and not the classic sharepoint activity. Request your inputs on that, if possible.
Adding the screenshot of the activity for more clarity.

image
image1572×543 52.7 KB

4

Can you specify the error. Or attach error screenshot

5

Here’s an example setup:

  1. SharePoint Application Scope:
  2. Get List Item Connection Activity:
  • Properties:
    • ListName: "YourListName"
    • Filter: "<Filter><Eq><FieldRef Name='ID' /><Value Type='Number'>123</Value></Eq></Filter>"
  1. Using Variables for Filters:
  • Variables:
    • columnName: "YourColumnName"
    • filterValue: "YourFilterValue"
  • Filter Query:
    • FilterQuery: "<Filter><Eq><FieldRef Name='{columnName}' /><Value Type='Text'>{filterValue}</Value></Eq></Filter>"
6

Hi, I cannot find any option to edit filter like this in the get list item connection activity. Can you tell me which package version for MicrosoftOffice365 you’re using that’s helping you edit. Also, if you can help with the screenshot for reference along with it.