Textsearchbox using created by from SP List

[djreyes1110]

Hello, 

How do I write a function if the search field that I would like to add is the person who created the response (CREATED BY).

Thank you!

[Ramole]

Hi @djreyes1110 
I did not see your control but you changed to requirements here is the simple code to use 

Filter(
        Data Source,
        (galFilter__Checks.Selected.Value="All" || Status.Value = galFilter__Checks.Selected.Value) &&
        AssignedTo = User().Email && StartsWith('Business Name',TextInput4.Text))

[djreyes1110]

Hi, 

I am getting an error. I only changed the data source and text input.

Filter('Request Form: Fleet', (galFilter__Checks.Selected.Value="All" || Status.Value = galFilter__Checks.Selected.Value) && AssignedTo = User().Email && StartsWith('Business Name',TextSearchBox1))

What is a galfilter?

[Ramole]

@djreyes1110 
You will need to change all control names to your control names, show me your SharePoint list field names and I will happy to amend for you please take a screenshot

[djreyes1110]

Please see attached. created by is set up as person in SP list.

[Ramole]

@djreyes1110 
I have simple for you 

Filter('Request Form Fleet','Created By'.Email = User().Email && StartsWith(CompanyName,SearchTextInput.Text))

CompanyName is what field do you wanted to search by like title so changed to field name     

SearchTextInput is an text input you need to add one and name SearchTextInput

[Ramole]

@djreyes1110 
Just change the SearchTextInput to the name of the search you have in the screen

Filter('Request Form Fleet','Created By'.Email = User().Email && StartsWith('Operation Name',SearchTextInput.Text))

[djreyes1110]

This is the error I ma getting.

[Ramole]

@djreyes1110 
You have an extra parenclose show me the code you have so i can see it how you put

[djreyes1110]

I did but the test responses are not showing.