Security Filter based on another Table

[Fabian_Weller]

I want to do the following:

• Open a prefilled form in Table1
• Force a sync
• Go to a form in Table2 to edit a specific row

In Table1 I set the Key value for the specific row in Table2.

This is working fine. But I would like to add a security filter in Table2 like:
[Key] = ANY(Table1[Key])
When I do this, it would need 2 syncs:

1. Save Table1
2. Fetch Table2 with the specific row

Here are the 4 sync steps. And I would expect that one sync would be enough: Saving Table1 and fetching Table2.