Unanswered

Searching text fields not able to find comment field.

(0) Share

Report

Posted on by rroque

350

I can't seem to find the correct syntax to search comment field. The function cannot find the comment field below. This is a single line text. Any help would be greatly appreciated.

Here's the code in question.

Filter(OPTrack_FormsInventoryEnhancedTables, txtSearch.Text in FORM_NO || Text(dteReqDate.SelectedDate) in REQ_DATE
|| Text(dteReqDate.SelectedDate) in LAST_INVEN || txtComment.Text in COMMENT);

Categories:

Building Power Apps

All responses (9)

Answers (0)

Sort by

anandm08 1,936 Super User 2024 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!
hi @rroque ,
there might be potential issues like case sensitivity or exact match requirements. Some systems might require an exact match, meaning that if txtComment.Text contains "hello", it will only match a COMMENT field that contains "hello" exactly and not "Hello" or "hello there".
Here's how you might adjust the syntax:

Lower(txtComment.Text) in Lower(COMMENT)
rroque 350 on at

Like
a
(0)

Report
Copy link

Link copied!

Here are the advanced properties.
rroque 350 on at

Like
a
(0)

Report
Copy link

Link copied!

Also the lower example isn't delegable.
rroque 350 on at

Like
a
(0)

Report
Copy link

Link copied!

@anandm08 Thank you for the lower code. I tried the lower code and it is not finding my comment field.
rroque 350 on at

Like
a
(0)

Report
Copy link

Link copied!

Here's the revised code. I included you lower instruction code.
Filter(OPTrack_FormsInventoryEnhancedTables, txtSearch.Text in FORM_NO || Text(dteReqDate.SelectedDate) in REQ_DATE
|| Text(dteReqDate.SelectedDate) in LAST_INVEN || Lower(txtComment.Text) in Lower(COMMENT));
rroque 350 on at

Like
a
(0)

Report
Copy link

Link copied!

hi @anandm08

Here's the revised code.

Filter(OPTrack_FormsInventoryEnhancedTables, txtSearch.Text in FORM_NO || Text(txtSearch.Text) in REQ_DATE
|| Text(txtSearch.Text) in LAST_INVEN || Lower(txtSearch.Text) in Lower(COMMENT));
anandm08 1,936 Super User 2024 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!
Filter( OPTrack_FormsInventoryEnhancedTables, txtSearch.Text in Text(FORM_NO) || txtSearch.Text in Text(REQ_DATE) || txtSearch.Text in Text(LAST_INVEN) || Lower(txtSearch.Text) in Lower(COMMENT) )
try this
rroque 350 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @anandm08 thx again. I tried your code but no difference. I don't know what else I can check.
Revised code.
Filter(
OPTrack_FormsInventoryEnhancedTables,
txtSearch.Text in Text(FORM_NO) ||
txtSearch.Text in Text(REQ_DATE) ||
txtSearch.Text in Text(LAST_INVEN) ||
Lower(txtSearch.Text) in Lower(COMMENT)
)
rroque 350 on at

Like
a
(0)

Report
Copy link

Link copied!

Yes I did found the problem and fixed it.
The fix was to add the comment field to the items property of the list. Thank you.