Answered

Update - Search Function - Giving errors

(0) Share

Report

Posted on by IsaiahA

Dear All,

I didn't find an icon or anywhere to respond to an answer that someone responded to in my immediate previous request. I am copying it here again. I apologize for the inconvenience. The AttendanceID that I highlighted in yellow was written as "Attendance" in my initial post. It was a typo error then. Here is the question that I posted earlier.

Dear All,

My search function is not working properly. I have two tables in a Parent/Child relationship: Employee and Attendance. Employee is the Parent, and Attendance is the Child. I created an EmployeeID column in Attendance table and relate it to Employee table via LookUp. I can use the following Search function easily in Attendance (gallery): Search(Attendance,txtSearchInput.Text,AttendanceID). AttendanceID is the Primary name column in Attendance. However, the moment I tried Search(Attendance,txtSearchInput.Text,AttendanceID,EmployeeID), I started to receive error. My gallery references ThisItem.LastName, ThisItem.FirstName, and as such, I thought I could use EmployeeID.LastName, etc., only to give error. I do not have issues using Filter, but I wanted to use Search Instead to allow me to search based on a few entries with column. The attached is my screen, if things if I set Items property to Attendances. However, when I used the Search function as indicated earlier, it gave me errors. Could you help? Please note that I was able to use Filter successfully. I am more interested in using the Search Function.

Your attention to this request is greatly appreciated.

Sincerely,

Isaiah A.

Search_ErrorIssue...

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (3)

Verified answer

WarrenBelz 154,452 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@IsaiahA,

The other thread is here - please continue on that one.

Was this reply helpful? Yes No
IsaiahA 75 on at

Like (0)

Report
Copy link

Link copied!

Thank you for your response. No. It did not answer my question. I have tried Filter function before posting my question, just to see the return, and it worked. However, my main question is the Search function. Thanks.

Isaiah A.

Was this reply helpful? Yes No
Verified answer

WarrenBelz 154,452 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
@IsaiahA

Firstly, does this work
Filter( Attendance, txtSearchInput.Text in AttendanceID || txtSearchInput.Text in EmployeeID )

and also what is the error ?

Was this reply helpful? Yes No
Verified answer

IsaiahA 75 on at

Like (0)

Report
Copy link

Link copied!

Hi WarrenBelz,

Thank you so much! I didn't know that I could use the OR (II) symbol! I have been battling with the Search function for a couple of days! I will start using Filter where Search function wouldn't work. I may even let go of Search altogether. Happy new year. It shall be well with you and yours. Once again, Thank you!

Sincerely,

Isaiah A.

Was this reply helpful? Yes No
IsaiahA 75 on at

Like (0)

Report
Copy link

Link copied!

With respect to the answer provided by WarrenBelz, I just wanted to add this as the warning that I received. There is this yellow triangle with an exclamation sign inside the triangle by the gallery. It gave a delegation warning that the formula might not work on a large dataset. This is fine with me at this time. Once again, thanks to WarrenBelz.

Sincerely,

Isaiah A.

Was this reply helpful? Yes No
WarrenBelz 154,452 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@IsaiahA,

Yes - I assume you are using SharePoint if that filter is not Delegable. There is no workaround for this if that is the only filter criteria.

Was this reply helpful? Yes No