Filter combobox based on 'User Access Level',list

(0) Share

Report

Posted on by mohamednasr

Dear experts

I am building an application linked to two SPL Mail lists for the database and the other list for user access live

in the main gallery of the application, I have a combo box for departments

My goal was to show only the department that belongs to the user in the department combo box based on the access level list.

The fourmla am using

On start

ClearCollect(colDep,SortByColumns(Distinct(Expenses,Department),"Result"));

"Expenses is the main list"

ClearCollect(colUser, Filter('User Access Level', UserName = User().Email));

"The User Access Level is the list of the users containing the user name column which email and another column for user department

For the department combobox item : Filter(colDep,Result exactin colUser.Department)

It works fine but I want to keep the the user for Management department to see all departments

Thanks a lot

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Verified answer

v-qiaqi@microsoft.com Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @mohamednasr，

Could you please share a bit more about you need?

Do you want to display all the departments for a special department?

You could set the Items property of the ComboBox as below:

If(User().Eamil in Filter(colUser,Department=Management).UserName,colDep,Filter(colDep,Result exactin colUser.Department))

Was this reply helpful? Yes No
mohamednasr 82 on at

Like
a
(0)

Report
Copy link

Link copied!

@v-qiaqi-msft
Thanks a lot and sorry for the late replay
I have a SharePoint list for user access right this list contains two columns one for user email and the other column for the department.

I filter by the department in my gallery using a combo box

All I need that each user to see their department only in the combo box based on the access right they have in the SharePoint list

Except for some users who must have access to all departments which I call them management in the access right list in the Department column

I hope i am more clear now

Thanks a lot

Was this reply helpful? Yes No
mohamednasr 82 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @v-qiaqi-msft
It works perfectly thanks a lot.
I have tested with different email accounts and works fine but I notice two things, first when I log in from my account (The owner of the app) I don't see any department in the combo box even after I put my email in the access lever list. but for other email accounts which are not owners works fine.

And for the user who has access to only one department if I press on the "x" next to the department name in the combo box it goes out of the filter mood and shows all the data for other departments, do you have a solution for that

Thanks a lot

Was this reply helpful? Yes No