Discrepency between form suggested values and test

[shimodabt]

I have a form with an Address field and other fields. 

One of the fields has a suggested values formula like this: 

 SORT(UNIQUE(SELECT(Adresse[Secteur ID],CONTAINS([Secteur ID],MID([_THISROW].[Adresse postale],FIND("QC ",[_THISROW].[Adresse postale])+3,3)))))

When I click TEST next to the formula field I get the expected result but when I look at the drop-down values from this field in the form after the Adresse field has been filled with a value I get a list of unexpected values.

What could I have overlooked? 

[Gustavo_Eduardo]

How are you? Have you tried it in the app but outside the editor?
Something similar has happened to me in the past but with lists of dates with a function created by @Joseph_Seddik. We concluded that the problem only occurred in the editor and not in the app. Can you try it?

[shimodabt]

Thanks @Gustavo_Eduardo for the tip. 

[Gustavo_Eduardo]

You are welcome!!!

[Steve · Accepted solution]

Is this an Enum column? If so, disable Auto-complete other values.

[shimodabt]

You're a master @Steve ! Thanks for the assist!