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?
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
User | Count |
---|---|
190 | |
95 | |
62 | |
59 | |
58 |
User | Count |
---|---|
251 | |
164 | |
93 | |
79 | |
70 |