Here's an updated version of the code that you can use to filter the gallery based on the selected table, the text entered in the input text, and the current user's email:
Items = If(Dropdown.SelectedText.Value = "Table1",
Filter(Table1, User.Email = varUserEmail && Save = true, Search(Table1,TextInput.Text,"Column1","Column2","Column3")),
If(Dropdown.SelectedText.Value = "Table2",
Filter(Table2, User.Email = varUserEmail && Save = true, Search(Table2,TextInput.Text,"Column1","Column2","Column3")),
If(Dropdown.SelectedText.Value = "Table3",
Filter(Table3, User.Email = varUserEmail && Save = true, Search(Table3,TextInput.Text,"Column1","Column2","Column3")),
If(Dropdown.SelectedText.Value = "Table4",
Filter(Table4, User.Email = varUserEmail && Save = true, Search(Table4,TextInput.Text,"Column1","Column2","Column3")),
{}
)
)
)
)
In this code, the Items property of the gallery is set based on the selected table in the dropdown. The Filter function filters the selected table based on the current user's email (varUserEmail) and the Save column set to true. The Search function is then used to search the filtered list based on the text entered in the input text. The If function is used to handle the different possible values of the selected table in the dropdown.
