Hi All,
my PowerApps is connected to my SharePoint List with over 10000 records and growing. I added a search function using a flow automate to search through the whole SharePoint list.
The Search function works fine. It searches any text input without delegation issues thanks to the flow automate (SearchData.Run).
Next step is for the App to load all gallery items when the app loads.
At the App.OnStart , I added this code. "ClearCollect(colAssetsearch,ShowColumns('Assets',Barcode,Category_Class,Asset_type,Department,Location,Status,Condition))"
and get an error immediately on both this code and the button code.
the error is "invalid argument type" on the collection name colAssetsearch .
i noticed the issue comes from my choice columns. When i remove my choice columns from the OnStart function and leave the text columns, all the errors disappear. I have tried different iterations of adding choice columns, but the same error persists. Department,Location,Status,Condition are my choice columns.
I request help figuring out to load all gallery items at app startup and if you think the flow automate has an effect on the errors, I will gladly share the flow as well.
Button.OnSelect code:
ClearCollect(colAssetsearch,ForAll(Table(ParseJSON(SearchData.Run(TextInput3.Text).searchresult)),{Barcode:Text(Value.Barcode),Category_Class:Text(Value.Category_Class),Asset_type:Text(Value.Asset_type),Location:Text(Value.Location),Department:Text(Value.Department),Status:Text(Value.Status),Condition:Text(Value.Condition)}))
Gallery.Items: colAssetsearch
App.OnStart code:
ClearCollect(colAssetsearch,ShowColumns('Assets',Barcode,Category_Class,Asset_type,Department,Location,Status,Condition))
