Unanswered

Searchbox help for PowerApps

(0) Share

Report

Posted on by AmirulAzim

Hello and good day everyone.

I have created a search box in my PowerApps but I encountered a problem with it. When I try to find the ticket number ('ID') , it only show up to 2000 items only. In the BrowseGallery1 also, I got a warning like this :

Kindly need an assistance on how to solve this issue.

Thanks,

Amirul

Categories:

Building Power Apps

All responses (25)

Answers (0)

Sort by

EddieE 4,650 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

@AmirulAzim

ID is a special data type so isn't delegable which is why you are getting the errors/message.

If your Ticket number matches the ID and you need this search to work on >2000 records then you are best off creating a shadow column for Ticket number of type Text or Number
Ramole Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@AmirulAzim
ID is a number, so you have delegation issue, and if you still wanted to search ID the best way is create another field called IDText and single line text backend like SharePoint.
AmirulAzim 16 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Ramole.

Could you teach me on how to create another field ? Your help and guidance is greatly appreciated.

Thanks
Ramole Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @AmirulAzim
Sure, are you using SharePoint correct?

Create a single line text column and call it IDText in SharePoint and in PowerApps when when saving you're data just point IDText = ID, now it will save the ID in to IDText and now it will delegable when you add in filter

If you need any assistance let me know.
AmirulAzim 16 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello @Ramole,

I already create IDText in Sharepoint. My questions is how to point IDText = ID in PowerApps?

Thank you.
Ramole Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@AmirulAzim
How are you normally save your data back to SharePoint?
Ramole Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@AmirulAzim
If you're using a Form to save the data here is a sample on how to do it,

After you set it up, you can hide IDText_DataCard, keep in mind this will save only any new record created going forward. and you can replace your filter formula ID to IDText example change the part of

StartsWith( IDText,TextSearchBox1.Text)

To copy the existing ID to IDText you will need patch use like ForAll to make it easy Bulk
AmirulAzim 16 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello @Ramole.

Am I following the correct steps?
Thank you
Ramole Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @AmirulAzim
Yes, you're following correctly.
Ramole Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@AmirulAzim
Just checking, did you set it up?