Unanswered

Simple gallery search = nightmare

(0) Share

Report

Posted on by PedroK

Dear all, i admit im going nuts.

I have a simple gallery, pulling info from a sharepoint list. Simple and working ok.
Now the issue starts when i wanna search the data from the sharepoint list.

On a break down, the fields i have are:

All of them are text, except:
IDLists - number
MaxPriority - number
ModifiedBy - user
UpdatedOn - date

This is my search options:

Meaning, i want the search to be made in 1 of 2 ways, either by App, or globally (all records)

The issue starts when i wanna search the info on the sharepoint.
My actual code is:

Filter(EditableEC,((If(Checkbox1_3.Value=true ,Find(Trim(Upper(TextInput1_1.Text)),Trim(Upper(AssignmentGroup)))) > 0)))

And this is only part of the search i need to make, but already gives me this feedback:

Can anyone please help? 😞

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

Sort by

PedroK 69 on at

Like
a
(0)

Report
Copy link

Link copied!

Same error applies to any field i wanna use to search on (either AssignmentGroup, Application, IDs, Procedure etc)

Was this reply helpful? Yes No
Gochix 1,937 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
@PedroK ,

I'm not sure if this would be your desired outcome but you could try something like this:

With({ Filter1: Filter(EditableEC,Find(Trim(Upper(TextInput1_1.Text)),Trim(Upper(GlobalColumn))))}, With({ Filter2: Filter(EditableEC,Find(Trim(Upper(TextInput1_1.Text)),Trim(Upper(LocalColumn))))}, If(Checkbox1.Value=true,Filter1,Filter2)))

_____________________________________________________________________________________
Please give a thumbs up if I resolved your issue! Please click Accept as Solution to close the topic!

Was this reply helpful? Yes No