Visibility control in MenuItems

[RvdHeijden]

Good day,

Is it possible to limit the amount of items in a Menu based on the persons Emailadres ?

I've done something similar based on specific tiles but when I open my Menu all of the items are still in there but how do I incorporate a check based on Emailadres to determine if a person can see a certain item ?

Table(
    {
        MenuLabel: "Home"; 
        MenuIcon: Icon.Home; 
        MenuScreenNavigate: App.ActiveScreen;
        MenuID:1;
        SubMenu: Table()
    };
    {
        MenuLabel: "Project A"; 
        MenuIcon: Icon.DetailList; 
        MenuScreenNavigate: 'Project A';
        MenuID:2;
        SubMenu: Table()
    };
    {
        MenuLabel: "Project B"; 
        MenuIcon: Icon.DetailList; 
        MenuScreenNavigate: 'Project B';
        MenuID:3;
        SubMenu: Table()
    };
    {
        MenuLabel: "Project C"; 
        MenuIcon: Icon.DetailList; 
        MenuScreenNavigate: 'Project C';
        MenuID:4;
        SubMenu: Table()
    };
    {
        MenuLabel: "Project D"; 
        MenuIcon: Icon.DetailList; 
        MenuScreenNavigate: 'Project D';
        MenuID:5;
        SubMenu: Table()
    };
    {
        MenuLabel: "Project E"; 
        MenuIcon: Icon.DetailList; 
        MenuScreenNavigate: 'Project E';
        MenuID:6;
        SubMenu: Table()
    };
    {
        MenuLabel: "Project F"; 
        MenuIcon: Icon.DetailList; 
        MenuScreenNavigate: 'Project F';
        MenuID:7;
        SubMenu: Table()
    };
    {
        MenuLabel: "Project G"; 
        MenuIcon: Icon.DetailList; 
        MenuScreenNavigate: 'Project G';
        MenuID:8;
        SubMenu: Table()
    };
    {
        MenuLabel: "Project H"; 
        MenuIcon: Icon.DetailList; 
        MenuScreenNavigate: 'Project H';
        MenuID:9;
        SubMenu: Table()
    }
)

[RvdHeijden]

The error is gone, that was my mistake I misplaced a ; somewhere 😉

But I'm still seeing all the menu items and my Visible property for the menu is set to true and I'm not sure what you mean by putting the IsVisible property in there so can you tell me what to do ?

[RvdHeijden]

@zmorek any ideas ?

[EddieE]

@RvdHeijden 

Just wrap your entire gallery items in a Filter, ie

Filter( Table( …), IsVisible )

@zmorek has set this up so something like this should work.

[RvdHeijden]

Something like this ? @EddieE 

I think I'm doing something wrong because this doesn't work

Filter(
   Table(
    {
        MenuLabel: "Home"; 
        MenuIcon: Icon.Home; 
        MenuScreenNavigate: App.ActiveScreen;
        MenuID:1;
        SubMenu: Table()
    };
    {
        MenuLabel: "Project A"; 
        MenuIcon: Icon.DetailList; 
        MenuScreenNavigate: 'Project A';
        MenuID:2;
        SubMenu: Table()
    };
    {
        MenuLabel: "Project B"; 
        MenuIcon: Icon.DetailList; 
        MenuScreenNavigate: 'Project B';
        MenuID:3;
        SubMenu: Table()
    };
    {
        MenuLabel: "Project C"; 
        MenuIcon: Icon.DetailList; 
        MenuScreenNavigate: 'Project C';
        MenuID:4;
        SubMenu: Table()
    };
    {
        MenuLabel: "Project D"; 
        MenuIcon: Icon.DetailList; 
        MenuScreenNavigate: 'Project D';
        MenuID:5;
        SubMenu: Table()
    };
    {
        MenuLabel: "Project E"; 
        MenuIcon: Icon.DetailList; 
        MenuScreenNavigate: 'Project E';
        MenuID:6;
        SubMenu: Table()
    };
    {
        MenuLabel: "Project F"; 
        MenuIcon: Icon.DetailList; 
        MenuScreenNavigate: 'Project F';
        MenuID:7;
        SubMenu: Table()
    };
    {
        MenuLabel: "Project G"; 
        MenuIcon: Icon.DetailList; 
        MenuScreenNavigate: 'Project G';
        MenuID:8;
        SubMenu: Table()
    };
    {
        MenuLabel: "Project H"; 
        MenuIcon: Icon.DetailList; 
        MenuScreenNavigate: 'Project H';
        MenuID:9;
        SubMenu: Table()
    }
);IsVisible)

[RvdHeijden]

@EddieE or @zmorek  or @timl can one of you guys help me fix this issue ?

[EddieE]

@RvdHeijden 

The last code structure you posted won't work because you are trying to filter a table on a field that doesn't exist in that table ie 'IsVisible'.

What you need to do is decide which Projects are to be visible to Team A and which to Team B then add the IsVisible field into your code.

I assume you still have this code (or similar) in the App OnStart?

Set(varUserEmail; User().Email);
Set(varProjectTeamA; ["EmailA";"EmailB";"EmailC"]);
Set(varProjectTeamB; ["EmailZ";"EmailX";"EmailY"])

Then you adjust your last code snippet to (Note: I assume here that everyone can see 'Home'):

Filter(
   Table(
    {
        MenuLabel: "Home"; 
        MenuIcon: Icon.Home; 
        MenuScreenNavigate: App.ActiveScreen;
        MenuID:1;
        SubMenu: Table()
    };
    {
        MenuLabel: "Project A"; 
        MenuIcon: Icon.DetailList; 
        MenuScreenNavigate: 'Project A';
        MenuID:2;
        SubMenu: Table();
		IsVisible: varUserEmail in varProjectTeamA
    };
    {
        MenuLabel: "Project B"; 
        MenuIcon: Icon.DetailList; 
        MenuScreenNavigate: 'Project B';
        MenuID:3;
        SubMenu: Table();
		IsVisible: varUserEmail in varProjectTeamA
    };
    {
        MenuLabel: "Project C"; 
        MenuIcon: Icon.DetailList; 
        MenuScreenNavigate: 'Project C';
        MenuID:4;
        SubMenu: Table();
		IsVisible: varUserEmail in varProjectTeamA
    };
    {
        MenuLabel: "Project D"; 
        MenuIcon: Icon.DetailList; 
        MenuScreenNavigate: 'Project D';
        MenuID:5;
        SubMenu: Table();
		IsVisible: varUserEmail in varProjectTeamA
    };
    {
        MenuLabel: "Project E"; 
        MenuIcon: Icon.DetailList; 
        MenuScreenNavigate: 'Project E';
        MenuID:6;
        SubMenu: Table();
		IsVisible: varUserEmail in varProjectTeamA
    };
    {
        MenuLabel: "Project F"; 
        MenuIcon: Icon.DetailList; 
        MenuScreenNavigate: 'Project F';
        MenuID:7;
        SubMenu: Table();
		IsVisible: varUserEmail in varProjectTeamB
    };
    {
        MenuLabel: "Project G"; 
        MenuIcon: Icon.DetailList; 
        MenuScreenNavigate: 'Project G';
        MenuID:8;
        SubMenu: Table();
		IsVisible: varUserEmail in varProjectTeamB
    };
    {
        MenuLabel: "Project H"; 
        MenuIcon: Icon.DetailList; 
        MenuScreenNavigate: 'Project H';
        MenuID:9;
        SubMenu: Table();
		IsVisible: varUserEmail in varProjectTeamB
    }
);IsVisible)

** It's up to you to make changes to the IsVisible fields to ensure which Projects are visible to which Team, I've just made some assumptions here.

Then,

- go to the App OnStart and add your email address to Project A team list of emails

- rerun the OnStart code

- check you can only see the Menu items where varUserEmail in varProjectTeamA is true

- repeat for Project Team B (remember to remove your email from Team A list)

If this solves your issue please select multiple responses that have solved this for you because it has been a team effort 🙂

[RvdHeijden]

@EddieE your solution seems to work but I'm facing a strange problem because the formula is good (no red lines or anything) but it still displays a red cross stating that it is expecting an operator, eventhough the formula itself doesn't display any red lines ?

[EddieE]

@RvdHeijden 

Probably a missing ‘)’ or ‘;’ somewhere mate. I just copied your code and add the IsVisible parts, didn’t check for syntax errors.

If you can’t find it, post your code and I can have a quick look

[RvdHeijden]

@EddieE I've checked the complete syntax and can't find anything wrong and there are no red lines so the error is very strange but here is my code

Filter(
    Table(
    {
        MenuLabel: "Home"; 
        MenuIcon: Icon.Home; 
        MenuScreenNavigate: App.ActiveScreen;
        MenuID:1;
        SubMenu: Table()
    };
    {
        MenuLabel: "DG609 Tholen en Reimerswaal"; 
        MenuIcon: Icon.DetailList; 
        MenuScreenNavigate: 'DG609 Tholen en Reimerswaal';
        MenuID:2;
        SubMenu: Table();
        IsVisible: varUserEmail in varProjectTeamCorne Or varUserEmail in varFinancieelTeam
    };
    {
        MenuLabel: "DG610 Arnemuiden Sint Joosland"; 
        MenuIcon: Icon.DetailList; 
        MenuScreenNavigate: 'DG610 Arnemuiden Sint Joosland';
        MenuID:3;
        SubMenu: Table();
        IsVisible: varUserEmail in varProjectTeamCorne Or varUserEmail in varFinancieelTeam
    };
    {
        MenuLabel: "DG611 Rozenburg"; 
        MenuIcon: Icon.DetailList; 
        MenuScreenNavigate: 'DG611 Rozenburg';
        MenuID:4;
        SubMenu: Table();
        IsVisible: varUserEmail in varProjectTeamCorne Or varUserEmail in varFinancieelTeam
    };
    {
        MenuLabel: "DG617 Middelburg Zuid-West"; 
        MenuIcon: Icon.DetailList; 
        MenuScreenNavigate: 'DG617 Middelburg Zuid-West';
        MenuID:5;
        SubMenu: Table();
        IsVisible: varUserEmail in varProjectTeamCorne Or varUserEmail in varFinancieelTeam
    };
    {
        MenuLabel: "DG659 Gemeente Veere"; 
        MenuIcon: Icon.DetailList; 
        MenuScreenNavigate: 'DG659 Gemeente Veere';
        MenuID:6;
        SubMenu: Table();
        IsVisible: varUserEmail in varProjectTeamCorne Or varUserEmail in varFinancieelTeam
    };
    {
        MenuLabel: "DG686 Vlissingen Centrum-Noord"; 
        MenuIcon: Icon.DetailList; 
        MenuScreenNavigate: 'DG686 Vlissingen Centrum-Noord';
        MenuID:7;
        SubMenu: Table();
        IsVisible: varUserEmail in varProjectTeamCorne Or varUserEmail in varFinancieelTeam
    };
    {
        MenuLabel: "DG729 Venlo-Noord"; 
        MenuIcon: Icon.DetailList; 
        MenuScreenNavigate: 'DG729 Venlo-Noord';
        MenuID:8;
        SubMenu: Table();
        IsVisible: varUserEmail in varProjectTeamAlbert Or varUserEmail in varFinancieelTeam
    };
    {
        MenuLabel: "DG751 Vlissingen"; 
        MenuIcon: Icon.DetailList; 
        MenuScreenNavigate: 'DG751 Vlissingen';
        MenuID:9;
        SubMenu: Table();
        IsVisible: varUserEmail in varProjectTeamCorne Or varUserEmail in varFinancieelTeam
    };
    {
        MenuLabel: "DG826 Echt/Susteren"; 
        MenuIcon: Icon.DetailList; 
        MenuScreenNavigate: 'DG826 Echt/Susteren';
        MenuID:10;
        SubMenu: Table();
        IsVisible: varUserEmail in varProjectTeamArno Or varUserEmail in varFinancieelTeam
    }
);IsVisible)

[EddieE]

@RvdHeijden 

I cannot find any syntax errors either so the error must be coming from another property of your gallery, check some of those as well. I'd check the OnSelect property as well as styling properties like border, size, X/Y co-oords, etc

Also, you will need to add some code to the Home option to make it visible, ie

Filter(
    Table(
    {
        MenuLabel: "Home"; 
        MenuIcon: Icon.Home; 
        MenuScreenNavigate: App.ActiveScreen;
        MenuID:1;
        SubMenu: Table();
        IsVisible: true
    };