
Hi,
In the dropdown field, I wrote this script
Sort(Distinct(Filter(source, "Manager" in Role), Display_Name.DisplayName), Value, SortOrder.Ascending)
but when I checked Allow Searching is giving me an error.
Unexpected character. The formula contains "Eof" 'ParentClose' is expected.
What am I doing wrong?
Sort(Distinct(Filter(CurrentAuctions, "M" in AuctionName), AuctionName),Value,SortOrder.Ascending)
Just tried this based on your code above and it worked for me without any errors other than the delegation warning due to using the 'in' function which is non delegable.
When I get an error like this that I am confident is in fact not an error my first 'fix' is to save the app and reload the browser. Power Apps gets lost sometimes and just needs to be refreshed to remember what its doing.