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.

[crmr298 · Accepted solution]

I was able to figure this out with a Concatenate:

Set(currentUserEmail, User().Email);

ClearCollect(ColFac,Filter(Facilities, Facility in Concat(Filter(UserFacilities,User.Value = currentUserEmail),Facility.Value & ";")).Facility)

Thanks all!