Filter list no working

[Alan_Martins]

Hi team, i´m using this template to do a Multi-Search, but the list of reference not working, i´m receiving the Map view

the template is: https://www.appsheet.com/Template/AppDef?appName=Multi-SearchDemo-675786#Data.Columns

Result:

This is my Formula:
FILTER(“PROJETOS”, **
** AND(
** OR( ISBLANK([_THISROW].[PROJETO]) , CONTAINS([PROJETO] ,[_THISROW].[PROJETO]) ),**
** OR( ISBLANK([_THISROW].[STATUS]) , CONTAINS([STATUS] ,[_THISROW].[STATUS]) )**
** )**
)

My result in map view

Who can help me?

[LeventK]

Try with removing [_THISROW] de-ref from your column names

[LeventK]

@Alan_Martins
Also you can try with this

FILTER(
    "PROJETOS",
	AND(
		OR(
			ISBLANK([PROJETO]),
			CONTAINS([_THISROW].[PROJETO],[PROJETO])
		),
		OR(
			ISBLANK([STATUS]),
			CONTAINS([_THISROW].[STATUS],[STATUS])
		)
    )
)

[Alan_Martins]

UPDATE!

The results changed but no in list yet

I used this formula : FILTER(“PROJETOS”,
AND(
OR( ISBLANK([_THISROW].[PROJETO]) , CONTAINS([PROJETO] ,[_THISROW].[PROJETO]) ),
OR( ISBLANK([_THISROW].[STATUS]) , CONTAINS([STATUS] ,[_THISROW].[STATUS]) )
)
)

My reference is this results view in list

How can i change the results view to list?

[Steve]

Alan_Martins:

How can i change the results view to list?

What do you mean by this? Please elaborate.

[Alan_Martins]

Hi Steve,

I need to see the “results” in list, just it.

[Steve]

Still not entirely clear what you mean by “results”. The table appears to be “results” to me. But if you just want a flat list of the individual codes, try changing the column type from List to EnumList.

[Alan_Martins]

Hi Steve, i changed to Enumlist type but not work.

PS:
to be clearer or what I need is for the view to be presented as a table as in the example and not as a list

Like the left (green) exemplo:
Staus / Date / Name

[Steve · Accepted solution]

Oh, I see the problem.

First, revert the EnumList back to List.

Then, create a new view of type table in the ref position for the Projectos table or slice. That view will govern the display of the results.

[Alan_Martins]

Hi Steve!! Working perfect!!

Solution: I created a new view in the table formate

Thanks!

[Alan_Martins]

Hi team,

I´m Trying to create a second view but i didn´t receive the same list results

Could you help me?