Others

How to Filter and Sum Values from a SharePoint List in Power Apps

Maira Mehtab Sep 22, 2026 868 views

Question details

The user needs to calculate and display the total amount for specific items by filtering a SharePoint list in a Power Apps canvas app.

Product: Power Apps
Device & OS: not provided
Scenario: Building a canvas app that retrieves and aggregates data from a SharePoint list based on user selection.
Observed behavior: The user wants to display the calculated total sum of a filtered amount column dynamically inside a text control.

Before you start

Ensure you have an active data connection to your SharePoint list in Power Apps and verify the exact internal column names for your item and amount fields.

Solution 1Recommended

Use the Sum and Filter Functions in the Text Property

Apply a combined formula to a text control's Text property to dynamically filter list items and calculate their total sum based on a user's selection.

When working with data sources like SharePoint, you can nest the Filter function inside the Sum function to calculate totals for specific records. Be aware of delegation limits if your SharePoint list contains thousands of records, as complex aggregation functions may only process locally up to your configured data row limit.

Select the Target Text Control

Open your canvas app in Power Apps Studio and click on the Text control where you want the total calculated amount to be displayed.

Enter the Aggregation Formula

In the formula bar, select the 'Text' property and input your formula. For example: Sum(Filter(list1, Item = DataCardValue2.Selected.Value), Amount). Replace 'list1', 'Item', 'DataCardValue2', and 'Amount' with your actual SharePoint list name, column names, and selection control name.

Check for Delegation Warnings

Look for a yellow warning triangle next to your formula. If you see one indicating a delegation issue, consider using a delegable data design or pre-filtering your data if the list is expected to exceed 2,000 records.

Column Data Types: Ensure that the 'Amount' column in your SharePoint list is strictly set to a Number or Currency type, as the Sum function cannot process text or choice fields.

Free Microsoft Office alternative

Manage Data Easily with WPS Office Spreadsheets

While Power Apps is excellent for custom business applications, if your primary goal is to filter, sum, and track list data, using a powerful spreadsheet might be faster and more efficient. WPS Office provides a free, lightweight, and highly compatible alternative to Microsoft Office for all your data analysis and tracking needs.

1. Download WPS Office: Visit the official WPS website to download and install the free office suite on your device.
2. Open WPS Spreadsheet: Launch WPS Office and open a new Spreadsheet or import your existing Microsoft Excel or CSV data exports.
3. Use SUMIF to Calculate Totals: Select a cell and use the SUMIF function to instantly sum values based on your specific criteria, exactly as you would in Excel.

Free and lightweight office suite for daily data managementHighly compatible with Microsoft Excel (.xlsx) formatsBuilt-in advanced formulas (like SUMIF and SUMIFS) to filter and sum data without complex app buildingFamiliar user-friendly interface with zero learning curve and seamless migration

microsoft office alternative - wps office

Frequently Asked Questions

Why am I getting a delegation warning with the Filter and Sum function in Power Apps?

A delegation warning occurs when Power Apps cannot hand off the processing of a function directly to the data source (like SharePoint) and must download the data to process locally. Aggregation functions like Sum are often not delegable with SharePoint, meaning Power Apps will only process the first 500 to 2,000 records of your list.

Can I sum multiple columns in the same Power Apps text control?

Yes, you can sum multiple columns by adding the results of individual Sum functions together. For example, you can write a formula like: Sum(Filter(list1, Condition), Column1) + Sum(Filter(list1, Condition), Column2).

Why is the Sum function returning an 'invalid argument type' error?

This error typically means the column you are trying to sum is not recognized as a numeric data type by Power Apps. Check your SharePoint list settings to ensure the target column is strictly formatted as a Number or Currency, rather than Single line of text.

How do I filter by multiple criteria before summing the values?

You can add multiple logical conditions inside your Filter function using the 'And' operator (&&). For example: Sum(Filter(list1, Item = Dropdown1.Selected.Value && Status = "Active"), Amount).

Office Quick Solutions