oh ok,
App.OnStart code:
Set(var2, Office365Users.MyProfileV2().mail);
Set(var1, LookUp('App Users', User.Email=var2));
Set(varRole, var1.Role.Value);
Switch(
varRole,
"SA",
Set(
varList,
Filter(
'Invoice()',
Creator.DisplayName = User().FullName
)
),
"AR",
Set(
varList,
Filter(
'Invoice()',
'Assign to:Email'.Value = Office365Users.MyProfileV2().mail
)
),
"Translator",
Set(
varList,
Filter(
'Invoice()',
'Translation Status'.Value = "Needs translation" || 'Translation Status'.Value = "Translated"
)
),
"Manager",
Set(
varList,
Filter(
'Invoice()',
'Invoice Status'<> "Invoice Paid"
)
),
Set(
varList,
'Invoice()'
)
);
this is to get what is the user's Role and set the table for the gallery
Gallery item code :
//For Sorting button
SortByColumns(
// Search Bar
Search(
Filter(
varList,
IsBlank(cbName.SelectedItems.'Customer Name') || IsEmpty(cbName.SelectedItems.'Customer Name') || 'Customer Name' in cbName.SelectedItems,
IsBlank(cbMaster.SelectedItems.'Master Project') || IsEmpty(cbMaster.SelectedItems.'Master Project') || 'Master Project' in cbMaster.SelectedItems,
IsBlank(cbStatus.SelectedItems) || IsEmpty(cbStatus.SelectedItems) || 'Invoice Status' in cbStatus.SelectedItems,
IsBlank(cbGroup.SelectedItems.Value) || IsEmpty(cbGroup.SelectedItems.Value) || 'Customer Group' in cbGroup.SelectedItems
),
TextSearchBox.Text,
"InvoiceNumber"
),
"BillingDate",
varSort
);
this gallery have filter, search, and sorting
