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

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:

Building Power Apps

I have the same question (0)

All responses Img

All responses (4)

Answers Img

Answers (1)

Sort by

Verified answer

CNT 10,921 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
@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
a
(0)

Report
Copy link

Link copied!

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
a
(0)

Report
Copy link

Link copied!

@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
a
(0)

Report
Copy link

Link copied!

great explanation CNT thank you

Was this reply helpful? Yes No

Join the conversation