Unanswered

Filter fails

(0) Share

Report

Posted on by neethup

Hi.. I have applied some filter on Datatable like i need to filter with First Name, last Name and two more fields.. But its failing sometimes.. Datatable is not loading sometimes..

Filter('[dbo].[Patient_Registration_Custom]',DataCardValue5_1.Text in RHCPRNO,DataCardValue18.Text in OAClientID , DcFirstN.Text in FirstName, DcLastN.Text in LastName)

This is my code.. Can anybody help?

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (0)

Sort by

mdevaney 29,991 Moderator on at

Like (0)

Report
Copy link

Link copied!
@neethup
My first question is: did you have any reason to use the IN operator instead of the (=) operator? Try this instead...

Filter('[dbo].[Patient_Registration_Custom]',
DataCardValue5_1.Text = RHCPRNO,
DataCardValue18.Text = OAClientID,
DcFirstN.Text = FirstName,
DcLastN.Text = LastName
)
If the error persists, you'll have to do some tests to determine if there is any pattern to when the Table fails to load.

---
Please click "Accept as Solution" if my response helped to solve your issue so that others may find it more quickly. If your thought the post was helpful please give it a "Thumbs Up."

Was this reply helpful? Yes No
neethup 52 on at

Like (0)

Report
Copy link

Link copied!

@mdevaney Hi.. = is not working for me so only in operator used

Was this reply helpful? Yes No
mdevaney 29,991 Moderator on at

Like (1)

Report
Copy link

Link copied!

Can you please give details on why (=) is not working? Did you receive an error message?

Was this reply helpful? Yes No
neethup 52 on at

Like (0)

Report
Copy link

Link copied!

@mdevaney Hi.. Im not getting any error message while using = but when i input something in textinput filter is not seems to work..

Was this reply helpful? Yes No
mdevaney 29,991 Moderator on at

Like (0)

Report
Copy link

Link copied!
What column type are these in your datasource?

RHCPRNO,
OAClientID,
FirstName,
LastName

Was this reply helpful? Yes No
neethup 52 on at

Like (0)

Report
Copy link

Link copied!

@mdevaney Hi.. First two ID fields are integers and Name fields are varchar

Was this reply helpful? Yes No
mdevaney 29,991 Moderator on at

Like (0)

Report
Copy link

Link copied!

@neethup
I am all out of ideas... it is strange that the equals operator does not work but IN does. Not sure if it is the data source or the app that is giving you problems.

Was this reply helpful? Yes No