cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Regular Visitor

Office 365 users connector: Filter Users By skills

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

 

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

 
1 ACCEPTED SOLUTION

Accepted Solutions
Community Support
Community Support

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

View solution in original post

1 REPLY 1
Community Support
Community Support

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

View solution in original post

Helpful resources

Announcements
New Badges

New Solution Badges!

Check out our new profile badges recognizing authored solutions!

New Power Super Users

Congratulations!

We are excited to announce the Power Apps Super Users!

Power Apps Community Call

Power Apps Community Call: February

Did you miss the call? Check out the Power Apps Community Call here.

Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

Top Solution Authors
Top Kudoed Authors
Users online (31,053)