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:
Solved! Go to 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,
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
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,
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?
User | Count |
---|---|
258 | |
108 | |
95 | |
57 | |
40 |