I created the Group table to assign my contacts to groups, to be used in setting permissions later. However, I want a way to check to what Group the logged-in user or $[SYS_USER] belongs to so that I can use the Visibility option to show each group different content.
Thank you for your reply, however I need is to filter the tasks of this subset of contacts and not the contacts themselves. For example I want to show the tasks that are assigned to the same designation of the $[SYS_USER]. So if the $[SYS_USER] is a manager he will get all managers' tasks.
Based on my understanding of the app use case, I recommend the following but there could be other ways:
You will need to include the group information in the tasks table as well. So instead of using the contact format in the Tasks table, use picklist and set the source to the group memebership table. Once you have set that up, you can retrieve the group information of each user dynamically as follows:
User1 (rowlink from groups table)
Now, in the app you can do the following
Create a variable Group and set the value to: =Findrow(Users, "Users[Name]=$[SYS_USER])[Group]
and then set the list source to:
You can skip creating the variable but it helps with readability.