Accumulated values from sharepoint list

(0) Share

Report

Posted on by Francisco77

353

Hi All,

I have a P. Apps in which sales data is entered for three offices, "A", "B" and "C". This data is stored in a Sharepoint list, where the Title column is the name of the office (A, B or C) and in a second column the sales are captured.

Can I enter a "Tag" in the P. Apps, connect it in some way to the Sharepoint list and have it show me the accumulated sales for the office that I am entering data?.

To select the office to load data, select A, B or C from a drop-down list.

Thanks¡

Categories:

Building Power Apps

All responses (4)

Answers (0)

Sort by

WarrenBelz 156,526 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Francisco77 ,

You will need to add your drop-down and field name here, but it should be something like

With( { _Data: Filter( SPList, Title = Dropdown.Selected.Value ) }, Sum( _Data, SalesFieldName ) )

NOTE .Value may be a field name depending on the Items of the drop-down

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps
Francisco77 353 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @WarrenBelz

Thanks for your help.

Insert a "Text Entry" box that, although it shows the accumulated %, only shows the value each time I record new data. The ideal would be that when choosing the value "A", "B" or "C" from the drop-down list, it immediately shows the accumulated value, not that you have to enter new data for it to do so.
Francisco77 353 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @WarrenBelz

The value it shows me is the total of that column, independent of the "Title", that is, it is not filtering.

Thanks
WarrenBelz 156,526 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Francisco77 ,

That is what it should do assuming (as you posted) that you Title column contains the values A/B/C and your drop-down selects from these.