Please note that visibility conditions are not a security feature. If you use them, the app can still download filtered or hidden data. If your app has private or sensitive data then you should use Row Owners. Learn more in our Security Center.
You can hide and show different tabs based on User Profile data. For example, if you have a look at this feature requests app below, you'll see 3 tabs.
The feature requests tab from a normal user's point of view
However, to allow administrators to process these feature requests we have two other tabs that have visibility conditions set on them. These tabs only show when the logged-in user's Admin property is TRUE.