You’re offline. This is a read only version of the page.
Hello,
I have my data collected from SharePoint in a local collection (using 'Clearcollect'). I would like then to search the Gallery (from the local collection) by column "Department" however it doesn't work as I believe the column contains data from a Combo Box. I have tried using different types .Selected.Value, Text("Column") etc, however no success. It works with other columns where the data type is simple text. See attached screenshots. I guess it will be a simple solution, however I cannot find it.
If somebody could help that would be brilliant.
Kind Regards,
Ivo
@Ajwou ,
Search is looking for a Text string - I have not tried it on a Choice field, but tend to use in anyway as it always works.
Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.
Brill, that's has worked. Yes, the Department field was Choice. I was actually trying .selected and .value in the 'Search' function but that didn't work. Please what is the reason for this not to work for Search option. I used it previously and had no issues (with labels and text only though)
Thank you for sharing the blog link. Will definitely go through the blog - seems like there is lots there :-).
Thanks again.
@Ajwou ,
What type of field is Department? If it is a Choice field, use Department.Value in both cases.
Please have a read of my blog on Controls and their references as it may be helpful to you.
Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.
Hi @WarrenBelz ,
Thank you for your suggestions. I tried both options given above, however none of them worked. See attached. I used Department with/without "" as well for both options but no luck. The filter/search won't return anything.
Hi @Ajwou ,
Delegable query
Share
Report
All responses (
Answers (
145,445
Filter(
SharePointData,
StartsWith(
Department,
TextSearchBox_1.Text
)
)Non-delegable but searches every part of field
Filter(
SharePointData,
TextSearchBox_1.Text in Department,
)
Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.
