Switch(vCompany,
"Company 1",
//Notify(Self.SearchText);
Set(vInUse,"T");
ClearCollect(
UserCollection_C1,
AddColumns(
Filter(
Office365Users_C1.SearchUser(
{
searchTerm: Self.SearchText,
top: 500
}
),
!IsBlank(JobTitle)
&& AccountEnabled = true
),
SuggestionImgUrl,
Substitute(
JSON(
Office365Users_C1.UserPhotoV2(Id),
JSONFormat.IncludeBinaryData
),
"""",
""
),
SuggestionKey,
Mail,
SuggestionName,
DisplayName,
SuggestionRole,
JobTitle
)
),
"Viridor",
//Notify(Self.SearchText);
Set(vInUse,"V");
ClearCollect(
UserCollection_C2,
AddColumns(
Filter(
Office365Users_C2.SearchUser(
{
searchTerm: Self.SearchText,
top: 500
}
),
!IsBlank(JobTitle)
&& AccountEnabled = true
),
SuggestionImgUrl,
Substitute(
JSON(
Office365Users_C2.UserPhotoV2(Id),
JSONFormat.IncludeBinaryData
),
"""",
""
),
SuggestionKey,
Mail,
SuggestionName,
DisplayName,
SuggestionRole,
JobTitle
)
)
);
There are some other minor properties on the search but nothing major.
The idea is - based on the dropdown, use the relevant connector to lookup users from EAD.
This works - in Studio, change the dropdown and the relevant directory is searched.
When Published and run - only the first connector is used.
I have used tables to view the collections I am using to verify all this and its just not working as it should when published.
I feel like I am missing something simple...but cant see the woods for the trees if that makes sense?!
Any one feeling brave enough to help?
Thanks
Dan