distinct filter is not showing my option when I edit in the form

[Gorilla_8]

I have a gallery that pulls the data and saves it correctly in the database, but when pulling the edit form it is not displayed correctly

Here is my code:

My database is SharePoint and the column is a single line text

Items property:

Distinct(Filter(MycollectionNameHere;  AREA<> Blank() /*"NULL"*/);AREA).Result

DefaultSelectedItems:

{Value:LookUp(MycollectionNameHere;NOME=ComboBox1_38.Selected.Result).AREA}

Why is this happening?

[WarrenBelz]

@Gorilla_8 ,

I think you need

{
   Result:
   LookUp(
      MycollectionNameHere;
      NOME=ComboBox1_38.Selected.Result
   ).AREA
}

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps

[Gorilla_8]

@WarrenBelz 

The result is only blank

[WarrenBelz]

@Gorilla_8 ,

That is the correct code according to what you posted. I suspect your Lookup is not valid. Please do some trouble shooting on this basis.