Sum function does not work properly

[Anonymous]

Hi everyone,

I have the following code, which worked properly until April. After I came back from my vacation it does not work anymore, and I am wondering why.

I have a sharepoint list (SendPoints), and am collecting the data via collmypoints. Then I am trying to Sum all the points a person received in the recent month and write it in the variable ( varMyRecPointsThisMonth). However the variable is empty even though it should output a specific value.

Clear(collmypoints);;
Collect(collmypoints;SendPoints);;
Set(varMyRecPointsThisMonth;Sum(Filter(collmypoints;Title=varLoginUserEmail && Month(SendDate)=Month(Now()));Points));;

btw. I am using German syntax.

Can anyone help?

[RandyHayes]

@Anonymous 

What type of column is Points in your list?

Does the following formula produce a table of results?

    Filter(SendPoints; Title=varLoginUserEmail && Month(SendDate)=Month(Now()))

[Anonymous]

Points is a Number.

When copying this code into a table, I will see the columns but no data in it.

Filter(SendPoints; Title=varLoginUserEmail && Month(SendDate)=Month(Now()))

[RandyHayes]

@Anonymous 

So the issue is with your Filter, not the Sum function.

Try to break down the filter to see where the issue is coming from.

Try: 

    Filter(SendPoints; Title=varLoginUserEmail)

Then try: 

    Filter(SendPoints; Month(SendDate)=Month(Now()))

See which does and doesn't work.

[Anonymous]

This works:

  Filter(SendPoints; Title=varLoginUserEmail)

It seems that the month formula has some error in it, however I cannot imagine of what could be faulty, since it worked for 3 months

[RandyHayes]

@Anonymous 

See what happens when you go on vacation 😂

Try the following formula and see if it produces results:

        With({_mnth: Month(Now())}, Filter(SendPoints; Month(SendDate)=_mnth)

See if there is an issue evaluating the Month in the filter.

Also, I don't know your data, but be careful with filtering by month only...May of 2021 is the Same a May of 2020.

[Anonymous]

No vacation from now on 😂.

Sorry for answering late. I tried your code. However this does not output anything.

[Anonymous]

I think I am on the track of something. 

Is there a restriction on the dataset quantity when using a collection? I just inserted the collection collmypoints to the App and when I scroll down, I only see datasets until March. Nothing for April and May.

And this is also the timespan where the problem started despite not changing anything.

Thanks & regards

[R3dKap]

Hi @Anonymous,

Power Apps has a limit of 500 records (max is 2000 and can be setup through the File > Advanced settings options) to be retreived by a request (Filter, Search, ...). It doesn't have any limit on how many records will be checked upon your condition (if your condition is delegable), only on the number of returned records AFTER the request has executed on the datasource side.

Meaning: if you filter a 1 million records list and the result has 6.000 records in it, only the 500 first records from this result will be returned to Power Apps.

[Anonymous]

Hi @R3dKap 

thanks. But that means that the collection itsself (collmypoints) should have all the records, right? But that is not the case. Because the collection itsself without any filter does return datasets until March and not any further