RefinableDate managed property for a calculated column is empty

Question

RefinableDate managed property for a calculated column is empty

john john Pter 1,285

I have this calculated column named "PUETADateTime" which sum up the value for other calculated columns as follow:-

User's image

now inside Search service >> I edit a Refinable Date and linked to the related managed property as follow:-

User's image

but when i am viewing this refinable inside my search web part i will get empty values,

User's image

although this calculated column have values inside sharepoint lists.. and i submit a re-index for the site around 30 hours.

Any advice?

Regards

Emily Du-MSFT 51,926 Reputation points Microsoft External Staff

2024-08-27T03:03:34.4633333+00:00

Thank you for your question.

We are currently looking into this issue and will give you an update as soon as possible.

1 answer

Your answer

Emily Du-MSFT 51,926 Reputation points Microsoft External Staff

2024-08-27T03:03:34.4633333+00:00

Thank you for your question.

We are currently looking into this issue and will give you an update as soon as possible.

Answer 1

Emily Du-MSFT 51,926 Microsoft External Staff

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.

john john Pter 1,285 Reputation points

2024-08-27T08:52:12.0766667+00:00

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
Emily Du-MSFT 51,926 Reputation points Microsoft External Staff

2024-08-27T10:02:13.24+00:00

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.
john john Pter 1,285 Reputation points

2024-08-27T10:43:49.59+00:00

@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?
Emily Du-MSFT 51,926 Reputation points Microsoft External Staff

2024-08-28T10:12:02.7166667+00:00

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.
john john Pter 1,285 Reputation points

2024-08-28T12:27:34.0366667+00:00

@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

Share via

RefinableDate managed property for a calculated column is empty

1 answer

Your answer