Answered

Sum with Filter for SharePoint List

(0) Share

Report

Posted on by skewa1

I am trying to do a sum in PowerApps using my connected SharePoint list.

SharePoint List Column Name Month Number = MonthNo
PowerApps Textbox listing month number is named = CurrentMonthNo formula is Month(now())
SharePoint List is called Payments
SharePoint List Column to Sum is TotalValue

I want to Sum the values on my list subject to the month Number

my formula in the textbox is: Sum(Filter(Payments, MonthNo = CurrentMonthNo),TotalValue)

Im getting no value, help!

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Verified answer

Manish Solanki 15,169 Moderator on at

Like (1)

Report
Copy link

Link copied!

Hi @skewa1

You need to use 'Text' property of CurrentMonthNo text box in the Filter formula, pls modify the formula as mentioned below:
Sum(Filter(Payments, MonthNo = CurrentMonthNo.Text),TotalValue)

I hope that it will fix the issue. Please remember to give a 👍 and accept my solution as it will help others in the future.

Thanks

Was this reply helpful? Yes No
skewa1 14 on at

Like (0)

Report
Copy link

Link copied!

Works like a charm. thank you

Was this reply helpful? Yes No
knsrinath 527 on at

Like (0)

Report
Copy link

Link copied!

Hi @ManishSolanki

There is a delegation warning
Could you help me to resolve this issue.

Thanks & Regards

Was this reply helpful? Yes No