Combo box on Number fields

(0) Share

Report

Posted on by Community Power Pla...

Hi,

I have a combo box that is connected to a data source from SharePoint.

On item I had written as:

Distinct('Payroll Ticket',Ticket_ID)

This displays all the ticket IDs from SharePoint.

The ticket Id column is number type and autogeneration one in SharePoint.

But I want to make the combo box as searchable too.

I tried to make Is Searchable as true.

But by default, it gets changed as False not able to change it.

Please do help out to make it as searchable on combo box.

Thanks

Soumiya

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

BCBuizer 22,505 Super User 2025 Season 2 on at

Like (0)

Report

Hi @Anonymous ,

Unfortunately only text fields are reachable:

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/controls/control-combo-box#description

If you want to search for items with numbers, convert numbers to text with Text() function. For example, Text(12345).

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Great thanks for your response @BCBuizer
But I had tried changing as follows:
Distinct('Payroll_Ticket', text(Ticket_ID))
But still it did not work let me know if anything is wrong

Was this reply helpful? Yes No
Verified answer

v-bofeng-msft on at

Like (2)

Report
Hi @Anonymous :

Please try:

ForAll(Distinct('Payroll Ticket',Ticket_ID),Text(Result))

Best Regards,

Bof

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

@v-bofeng-msft Thanks it worked.

Was this reply helpful? Yes No
DH-27020923-0 on at

Like (0)

Report

Hi @BCBuizer !
In which control of the combobox would you insert this Text(12345) code?

Was this reply helpful? Yes No
BCBuizer 22,505 Super User 2025 Season 2 on at

Like (2)

Report
Hi @Diederik_H ,

The solution is to set the Items property as @v-bofeng-msft suggested. However, the Distinct function has undergone a change where the returned column has been renamed from Result to Value. As a result the formula should be:

ForAll(Distinct('Payroll Ticket',Ticket_ID),Text(Value))

Was this reply helpful? Yes No