Answered

Search Gallery from TextInput for SharePoint ID

(0) Share

Report

Posted on by JimmyW

2,563

Im trying to filter a gallery by searching a textinput, i want to be able to search for the SharePoint item ID but it seems impossible to achieve this without delegation issues and my list will contain more then 2000 items.

If anyone have a solution or guides or videos that might help me understand if i can achieve this solution please let me know.
I tried using a calculated column but i will get the delegate issue and only search the first 500 items.

I can create my own ID in a single text column and not use the SharePoint ID but that does not seem as a good solution.

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (2)

Sort by

Verified answer

mdevaney 29,991 Moderator on at

Like (1)

Report
Copy link

Link copied!
@JimmyWork

It appears you have already found the solution here and just need to implement it.

I can create my own ID in a single text column and not use the SharePoint ID but that does not seem as a good solution.

That's exactly how you should do it. Then you can use this code in the Items property of the gallery.

Filter(your_datasource_name,StartsWith(new_textId_column, TextInput1.Text))

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

Was this reply helpful? Yes No
JimmyW 2,563 on at

Like (0)

Report
Copy link

Link copied!

@mdevaney Thank you again 🙂

May i ask how would i generate an ID that is never replicated. In the app when the user creates the item how would that column be set to generate a number that is never used again on another item?

Was this reply helpful? Yes No
JimmyW 2,563 on at

Like (0)

Report
Copy link

Link copied!

Found it 🙂

Was this reply helpful? Yes No
Verified answer

mdevaney 29,991 Moderator on at

Like (1)

Report
Copy link

Link copied!

@JimmyWork

GUID function 🙂

Was this reply helpful? Yes No
JimmyW 2,563 on at

Like (0)

Report
Copy link

Link copied!

@mdevaney Thank yoy again but i ended up creating the Ticket ID using yyddmmhhmmss as it is shorter then the GUID

Was this reply helpful? Yes No