Hello,
I am unsure if this can be done but I have a Gallery I am using for a menu in my app. The item's property is my collection. My collection is:
ClearCollect(
colMenu,
{
MenuID: 1,
MenuName: "Home Screen",
MenuIcon: Icon,
ScreenToGoTo: HomeScreen
},
{
MenuID: 2,
MenuName: "Screen2",
MenuIcon: Icon,
ScreenToGoTo: Screen2
},
{
MenuID: 3,
MenuName: "Screen3",
MenuIcon: Icon,
ScreenToGoTo: Screen3
},
{
MenuID: 4,
MenuName: "Screen4",
MenuIcon: Icon,
ScreenToGoTo: Screen4
},
{
MenuID: 5,
MenuName: "Screen5",
MenuIcon: Icon,
ScreenToGoTo: Screen5
},
{
MenuID: 6,
MenuName: "Screen6",
MenuIcon: Icon,
ScreenToGoTo: Screen6
}
);
I want to make MenuID 2 visible only during September, January, and May. I also need to have MenuID 6 only visible to my "Admin" UserRole that I have set in my SharePoint. So far I can get one of these to work but not both. I have used these formulas separately in the Gallery Items Property:
Filter(
colMenu,If(
LookUp(
UserRoles,
UserEmailAddress = User().Email
).UserRole = "Admin",
true,
false
) || MenuID <> 6
)
Filter(
colMenu,
If(
Month(Today()) = 9 || Month(Today()) = 1 || Month(Today()) = 5,
true,
false
) || MenuID <> 2
)
Is there a way to do both of these in a Gallery?
Thanks for any help with this.
Collin
