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)
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,
Hi @VijayTailor,
I am trying to count the number of records with certain conditions in the sharepoint list "GP_REQUEST".
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
Is there any limit count for collection?
Can I put this formula in the label.text as there is error?
But my error seems to fail at ClearCollect. Do I need to initialize this variable somewhere first?
User | Count |
---|---|
254 | |
106 | |
96 | |
50 | |
39 |