Hello Folks,

I am having trouble getting a managed property (a SharePoint Library column) show up in the PNP Search filter correctly. The name of this column is “Document Department”.

There are 2 document Libraries “Working Library” and a “Published Library”.  This column exists as a choice column originally in the Working Library.  Power Automate processes documents through a workflow, and eventually populates the values into the same column in the Published Library. 

Here is the column that eventually gets its values updated by the workflow (Below is screenshot of this column from Published Library)

For getting this field to appear in PNP Search filters, I am using a existing managed property called “Refinablestring01”, and mapped it to the “Document Department” as shown below (it is set as retrievable, refinable as shown in image)

This column (When checking in Library settings) is actually called Document Department, which I did verify (so that I know which crawled Property I should map the RefinableString01 to)

I then did a site reindex and this refinablestring01 shows up in pnp search filter

However when publishing this, the Document Department values are not showing correctly, instead it’s showing some numeric values instead of department names

But when I select the options in this filter, it does appear to filter correctly for that specific department. For example, when I select the last one “2”, the search results does filter for documents pertaining to “Project Delivery” (PD) , which is one of the actual departments in the choice values. 

 I am not sure why are numeric values being shown on the pnp search filter on the left, instead of the actual names of the Departments. Any advice would be appreciated

​Hello Folks, I am having trouble getting a managed property (a SharePoint Library column) show up in the PNP Search filter correctly. The name of this column is “Document Department”. There are 2 document Libraries “Working Library” and a “Published Library”.  This column exists as a choice column originally in the Working Library.  Power Automate processes documents through a workflow, and eventually populates the values into the same column in the Published Library. Here is the column that eventually gets its values updated by the workflow (Below is screenshot of this column from Published Library)   For getting this field to appear in PNP Search filters, I am using a existing managed property called “Refinablestring01”, and mapped it to the “Document Department” as shown below (it is set as retrievable, refinable as shown in image)This column (When checking in Library settings) is actually called Document Department, which I did verify (so that I know which crawled Property I should map the RefinableString01 to) I then did a site reindex and this refinablestring01 shows up in pnp search filterHowever when publishing this, the Document Department values are not showing correctly, instead it’s showing some numeric values instead of department names But when I select the options in this filter, it does appear to filter correctly for that specific department. For example, when I select the last one “2”, the search results does filter for documents pertaining to “Project Delivery” (PD) , which is one of the actual departments in the choice values.  I am not sure why are numeric values being shown on the pnp search filter on the left, instead of the actual names of the Departments. Any advice would be appreciated   Read More

​