Office 365 users connector: Filter Users By skills

[LYAM]

Hello everyBody, 

I'm using 0365 User connector and SearchUser function to display all users. The function SearchUser  allows only searches by Name. I put all my users in Gallery and the the purpose is to filter users by their skills. 

I succeeded to recover with the function UserProfilV2 all information about skills with using : 

Concat('Utilisateursd''Office365'.UserProfileV2(ThisItem.Id).skills.Value; Value; ", ").

My issue is that the Skills information is grouped in table. 

I try to use collection and put it in gallery and filter by skills. Unfortunately without success.

Do you have any solutions to my problem?

Thanks for your answers

Best regards

[v-siky-msft · Accepted solution]

Hi @LYAM ,

Add a new column to store the concatenated skills, and then search by this newly created column.

Gallery.Items:

Search(AddColumns('Utilisateursd''Office365'.SearchUser(),"concatSkills",Concat(Office365Users.UserProfileV2(Id).skills.Value, Value, ",")),SearchBox.Text,"concatSkills")

 Hope this helps.

Sik