cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Continued Contributor
Continued Contributor

Query a SP list with greater than 33k items

Greetings,

 

I am seeking the option to pull data into an app based on one or multiple search criteria.  The SP list, where the data is housed, has 33k + items.  My goal is to provide the user a Search screen and not pull any data into the app until they query it.  If a user selects multiple criteria, i.e. State, Project Year, and Project Category, I would like to display the data in a gallery.  If a user selects a unique item, based on project number, then I would like to display the details for that project in a DisplayForm or Labels.  

 

The question is - how can i query the data in SP.  I understand delegation and was trying to test by displaying a project utilizing the Lookup function.  However, that does not work. 

 

Tagging all who I follow or have been most responsive.  Thank you!

 

@v-monli-msft

@Shanescows

@Meneghino

@audrieg

@CarlosFigueira

@mr-dang

10 REPLIES 10

@Jeff_Thorpe@v-monli-msft

I have tried all ways described with no luck.  I do notice, however, that when I initially put the formula in I do not get the redline error.  It is when I initiate the filter that I receive the following - 'An error occurred on the server'.  This leads me to wonder - do i need to add the App ID for the PowerApps somewhere in the SharePoint security settings - allowing the app to process on the query on SP? (Similar to the process for embedding an app?)

 

Helpful resources

Announcements
New Badges

New Solution Badges!

Check out our new profile badges recognizing authored solutions!

New Power Super Users

Congratulations!

We are excited to announce the Power Apps Super Users!

Power Apps Community Call

Power Apps Community Call: February

Did you miss the call? Check out the Power Apps Community Call here.

Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

Top Solution Authors
Top Kudoed Authors
Users online (24,353)