Share
Report
14so i have a gallery containing items from business central. i want to filter the data based on the user input search function. here is what i currently have on
items property of the gallery containing items
SortByColumns(Search('items (v2.0)_1',item_search_box_customer.Text,"displayName"),"inventory",Descending)
when i try to search it shows error like this
so i read here (https://powerusers.microsoft.com/t5/Building-Power-Apps/Error-on-filtering-Business-Central-s-data-in-PowerApps/td-p/211364) that says to collect it first so i did
clearCollect(allItems,itemsDatabase)
but it does not collect all the data from items database. so i read here (https://powerusers.microsoft.com/t5/Building-Power-Apps/Collection-not-collecting-all-columns/td-p/418763)that says to change the settings but it does not work.
can someone tell me how to filter search on business central ?
All responses (
Answers (
