web

You’re offline. This is a read only version of the page.

News and Announcements icon

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

Power Apps

Unanswered

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:

Building Power Apps

I have the same question (0)

All responses Img

All responses (4)

Answers Img

Answers (1)

Verified answer

CNT 10,921 Super User 2024 Season 1 on at

Like (1)

Report
@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.

Was this reply helpful? Yes No
kouliscon 247 on at

Like (0)

Report

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?

Was this reply helpful? Yes No
CNT 10,921 Super User 2024 Season 1 on at

Like (0)

Report

@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.

Was this reply helpful? Yes No
kouliscon 247 on at

Like (0)

Report

great explanation CNT thank you

Was this reply helpful? Yes No

Join the conversation