Private Data not properly displaying in the app - Multiple private sheets with dup data

[WillowMobileSys]

I am creating an app where users add and review their data privately.  There is some basic Public data the users start with.  The users will then select certain items that they interact with privately.  These tables are set as "as app user" (see image)

For those who don't know, this setting will generate a sheet - one for each table - under the app user Google account into which the private data is written.

EDITED:  This first part is resolved. I realized I had improper Show expressions.  I am leaving here so others may benefit from my mistake.

I am finding that, although data is being written into the private sheet, it is NOT being displayed in the app - on neither a mobile device nor in Browser.

This seems to be a bug.  Does anyone know why this might be happening and if there is something I need to do to correct?

EDITED:  This one below is still a concern

As a secondary concern, it appears that the data for each private table is written to its own sheet file.  HOWEVER, each private sheet file has a duplicate copy of ALL the source datasheets.  This seems unnecessary.  Is this another bug?

Example of individual private data tables - 6 shown

Each sheet file has ALL source data tables replicated

[AleksiAlkio · Accepted solution]

The reason is probably coming from your gSheet structure. Please check this.. https://support.google.com/appsheet/answer/10106508?hl=en&sjid=10833167265607916102-EU#:~:text=A%20p....

[WillowMobileSys]

I see. I admittedly skimmed that part and missed it.

So a Private Table sheet must live in its OWN file.  It cannot be combined with the Public Table sheets nor any other Table sheets. 

Good to know but a bit inconvenient from a management perspective.  It is what it is!

[AleksiAlkio]

Yes that's true.