Answered

use of views in sharepoint list

(0) Share

Report

Posted on by tmpandc

what is the main use case of views in sharepoint list,lets say i created a viw depending upon the sort or a filtering condition. so if i access that list using powerapps will it affect the data loaded in the powerapps , lets say the first 500 rows are beign loaded in powerapps , does it load only the sorted or filtered data depending upon the views or it will simply load the first 500 rows

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

v-qiaqi@microsoft.com on at

Like (0)

Report

Hi @tmpandc，

Do you want to access to the List views created in SharePoint using Power Apps?

If so, I am afraid that Power Apps doesn't support the use of list views from SharePoint. You'll need to do the filtering thing in the Power App itself.

In a word, Power Apps will display the first 500 records by default if you don't have any Filter() function to filter records.

Was this reply helpful? Yes No
tmpandc 38 on at

Like (0)

Report

lets say i want to access the latest 500 rows of data , how can i do that, and another followup lets say i have about 5000 rows of data in the list will the powerapp can able to return the sorted or filtered data by sing formula or else there is an limit for that

Was this reply helpful? Yes No
v-qiaqi@microsoft.com on at

Like (0)

Report
Hi @tmpandc，

To capture the first 500 record, just use a Gallery and set the Items property as:

Sort(List,Created,SortOrder.Descending)

Note that if you have the row limit set as 500 by default, the gallwey will aoways display the latest 500 records.

Power Apps could only display 2000 records at max.

If you have formula to filter or sort data, it will return 2000 based on the filter or sort condition at max.

Was this reply helpful? Yes No
tmpandc 38 on at

Like (0)

Report

so the concept is powerapps can retrive data only upto 2000 rows at once . if i filter or sorting will be applied to all the data in the list and retrive only the first 500 rows by default. is that right. because my list contains almost 10k rows of data

Was this reply helpful? Yes No
Verified answer

v-qiaqi@microsoft.com on at

Like (0)

Report

Hi @tmpandc,

@tmpandc wrote:

so the concept is powerapps can retrive data only upto 2000 rows at once .

Yes.

@tmpandc wrote:
if i filter or sorting will be applied to all the data in the list and retrive only the first 500 rows by default. is that right. because my list contains almost 10k rows of data

No, 2000 if the max row limit for Power Apps to get records from data source. By default, it is 500, however we could raise it to 2000 at max.

Further, if you filter or sorting will be applied to all the data in the list and retrive only the first 500 rows by default if you set the row limit as 500. It will retrieve 2000 if you set the row limit as 2000.

Using a delegable function makes sense, here is a detailed doc related to delagation:

Understand delegation in a canvas app - Power Apps | Microsoft Learn

Was this reply helpful? Yes No