News and Announcements icon

Power Platform CommunityForums Power Apps - Building Power Apps Text box to filter dat...

Power Apps - Building Power Apps

Answered

Text box to filter data to a Data Table and then to sum an amount column at a label box

(0) Share

Report

Report

Posted on by kouliscon

247

Hello,

i have a canvas app which i have placed

a text box to filter
a dataTable with the following formula in "item":

SortByColumns(Filter(List_Name_A, StartsWith(VendorColumn , FilterBox.Text)),"Invoice_Date",Descending)

i have added a "Label" box and i want to get the Sum of the column "Invoices Amount" but what is fitered each time. Any help with the formula?

thank you

Categories:

Using Apps Using Formulas

Connecting to Data

All responses Img

All responses (4)

Answers Img

Answers (1)

kouliscon 247 on at

Like (0)

Report

Re: Text box to filter data to a Data Table and then to sum an amount column at a label box

great explanation CNT thank you
CNT 10,919 Super User 2025 Season 1 on at

Like (0)

Report

Re: Text box to filter data to a Data Table and then to sum an amount column at a label box

@kouliscon Forms are used when you want to Add, Edit or Display just one record. If you want to show a list of records, you have to use a Gallery or a DataTable.

Please remember to give a 👍 and accept the solution as it will help others in the future.
kouliscon 247 on at

Like (0)

Report

Re: Text box to filter data to a Data Table and then to sum an amount column at a label box

Thank you CNT that worked and thank you for the info on delegation.
i tried to connect a Display Form but i haven't figure it out. Do you know if is possible or only will work with Gallery and/ or Data Table?
Verified answer

CNT 10,919 Super User 2025 Season 1 on at

Like (1)

Report
Re: Text box to filter data to a Data Table and then to sum an amount column at a label box

@kouliscon There is no property to get the Items in a DataTable. So either you use a gallery instead of a DataTable and use the AllItems property of the Gallery to get the filtered records or you have to repeat the formula in the total label like this,
Sum(Filter(List_Name_A, StartsWith(VendorColumn , FilterBox.Text)),"Invoices Amount")
Please be aware that using the Sum function directly on a datasource can also cause delegation issues.