This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(272, 15%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJJ%3C/text%3E%3C/svg%3E)
I have this calculated column named "PUETADateTime" which sum up the value for other calculated columns as follow:-
now inside Search service >> I edit a Refinable Date and linked to the related managed property as follow:-
but when i am viewing this refinable inside my search web part i will get empty values,
although this calculated column have values inside sharepoint lists.. and i submit a re-index for the site around 30 hours.
Any advice?
Regards
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(313.6, 51%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EED%3C/text%3E%3C/svg%3E)
Thank you for your question.
We are currently looking into this issue and will give you an update as soon as possible.
In the SharePoint search, you could use the refinable managed property equal to a value to filter search results, such as refinable managed property:"data".
PUETADateTime is a column which has real data of a field. But the refinable managed property is a mapping of PUETADateTime, it does not the real data of a field.
So, the refinable is empty.
If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
Sorry i did not get what do you mean? PUETADateTime is the calculated column and the refinable is mapped to this column,,, but the refinable is empty
PUETADateTime column is the calculated column has data in the field. But refinable column only can be searchable.
Even if refinable column has a mapping of PUETADateTime column, it does not inherit data of PUETADateTime column.
@Emily Du-MSFT i always show the data of the refinable managed properties inside search we parts without any issue, then if i want to show the value of the PUETADateTime column inside my PnP advance search web part, which managed property i should use?
I did a test in my SharePoint list. I ran into an issue where the calculated column doesn't show up in the list even though it calculates the value of the date. I tested some calculated formulas, all occurs the same issue. So, this issue may be caused by calculated column.
Please create a new date and time column and map this column to a refinable managed property, check whether refinable is empty in the search web part.
@Emily Du-MSFT SharePoint list views recently do not show calculated column i agree, but if you click on the item the calculated column will have a value inside the list edit forms.. i created another calculated column inside another tenant and i got the same issue, where calculated columns will be empty inside list views but will have values when shown inside the list edit forms and/or direct API calls.. so the issue is not within the calculated columns themselves but rather with the list views, which is not related to my issue... i am talking about showing and sorting calculated column inside search web parts using managed properties