Dropdown.Selected.Value wildcard

(0) Share

Report

Posted on by nicklim

391

Dropdown Items property

[
 "Nick Lim"
]

Dropdown OnChange property

If(Dropdown3.Selected.Value = "Nick Lim",
ClearCollect(
 FilteredList,
 Filter(
 'Incident Management',
 OperatorServiceDesk.Value = "Nick Lim" &&
 (
 Status.Value = "New" ||
 Status.Value = "Waiting for Customer" ||
 Status.Value = "Waiting for 3rd Party"
 )
 )
 )
)

Result

Hi everyone, the above is my initial setup where I can pick a name via the dropdown and the gallery will display all tickets that has been assigned to the selected person.

However, now I would like to include the total amount of active tickets that the person has next to its name. To do that, I will change the code in the Dropdown Items property to:

[
 "Nick Lim" & " " & "(" &
 Text(
 CountRows(
 Distinct(
 Filter('Incident Management',
 OperatorServiceDesk.Value = "Nick Lim" &&
 (
 Status.Value = "New" ||
 Status.Value = "Waiting for Customer" ||
 Status.Value = "Waiting for 3rd Party"
 )
 ),
 ID
 )
 )
 ) &
 ")"
]

Result

So as you can see, now it has number next to the name, and currently 1 ticket is assigned to the person. However, my gallery is not displaying the ticket unless I change the Dropdown OnChange property to:

If(Dropdown3.Selected.Value = "Nick Lim (1)"

Which is not ideal because the number is changed from time to time.

So I was wondering if we can use wildcard right after "Nick Lim" or is there a better way to do it?

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (0)

WarrenBelz 153,034 Most Valuable Professional on at

Like (0)

Report
Hi @nicklim ,

Try

Filter( 'Incident Management', StartsWith( OperatorServiceDesk.Value, "Nick Lim" ) && . . . . .

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No
nicklim 391 on at

Like (0)

Report
Hi @WarrenBelz

Not sure if I am doing it right as am getting delegation warning and the gallery is still not displaying the item

Dropdown Items property
[ "Nick Lim" & " " & "(" & Text( CountRows( Distinct( Filter('Incident Management', StartsWith( OperatorServiceDesk.Value, "Nick Lim" ) && ( Status.Value = "New" || Status.Value = "Waiting for Customer" || Status.Value = "Waiting for 3rd Party" ) ), ID ) ) ) & ")" ]

Was this reply helpful? Yes No
WarrenBelz 153,034 Most Valuable Professional on at

Like (0)

Report
@nicklim ,

Yes - another reason I do not use choice or lookup columns - StartsWith() is not Delegable. You also have two other non-delegable functions in there - CountRows and Distinct. The best you will do with some degree of Delegation is this

With( { _Data: Filter( 'Incident Management', Status.Value = "New" || Status.Value = "Waiting for Customer" || Status.Value = "Waiting for 3rd Party" ) }, "Nick Lim (" & Text( CountRows( Distinct( Filter( _Data, StartsWith( OperatorServiceDesk.Value, "Nick Lim" ) ), ID ) ) ) & ")" )

I wonder however why you are using the Distinct of ID when the ID field is a unique value.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No
nicklim 391 on at

Like (0)

Report
@WarrenBelz

Yes it is not throwing the delegation anymore but still not showing the result in gallery.

Back then I believe I was searching for an answer and found it somewhere and it worked lol.

Just to clarify a dumb question, we can't use wildcard after "Nick Lim"?
OperatorServiceDesk.Value = "Nick Lim"
Something like in PowerShell if you know what I mean, sorry I couldn't find a better way to explain it.

Was this reply helpful? Yes No
WarrenBelz 153,034 Most Valuable Professional on at

Like (0)

Report
@nicklim ,

No - there is not equivalent of a "wildcard" in Power Apps filters - you can use the in Filter which will look for the string anywhere in the Text

With( { _Data: Filter( 'Incident Management', Status.Value = "New" || Status.Value = "Waiting for Customer" || Status.Value = "Waiting for 3rd Party" ) }, "Nick Lim (" & Text( CountRows( Distinct( Filter( _Data, "Nick Lim" in OperatorServiceDesk.Value ), ID ) ) ) & ")" )

It is also not Delegable, hence the need to "pre-filter" with any Delegable filters and hopefully get the result of this under your Delegation limit.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No