I am new to Energy Apps and attempting to work out one thing which feels prefer it must be easy.
I’ve a display with a textual content field (
txtSearch) and an information desk (
tblCatalog). The info supply for the information desk is a SharePoint listing (
Catalog). I would like the desk to be filtered based mostly on whether or not the textual content within the search field seems in any of the columns (
Perform) within the desk.
I’ve tried setting the
OnChange motion for
Filter(Catalog, Title = txtSearch.Textual content), which is legitimate; however does not have an effect on what’s displayed within the desk.
I’ve additionally tried utilizing:
Search(Catalog, txtSearch.Textual content, Title ).
Search(tblCatalog, txtSearch.Textual content, Title ).
Filter(tblCatalog, colCatalogTitle = txtSearch.Textual content).
Nonetheless I get errors corresponding to “has some invalid arguments”. It appears the
Search operate expects a SQL desk / does not work with different knowledge sources or the Knowledge Desk element.
I’ve spent some time looking boards / tutorials, however cannot discover clear steering on how one would method tihs when not utilizing a SQL knowledge supply; any suggestions a lot appreciated.