Why does my Search returns result from Gallery but Filter StartsWith does not?
I have made a List called Expense Record List (all in text columns to avoid delegation issues, no lookup, no choice, no calculated column). Data input is done in a Form in the PowerApp.
I have 2 galleries, 1st gallery is called Project List, 2nd Gallery is called Project Detailed Expense.
So, what result the user selects in the 1st gallery gets to set to a variable called varProjectExp.
I've tested it with a text label called Test_varProjectExp by text=varProjectExp, and it returns the correct value based on selection of the first gallery.
Then, in the 2nd gallery, Items should be displayed from the Expense Record List. based on the value of varProjectExp (which is the project name selected in the first gallery), this is done by varProjectExp= text values entered in a column called 'ProjectRelated' in the Expense Record List.
I've double checked my list setting that 'ProjectRelated column is indeed a Text column.
Now, my problem is, I can get result from the 2nd gallery when I put the following code by using Search in the gallery Item:
Search('Expense Record',varProjectExp,"ProjectRelated")
But, because this gives me delegation warning which is something I'm trying to avoid, so I went with Filter and StartsWith as shown below:
Filter('Expense Record',StartsWith("ProjectRelated",varProjectExp))
However, this code returns blank, it doesn't show any item matching to my filter.
The test TextLabel mentioned above Test_varProjectExp still returns the varProjectExp value which is one of the project's name present in the ProjectRelated column, and it's correct as Search function was showing the relevant item, but somehow my Filter and StartsWith just doesn't work......
Help anyone?
