Hi Team,
I am looking for One solution. if possible try to help me.
Requirement- Get All Departments of the Organization in Dropdown. based on the Filter, Auto populate the Values in the Gallery.
I tried with below code. but I want all Departments of Organization in a single drop down.
Distinct(
Filter(
Office365Users.SearchUser(),
Len(Department) > 0
),
Department
)