cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
vish_p
Level 8

Choose sharepoint list as per user requirement in powerapps

I have 17 sharepoint list all of them have 2000-3000 items ,now when the app starts i would like to ask the user from which list he/she want s to view data and once the list is chosen only that list is loaded and data is filtered based on the user requirement

This is not possible if i put the data from all the 17 lists into one list (which forms around 25k items)

I tried collecting only the required data as per user choice into a collection but that is giving me some "incompatible type error"

 

Can any1 help me here please ?

1 ACCEPTED SOLUTION

Accepted Solutions
vish_p
Level 8

Re: Choose sharepoint list as per user requirement in powerapps

Fixed it by making different list and asking the user to select the list from which he want to search for the data,earlier i was having issue as the column types of all the list were not same,now that is fixed

View solution in original post

3 REPLIES 3
Super User
Super User

Re: Choose sharepoint list as per user requirement in powerapps

Hi @vish_p 

 

SharePoint lists can handle millions of records

so 25k items in a list is no problem

also, powerapps can handle all the items as long as you dont have an delegation issues

 

dynamically loading data sources in powerapps is not possible

 

Regards,

Reza Dorrani

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

vish_p
Level 8

Re: Choose sharepoint list as per user requirement in powerapps

@RezaDorrani  Thanks for the response!!

But i guess becasue of our organisation license we have a restriction of 5000 items list view threshold and powerapps will fetch only 2000 items

vish_p
Level 8

Re: Choose sharepoint list as per user requirement in powerapps

Fixed it by making different list and asking the user to select the list from which he want to search for the data,earlier i was having issue as the column types of all the list were not same,now that is fixed

View solution in original post

Helpful resources

Announcements
firstImage

Microsoft Business Applications Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

FirstImage

Power Platform World Tour

Coming to a city near you

thirdimage

PowerApps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

FourthImage

Join PowerApps User Group!!

Connect, share, and learn with your peers year-round

Top Kudoed Authors
Users Online
Currently online: 72 members 3,525 guests
Please welcome our newest community members: