item property works in gallery but not modern table (preview)

(1) Share

Report

Posted on by MrKoh

Hi, I have the below code where I am filtering table1 excel based on logged on user email, The below codes in item property for gallery but when I input it in a modern table (preview). The table won't display anything.

With(
 {
 Combined:Filter(Table1,
 Or(
 LookUp('[Test] Sharepoint List','Report ID'=ReportId).Status.Value = TabList2_6.Selected.Value, 
 TabList2_6.Selected.Value = "All"
 ) 
 )
 },
	Filter(
	Search(
	Combined,
 txtSearchTitle_8.Text,ReportName),UserId = User().Email)
)

Although I noticed the code seems to work with 97 rows data but the table is not displaying anything. Can refer to my sample image for for the result