Works great! This was the first thing I figured out after I saw you use the embedded table on office hours. Important to note that doing it this way the search only looks at one field. If you create a table analytic and search from there, it looks at all fields, but analytics I’ve created this way appear to be limited to 1000 records.
that’s a great idea, hadn’t thought of adding search on Embedded Analyses.
with regards to the limit of 1,000 rows, I have just submitted a ticket to our engineering team to review increasing this limit. we’ll keep you posted if this is something we will indeed be doing!!
This is great idea Gio! Only thing I would say is, is there a way to make it so you don’t have to search for an item exactly as its written in the table? (e.g. not case sensitive)
Thanks heaps!
hello @mattsaun, great to hear you found this useful!!
to solve the question you’re facing, you could add a Button Trigger (or Timer Trigger) to format the search query by the formatting rules you need. in this example, the text that the User inputs is automatically capitalized: uppercase(left(@Variable.Search Query , 1)) + lowercase(right(@Variable.Search Query , len(@Variable.Search Query ) - 1))
Thanks again for responding so fast Gio, time difference between us gets me with responding quickly but I do see your tips so I appreciate it! Definitely will employ this in my search filter for quality of life improvements.