Filter Combo by User

[crmr298]

I have a UserFacility SP list to limit the Facilities available for a user to choose.

User (lookup to "Users" list)

Facility (lookup to "Facilities" list)

In the OnVisible property for my form, I have this function:

ClearCollect(ColFac,Filter(UserFacilities,User.Value = User().Email))

The function appears to be working, because I put a gallery in the form (just for testing purposes) and it is filtering to the proper facilities that I've assigned to myself.

In my "Facility" combo box, I have "ColFac" in the items property.

No error is thrown, but nothing populates in the drop-down.

I've also tried "ColFac.Facility" - same results.

[eka24]

Once the Collection colFac is working on a Gallery, it strange it not showing up on the Combobox. Can you restart the App.

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

[crmr298]

 Yes, I have restarted the app and still no luck. The drop-down is empty.

Here is what I see in the formula bar:

[krishnags]

@crmr298 instead of ClearCollect(ColFac,Filter(UserFacilities,User.Value = User().Email)) try this

on AppStart : Set(currentUserEmail, User().Email) then ClearCollect(ColFac,Filter(UserFacilities,User.Value = currentUserEmail)).

I suspect the issue might be due to the data type User().Email as User() is an array, converting it to string using a variable helps us in comparing than using User().Email

[eka24]

It seems a choice column. If so use;

Choices (ColFac.Facilities)

On the dropdown

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

[crmr298]

When I try Choices I get the following error:

[krishnags]

@crmr298 probably you can use Combo box and add ColFac, since ColFac returns a table. Choices usually applicable to optionsets and dropdowns. So, try with combo box and for the Items user ColFac.Facility

[eka24]

Please can you show a full picture of the dropdown

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

[crmr298]

That is how I already have it set up, as a combo box with ColFac.Facility in items.

[crmr298]

Here is a full screenshot. Does this help?