Unanswered

Filter function works with only 3 conditions

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi,
I’m trying to filter data from SharePoint list with 4 conditions and sum one of the column.

Here is my formula

Sum(filter(datasource, condition1 && condition2 && condition3 && condition4), colx)

It doesn’t work. If I remove one condition it works, it shows the sum.

Is there any restrictions on no of conditions with filter function or can you help on this? Thanks

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

Sort by

Jeff_Thorpe 6,085 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

I am not aware of limit with conditions. Are you sure that you have items in the SharePoint list that meet all four conditions? If so, how large is your list? I ask because I don't think the Sum() is delegable in SharePoint, so it could be factor in your results.

You can also write the formula like this:

Sum(filter(datasource, condition1, condition2, condition3, condition4), colx)

Was this reply helpful? Yes No
v-xida-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @Anonymous ,

Could you please share more details about your formula?

Based on the issue that you mentioned, I have made a test on my side, and don't have the issue that you mentioned. Please consider modify your formula as below:

Sum(
Filter(
datasource,
condition1,
condition2,
condition3,
condition4
),
colx
)

Please also check if you have specified proper filter condition within your Filter function. More details about Filter function, please check the following article:

Filter function

Best regards,

Was this reply helpful? Yes No