Table view not showing all slice data

[Sebastian_Hol]

Hi all,

This is the situation: I do have a slice with a row filter condition. If I take a look on "View Data" of this particular slice, the corret filtered datasets are visible. 

If I put this slice in a simple table view, only a few datasets are visible. How can it be, that these views show different information, without any further filtering?

Regards,

Sebastian

[1minManager]

I can't think of any obvious reasons.  Can you share those two data view and the slice formula?

[Sebastian_Hol]

Hi 1minManager,

This is the slieces' output of "Data view" :

This is how it looks in the table view:

Only one item is visible.

The filter of the slice is: 

The result of the Lookup is an Enum List with different items.

[Sebastian_Hol]

One addition:

this is the content of field [fldPlants]

[1minManager]

So my first guess is its caused by the UserEmail() within the slice formula.  I've seen this before in other parts of Appsheet.  My hunch is that in Data View UserEmail() is returning BLANK because, like bots running on a schedule, its not running as a logged in user.

Try changing UserEmail() to "your email" and see if this now works as expected

[Sebastian_Hol]

Just tried what you suggested. The result is the same. There are two plants in the Enum list associated with my mail-adress. The slice Data view shows records to both plants, the table view only for one plant.

[Sebastian_Hol · Accepted solution]

Problem solved. The lookup part is now moved to the security filter of the table. Now it is working.

Thanks for your help anyway!!