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.
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);
Hope help you to resolve your Issue
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Join us on June 28 for our monthly User Group leader call!
This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.
Check out our new release planning portal, an interactive way to plan and prepare for upcoming features in Power Platform.