StartsWith syntax

[karl_oliverio]

I am trying to create a filter in gallery using StartsWith but I am having an error with a column from my datasource (Sharepoint Library). The column "BU Scope" that i want to use is a lookup field.

When i try to use the field "BU Scope" it returns an error message like this:

[RezaDorrani]

Hi @karl_oliverio 

Try BU_x0020_Scope.Value since it is a lookup column

Regards,

Reza Dorrani

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[v-xida-msft · Accepted solution]

Hi @karl_oliverio ,

Is the "BU Scope" column a LookUp type column in your SP Library?

Based on the formula that you mentioned, I think there is something wrong with it. The first argument of the StartsWith function is required to provide a Text type column. The LookUp column (Complex type column) is not supported within StartsWith function.

As an alternative solution, please consider take a try with the following workaround:

Set the Items property of the Gallery to following:

Filter(
         AddColumns('YourSPLibrary', "BUScopeValue", BU_x0020_Scope.Value),
         StartsWith(BUScopeValue, TextInput1_2.Text)
)

Please consider take a try with above solution, check if the issue is solved.

Best regards,

[karl_oliverio]

Thanks @v-xida-msft it works for me. I made the field dropdown instead of textfield, now im having a problem because when the app loads, it automatically filters the gallery based on the default value on my dropdown. How can I clear the value of the dropdown on page load?