Query is invalid

[sbgoh]

Hi,

I have this formula in my label text below. However during runtime the error attached occurs. I cannot figure out what went wrong. Can anyone help? 

Sum(ForAll(
Filter(
Filter(
    GP_REQUEST,
    (MFR = MR_cbMfr.Selected.mfr || If(
        IsBlank(MR_cbMfr.Selected.mfr),
        true,
        false
    )) 
	), Stage.Value="Pending")
	,1), Value)

[VijayTailor]

Hi @sbgoh ,

can you explain a little bit more about what you trying to achieve by this Code?.
more few more details about the problem statement.

Thanks,

[sbgoh]

Hi @VijayTailor,

I am trying to count the number of records with certain conditions in the sharepoint list "GP_REQUEST".

[VijayTailor]

Hi @sbgoh ,

You can go with the below approach.

ClearCollect(RetriveDataCollection,Filter(
Filter(
    GP_REQUEST,
    (MFR = MR_cbMfr.Selected.mfr || If(
        IsBlank(MR_cbMfr.Selected.mfr),
        true,
        false
    )) 
	), Stage.Value="Pending")
	,1), Value)

CountRows(RetriveDataCollection);

Thanks,
Hope help you to resolve your Issue

[sbgoh]

Is there any limit count for collection?

[VijayTailor]

No limit for collection, if you use directly with filter query then it will show the delegation warning.

But Power app has a retrieve limit is max 2000 rows. Initially, by default, it will set to 500 but you can change. if you have roes more then 2000 to retrieve then different approach required here.

[sbgoh]

Can I put this formula in the label.text as there is error?

[VijayTailor]

Yes
on Label Text. YOu can Use Like below.

Text(CountRows(colCntPending)).
then your Lable display the Count Of Rows.
Thanks

[sbgoh]

But my error seems to fail at ClearCollect. Do I need to initialize this variable somewhere first?

[VijayTailor]

No Need to Declare. But you can attach the error screenshot for reference. (Please just cross-check the Filter Query you are passing incorrect ways)