Skip to main content
Question

Pipeline - SharePoint Item Search Issue

  • December 28, 2020
  • 0 replies
  • 124 views

Forum|alt.badge.img+6

I am creating a pipeline to update existing items in a SharePoint list when an item is updated in a Quick Base table.  When I do the step to look up the item in SP (SharePoint) I am unable to find the record via a search of its record  #tag that matches the QB Record ID#.  The SP list has over 3,000 items in it.  Is there an item limit that Pipelines can search through for SP items?



------------------------------
Joshua Case
------------------------------
This topic has been closed for replies.

  • Quickbase Alumni
  • December 28, 2020

I have pipelines that search through nearly 200k records in a single table and I'm sure others have even larger data sets, so 3k shouldn't be a problem. I would double-check to see if both values are stored as the same data type. Also, if they're stored as numeric values, you may have to force Pipelines to convert the search value to an integer for the match (not sure about that, but I know I've had numeric issues with Pipelines).



------------------------------
Blake Harrison
bharrison@datablender.io
DataBlender - Quick Base Solution Provider
Atlanta GA
404.800.1702 / http://datablender.io/
------------------------------