Answered

Filter for Exact matches only when a radio button is selected

(0) Share

Report

Posted on by Community Power Pla...

I have the following filtering based on 3 fields.

The search is automatically doing what I call a wildcard search.

If I select a radio button "Radio1" control...say option 1 , I need the filter to do only a Exact Match Search ? on the term in

FilterTextBox Box

Current Code:

Filter('[dbo].[v_sst_source_select_search]',
FilterTextBox.Text in Brand
Or FilterTextBox.Text in Supplier_Name
Or FilterTextBox.Text in Supplier_Number
)

Thanks

David Powell

Categories:

Building Power Apps

I have the same question (0)

All responses (11)

Answers (1)

mdevaney 29,989 Moderator on at

Like (1)

Report

@Anonymous
You can replace in with exactin to get the desired result.

Filter('[dbo].[v_sst_source_select_search]',
FilterTextBox.Text exactin Brand
Or FilterTextBox.Text exactin Supplier_Name
Or FilterTextBox.Text exactin Supplier_Number
)

—-
Please Accept as Solution if this post answered your question so others may find it more quickly. If you found this post helpful consider giving it a Thumbs Up.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

what about the addition of the radio button?

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

Like (0)

Report
@Anonymous

Good point. I missed that requirement.

Filter('[dbo].[v_sst_source_select_search]', RadioButton1.Value = "Brand" And FilterTextBox.Text exactin Brand RadioButton2.Value = "Supplier_Name" And Or FilterTextBox.Text exactin Supplier_Name RadioButton3.Value = "Supplier_Number" And Or FilterTextBox.Text exactin Supplier_Number )

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

@mdevaney,
went with a toggle object....so ?
If(Toggle1.Value = false,
Filter('[dbo].[v_sst_source_select_search]',
    FilterTextBox.Text in Brand
    Or FilterTextBox.Text in Supplier_Name
Or FilterTextBox.Text in Supplier_Number
)
,Filter('[dbo].[v_sst_source_select_search]',
    FilterTextBox.Text exactin Brand
    Or FilterTextBox.Text exactin Supplier_Name
Or FilterTextBox.Text exactin Supplier_Number
)
)

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

Like (0)

Report
@Anonymous

I see what your goal is now. I misunderstood before...

You have the right idea but we should try to avoid using the IF statement because it will give a delegation warning. Here's my proposal.

Filter('[dbo].[v_sst_source_select_search]', (Toggle1.Value = true And FilterTextBox.Text exactin Brand) Or (Toggle1.Value = true And Or FilterTextBox.Text exactin Supplier_Name) Or (Toggle1.Value = true And Or FilterTextBox.Text exactin Supplier_Number) Or (Toggle1.Value = false And FilterTextBox.Text in Brand) Or (Toggle1.Value = false And FilterTextBox.Text in Supplier_Name) Or (Toggle1.Value = false And FilterTextBox.Text in Supplier_Number) )

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

THE And Or part of the code is giving it fits.

also...I'm using sql server, so I hope no delegation issues.

DAVID

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

Like (0)

Report

@Anonymous

I don't understand "it gives me fits". You'll have to show me what you mean.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

@mdevaney

sorry, its an error message...
but also, I was reading "exactin" documentation. that is used for Capitalization searches or non-capital searches.
By Exact I mean, If i'm looking for "Columbia Pipe" (regardless of caps or not) it will only find "Columbia Pipe"
other wise if I search for "Columbia" it will also Find "Columbia pipe"

Thanks
David

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

Like (0)

Report
@Anonymous

Wow, I did not know that about exactin. I guess it makes sense. If we want the exact value we should just use an equals sign instead of exactin.

Filter('[dbo].[v_sst_source_select_search]', (Toggle1.Value = true And FilterTextBox.Text = Brand) Or (Toggle1.Value = true Or FilterTextBox.Text = Supplier_Name) Or (Toggle1.Value = true Or FilterTextBox.Text = Supplier_Number) Or (Toggle1.Value = false And FilterTextBox.Text in Brand) Or (Toggle1.Value = false And FilterTextBox.Text in Supplier_Name) Or (Toggle1.Value = false And FilterTextBox.Text in Supplier_Number) )

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

this part it did not like

Or (Toggle1.Value = true And Or FilterTextBox.Text = Supplier_Name)
    Or (Toggle1.Value = true And Or FilterTextBox.Text = Supplier_Number)

so I changed it to:
Filter('[dbo].[v_sst_source_select_search]',
    (Toggle1.Value = true And FilterTextBox.Text = Brand)
    Or (Toggle1.Value = true And FilterTextBox.Text = Supplier_Name)
    Or (Toggle1.Value = true And FilterTextBox.Text = Supplier_Number)
    Or (Toggle1.Value = false And FilterTextBox.Text in Brand)
    Or (Toggle1.Value = false And FilterTextBox.Text in Supplier_Name)
    Or (Toggle1.Value = false And FilterTextBox.Text in Supplier_Number)
)

Thanks
working now !!

David

Was this reply helpful? Yes No