Don't repeat yourself...in a label text

(0) Share

Report

Posted on by sasrsc

678

I am doing this... in the label text value...

If(CountRows(Filter(Customers,TicketRequestId=selectedTicketRequestEventID))>0,"View/Edit the " & CountRows(Filter(Customers,TicketRequestId=selectedTicketRequestEventID)) & " Customers","Add Customers")

I'm repeating some code with the countrows twice...
How could I do with once only so I don't repeat myself. I assume I can do a "with" here somehow...

Still getting comfortable with "withs"

Categories:

Building Power Apps

All responses (4)

Answers (1)

Sort by

ansrikanth 329 on at

Like
a
(1)

Report
Copy link

Link copied!
@sasrsc why dont you set it to a context variable or variable and use it? something like
Set(RowCount,CountRows(Filter(Customers,TicketRequestId=selectedTicketRequestEventID))>0); If(RowCount>0,"View/Edit the " & RowCount & " Customers","Add Customers")
Thank you
-Srikanth
cwebb365 3,334 Most Valuable Professional on at

Like
a
(2)

Report
Copy link

Link copied!
This should work.

WITH( {CountedCustomers: CountRows(Filter(Customers,TicketRequestId=selectedTicketRequestEventID))} ) If(CountedCustomers >0,"View/Edit the " & CountedCustomers & " Customers","Add Customers")
Verified answer

sasrsc 678 on at

Like
a
(0)

Report
Copy link

Link copied!
Thank you both of you....

FWIW I had to make a slight tweak with parenthesis to @cwebb365 solution for that to work.
With( { CountedCustomers: CountRows( Filter( Customers, TicketRequestId = selectedTicketRequestEventID ) ) }, If( CountedCustomers > 0, "View/Edit the " & CountedCustomers & " Customers", "Add Customers" ) )
In the end I had multiple places where I needed the calculation so that logically took me to the @ansrikanth 's solution, although I'll use a context Variable.

My follow up question is - if there was only one place where I needed this then which is the "most efficient" method.
A context variable or the with idea?
Is there actually any difference behind the scenes in performance. I realize it's so insignificant but I'm just curious.
ansrikanth 329 on at

Like
a
(1)

Report
Copy link

Link copied!

Honestly, AFAIK the performance difference what you are talking about is so insignificant that it is not worth to discuss also especially when you are talking about a single valued text 🙂..
Behind the screen MS must be defining some variables to bind the values, it may just vary the life time of it.

Thank you-
Srikanth
Please mark the correct answer for the question to help others as well.