Power Platform Community Forum Thread Details

Hello everyone and my apologies in advance for my English.

I created an evolving menu witha vertical gallery. The idea being to be able to gradually add functionalities to my application.

I would like to add a feature: the display or not of certain items depending on the connected user.

For this I have two Sharepoint tables:

- A "Menu" table with two columns: "Module name" and "Icon".

-An "access" table with a user's mail column, and yes/no colomns for each module.

For example :

1st table :

Module Name	Icon
Module A	XXX
Module B	XXX

2nd table

Mail	Module A	Module B
user1@test.com	True	False
user1@test.com	True	True

My objective being: If I'm user1 I should see only module A, and if I'm user B I should see both modules.

My problem being the linking of these two tables to be able to filter correctly. Do you have an idea ?

I tried to pass via a collection from the first table by adding columns for each module according to the connected user, but it does not work very well and in the case of the creation of a new module I have to review my formulas.

The fact that my key (Module X) is column once and row once doesn't help at all... But I can have tens/hundreds of users, so I can't column them in the second table.

Thanks a lot for your help !
Simon

Categories:

Building Power Apps