User Profile
WorkflowIQ
Copper Contributor
Joined Nov 10, 2021
User Widgets
Recent Discussions
SharePoint Pnp Search v4 People seach verticals issue with Location
I am trying to resolve an issue with SharePoint (online) PnP search v4 for an employee search page. I have a search box web part and filter web part for department and job title. In my search results i can successfully retrieve results by typing the full or partial name of the employee into the search box. I can also filter the results by department or job title successfully using the PnP Search Filters webpart. The text in the PnP Search Results is "{?Title:{inputQueryText}*} Department:*". (I am also filtering out any users with the Department filed blank successfully) I would like to use a search vertical web part to filter by location. I have set up the verticals web part with the default "all" tab with a value of "*" and other tabs with locations that match what has been entered into the Microsoft 365 user profile for the users. I was getting 0 results when selecting the search vertical tabs. I have checked the mapping of the "baseOfficeLocation" managed property and it was mapped to People:SPS-Location and when that didn't work, based on some research, i changed the mapping to People:Office. That didn't make a difference. I also mapped a spare refinableString managed property to People:Office. I checked to make sure the "People:Office" property in SharePoint user profiles was the correct property with values. If i used the text "{?|(RefinableString01:{UserInput}" in the query template, in the search results web part, I was able to get successful filtering by location based on this new mapping, by typing into the search box the location name to get only users from that location, or "*" to get all users with a location entered. This tells me that there are results getting retrieved. I have tried "RefinableString01:{vertical.value}" in the query template but that retrieves no results.Re: JSON format broken?
Danie365 Thanks for the help, i really appreciate it. I still can't get it to work though. I pasted your code exactly, just adding my correct flow id, and replacing the single quotes (as they paste a different character if copying from here). Do you have any other suggections on what could be wrong? Thanks again, screenshot below.
