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
Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.
Register today for two amazing days of learning, featuring intensive learning sessions across multiple tracks, led by engaging and dynamic experts.
The European SharePoint Conference returns live and in-person November 28-December 1 with 4 Microsoft Keynotes, 9 Tutorials, and 120 Sessions.
We are excited to announce a new way to share your ideas for Power Apps!