cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Post Prodigy
Post Prodigy

Search In versus StartsWith Issue

Hello,

 

I am in the process of beta testing my app. I had originally used a StartsWith search formula for the sake of avoiding delegation issues, but users are finding it too limiting as they often don't know the specific name of what they are searching for. Since this list is unlikely to have more than 500 items, much less 2000, I think it is reasonable to change the Search command to "in", but I can't get it working. 

 

Here is the original StartsWith formula that was working:

 

Filter('Tool Design Support Requests',
StartsWith('Request Summary Title', TxtSearchBox.Text)
),

 

Here is the Search formula that I am struggling with:

 

            Filter('Tool Design Support Requests',

                TxtSearchBox.Text in "Title"

            ),

 

Title is the internal name of the column. I've also tried the Display Name which is "Request Summary Title". Can you please help me figure out where I am going wrong? Let me know if you need any other details for the sake of troubleshooting.

 

Thank you,

Teresa

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User III
Super User III

@tagustin2020 

You can go one of two ways.

1) Change your formula to the following:

Filter('Tool Design Support Requests',
    TxtSearchBox.Text in Title
)

(removing the quotes from around Title)

 

2) User the Search function:

Search('Tool Design Support Requests',
    TxtSearchBox.Text, Title
)

Either should get you to where you want to be.

 

I hope this is helpful for you. 

_____________________________________________________________________________________
Digging it? - Click on the Thumbs Up. Solved your problem? - Click on Accept as Solution. Others seeking the same answers will be happy you did.
Check out my PowerApps Videos too!

View solution in original post

2 REPLIES 2
Highlighted
Super User III
Super User III

@tagustin2020 

You can go one of two ways.

1) Change your formula to the following:

Filter('Tool Design Support Requests',
    TxtSearchBox.Text in Title
)

(removing the quotes from around Title)

 

2) User the Search function:

Search('Tool Design Support Requests',
    TxtSearchBox.Text, Title
)

Either should get you to where you want to be.

 

I hope this is helpful for you. 

_____________________________________________________________________________________
Digging it? - Click on the Thumbs Up. Solved your problem? - Click on Accept as Solution. Others seeking the same answers will be happy you did.
Check out my PowerApps Videos too!

View solution in original post

Highlighted

Thanks Randy! It's working like a charm now. You are a lifesaver!

 

T

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

News & Announcements

Community Blog

Stay up tp date on the latest blogs and activities in the community News & Announcements.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Community Highlights

Community Highlights

Check out the Power Platform Community Highlights

Top Solution Authors
Top Kudoed Authors
Users online (7,696)