cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
AlanBo
Level: Powered On

Calculate sharepoint value by author

Hi, 

 

I've created a dropdown where i can select all authors from my sharepoint list
Distinct(datasource,author.displayname)

 

But then i want to sum a column from the list by the selected author.

Sum(Filter(datasource,dropdown1.selected.value),columnname)

 

I hope you can guide me in the righ direction.

 

Best regards

 

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Calculate sharepoint value by author

Hi @AlanBo,

Could you please share more details about the data structure of your SP list?

Is the author a custom Person type column in your SP list or the System column?

I have made a test on my side, please take a try with the following workaround:3.JPG

Set the Items property of the Dropdown control to following:

Distinct('20181122_case14','Created By'.DisplayName)

On your side, you should type:

Distinct(datasource, author.DisplayName)

Set the Text property of the Label control to following:

Sum(Filter('20181122_case14','Created By'.DisplayName=Dropdown1.Selected.Value),Amount)

On your side, you should type the following formula:

Sum(Filter(datasource, author.DisplayName = Dropdown1.Selected.Value), ColumnName)

More details about the Filter function, please check the following article:

Filter function

 

Best regards,

Kris

 

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 REPLIES 2
Community Support Team
Community Support Team

Re: Calculate sharepoint value by author

Hi @AlanBo,

Could you please share more details about the data structure of your SP list?

Is the author a custom Person type column in your SP list or the System column?

I have made a test on my side, please take a try with the following workaround:3.JPG

Set the Items property of the Dropdown control to following:

Distinct('20181122_case14','Created By'.DisplayName)

On your side, you should type:

Distinct(datasource, author.DisplayName)

Set the Text property of the Label control to following:

Sum(Filter('20181122_case14','Created By'.DisplayName=Dropdown1.Selected.Value),Amount)

On your side, you should type the following formula:

Sum(Filter(datasource, author.DisplayName = Dropdown1.Selected.Value), ColumnName)

More details about the Filter function, please check the following article:

Filter function

 

Best regards,

Kris

 

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
AlanBo
Level: Powered On

Re: Calculate sharepoint value by author

Thank you.

 

This works as expected.

 

To make it a bit more complicated, is there a way i can add a date picker to filter the amount greater than a specific date?

 

 

Helpful resources

Announcements
firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

FirstImage

Power Platform World Tour

Coming to a city near you

thirdimage

PowerApps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

FourthImage

Join PowerApps User Group!!

Connect, share, and learn with your peers year-round

SecondImage

Power Platform Summit North America

Register by September 5 to save $200

Top Kudoed Authors
Users Online
Currently online: 80 members 4,294 guests
Please welcome our newest community members: