Hi,
I have a list that gets filtered based on the logged in user and other criteria.
This is the current filter and sort function I have for my gallery:
Sort(Filter('UpgrClean_Archive_Allocated 20220214',TSR=varTSR, TSRSubmitted=false),Modified,Ascending)
However, my users would like to be able to search for specific items in the list, as the lists are quite large.
I've created a search box and set it up.
I'm having difficulty integrating it into my already filtered gallery.
I've tried adding this to my current code using the StartsWith function:
Sort(Filter('UpgrClean_Archive_Allocated 20220214',TSR=varTSR, TSRSubmitted=false,StartsWith(PolicyID,SearchPolicy.Text)),Modified,Ascending)
I have two problems with this:
1. I'm getting a delegation error (after I've just managed to get rid of all other delegation errors in my app!)
2. If the search field is left blank, I want it to show all items in the gallery. I understand that the 'StartsWith' function is therefore not going to work.
My brain is fried; please help. 🙂
