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

I have the same question (0)

All responses (9)

Answers (0)

anandm08 1,936 Super User 2024 Season 2 on at

Like (0)

Report
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)

Was this reply helpful? Yes No
rroque 350 on at

Like (0)

Report

Here are the advanced properties.

Was this reply helpful? Yes No
rroque 350 on at

Like (0)

Report

Also the lower example isn't delegable.

Was this reply helpful? Yes No
rroque 350 on at

Like (0)

Report

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

Was this reply helpful? Yes No
rroque 350 on at

Like (0)

Report

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));

Was this reply helpful? Yes No
rroque 350 on at

Like (0)

Report

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));

Was this reply helpful? Yes No
anandm08 1,936 Super User 2024 Season 2 on at

Like (0)

Report
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

Was this reply helpful? Yes No
rroque 350 on at

Like (0)

Report

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)
)

Was this reply helpful? Yes No
rroque 350 on at

Like (0)

Report

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.

Was this reply helpful? Yes No