Set(
var_superadmin,
If(
CountRows(
Filter(
User_Access_List,
Title = "Admin" && User.Email in MyProfile.mail
).ID
) > 0,
true,
false
)
);
Set(
var_normaluser,
If(
CountRows(
Filter(
User_Access_List,
Title = "Normal User" && User.Email = MyProfile.mail
)
) > 0,
true,
false
)
);
Set(
var_cdguser,
If(
CountRows(
Filter(
User_Access_List,
Title = "DG User" && User.Email in MyProfile.mail
)
) > 0,
true,
false
)
);
With(
{
_Data: Filter(
'Datasource',
ID > 0
)
},
SortByColumns(
Filter(
_Data,
var_normaluser && (User().Email in Team_Members.Email || 'Created By'.Email = User().Email || User().Email in 'Owner'.Email || User().Email in 'Manager'.Email || User().Email in 'Owner'.Email) && (Len(TextInputCanvas1.Value) = 0 || TextInputCanvas1.Value in Title || TextInputCanvas1.Value in 'Owner'.DisplayName || TextInputCanvas1.Value in 'Manager'.DisplayName) || (var_superadmin || var_cdguser) && (Len(TextInputCanvas1.Value) = 0 || TextInputCanvas1.Value in Title || TextInputCanvas1.Value in 'Owner'.DisplayName || TextInputCanvas1.Value in 'Manager'.DisplayName)
),
varsortcolumn,
varsortdirection
)
)