Showing results for 
Search instead for 
Did you mean: 
Helper I
Helper I

Sum currency column from SharePoint List based on date range


I have been trying different formulas without success if I want to Filter by a date range. The Sum function with my currency field without date as a criteria works fine even though I get the delegation warning.

I looked around the forum and tried a few things but no sucess.


My Goal: Sum up the 'Amount' column from my List called 'MaintenanceExpenses' for a specified date range based on 'ExpenseDatePickerFrom' and 'ExpenseDatePickerTo'. The date picker compare the date with my 'Created' column.


I have a SharePoint List with a column 'Amount' that is of Currency type.


My App and formula:





Text(Sum(Filter(MaintenanceExpenses,Value(Text(Created,"[$-en-US]mm/dd/yyyy")) >= ExpenseDatePickerFrom.SelectedDate,Value(Text(Created,"[$-en-US]mm/dd/yyyy")) <= ExpenseDatePickerTo.SelectedDate),Amount),"[$-en-US]$#,###0.00")



Most likely I'm making a very basic mistake. Any suggestion would be amazing!






yes you got it. glad to see you sorted the filter. good luck with the app, have fun.

Thanks @rubin_boer !

I am adding a bit of detail to conclude my challenge and hopefully help someone in the future.

The 'Created' field date format setting was set to 'Friendly'. I changed it to 'Standard' and was able to get the math accurate in my Sum. It was preventing my '>=' to work.


Helpful resources

UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Solution Authors
Top Kudoed Authors
Users online (3,485)