Answered

I am trying to add a search function on a gallery from a table that has different datatypes.

(0) Share

Report

Posted on by AlvinCassar

I have this table explained below:

Title of Column	Type of Column
ID (pk)	text
Machine HostName	lookup
CVE ID	lookup
State	choice

While having this simple gallery to show these fields:

Id:

Machine HostName:

CVE ID:

State:

Using the code below, I have managed to add a search function for the ID but not for the rest. What would be a viable change to make this work?

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (2)

Sort by

ZNK 24 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi,

Have you tried by adding the columns in your search function?
Search('Vulnerability Tables', TextInput2.Text , "cr667_id", "Machine hostname column", "another column", ...)

Was this reply helpful? Yes No
AlvinCassar 50 on at

Like
a
(0)

Report
Copy link

Link copied!

I have already tried that solution but it does not work.

Was this reply helpful? Yes No
ZNK 24 on at

Like
a
(0)

Report
Copy link

Link copied!

I'm afraid it won't work in this way because of the lookup columns. The search function can only use a single string to match values.
You could maybe try to save the lookup value in another column (as text and not as a lookup or record) so that you can use this column for your search function.

Was this reply helpful? Yes No
Verified answer

LaurensM 12,516 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @AlvinCassar,

As long as your table that you would like to search does not exceed your Data Row Limit (default 500, Max 2000), you can use the following non-delegable alternative:

Filter( 'Vulnerability Tables', TextInput2.Text in ID || TextInput2.Text in 'Machine HostName'.'Machine HostName' || TextInput2.Text in 'CVE ID'.'CVE ID' )

If this solves your question, would you be so kind as to accept it as a solution & give it a thumbs up.

Thanks!

Was this reply helpful? Yes No
Verified answer

AlvinCassar 50 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi thank you very much,

Is there a way to make this work with over 2000 rows?
Thanks.

Was this reply helpful? Yes No