Answered

Combo box value

(0) Share

Report

Posted on by mohamednasr

Dear experts, I've created an invoicing app where users create invoices. I use department Combobox to filter my gallery some of the users have to see all the departments and other users have to see only one department in the dropdown,

I have another list linked to my app, this list for access levels containing the UserName column which is the user email and another column for the department, I am using this list to hide buttons based on the current user by user varUseremail on start and it works fine I want to use the same list to filter the gallery based on the Combobox

For example, if Mark@***.com his department Marketing he can only see the Marketing in Combobox item
And if Mark@***. com his Departmen Marketing and Sales he can see both Marketing and sales in Combobox items

I hope I am clear

Thanks a lot

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (1)

Sort by

Akser 1,546 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @mohamednasr,

OnStart (Store the current user's department in a collection)
//MyUserList is a SharePoint list with 2 columns: UserEmail and Department ClearCollect(colCurrentUser, MyUserList, UserEmail = User().Email)
Items property of my combo box (Show departments based on previous collection)
//MyDepartmentList is a SharePoint list consisting of 1 colum: DepartmentName Filter(MyDepartmentList, DepartmentName exactin colCurrentUser.Department)

Was this reply helpful? Yes No
mohamednasr 82 on at

Like
a
(0)

Report
Copy link

Link copied!

@Akser

Thanks a lot for your reply but it doesn't work i did it as you recommended "OnStart" the ClearCollect(colCurrentUser, UserListName, UserEmail but it doesn't recognize the column name which is UserEmail

Was this reply helpful? Yes No
Akser 1,546 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
@mohamednasr, seems like I forgot to include the Filter function. But either way, this was just an example, you should modify them according to your data source (MyUserList, UserEmail etc.)

ClearCollect(colCurrentUser, Filter(MyUserList, UserEmail = User().Email))

Was this reply helpful? Yes No
mohamednasr 82 on at

Like
a
(0)

Report
Copy link

Link copied!

@Akser
You are the best, thanks a lot it's working now after I added the filter in Onstart.
but it gives me a delegation warning in "exactin"

Thanks again

Was this reply helpful? Yes No
mohamednasr 82 on at

Like
a
(0)

Report
Copy link

Link copied!

@Akser
Also, there is an issue that Combobox duplicating the department name when there is more than one user in same the department
Example :
Danial@XX.com in Marketing Department &
Mark@xx.com in Marketing Department as well in that case the combo box appear with 2 marketing

Was this reply helpful? Yes No
Verified answer

Akser 1,546 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!
@mohamednasr,

exactin is not Delegable correct. You can try to add the list of departments to a local collection OnStart as well.
ClearCollect(colDepartment, SortByColumn(Distinct(MyUserList, Department), Result))
The above formula will create a local collection that contains unique departments (that exist in your user list) - sorted ascending. The only thing left to do is to update the combo box's Items property to refer to this new collection.
Filter(colDepartment, Result exactin colCurrentUser.Department)

Was this reply helpful? Yes No
mohamednasr 82 on at

Like
a
(0)

Report
Copy link

Link copied!

@Akser
Thanks a lot i've tried it and it works fine, i really appreciate you help. Any idea how to show all departments, if the logged user from the management department?

Was this reply helpful? Yes No