[BUG] Excel preview & people picker values in filters

[Lennart28213]

Version used Version: 1.4.1

Describe the bug Hello everyone,

I have two problems with MDV and hope someone can help me to solve them.

1. Excel files have no preview. Is there any way to enable it? We use the list template of the data visualizer.

2. We have several columns in our SharePoint document library that are people picker columns. I have mapped these to a refinablestring, but unfortunately the refiner displays the values in the cells of the column as a string. The names are not listed as individual items, but instead they are stringed together and separated by a semicolon. For other columns with managed metadata or texts, this does not happen.

Expected behavior 1) The exel file should have a small thumbnail that displays a preview when clicked. 2) The names should be individual items.

Example: "Ernie (2)" and not "Ernie; Bert (2)" "Bert (2)"

Desktop (please complete the following information):

• Chrome

Thanks and best regards,

[Laul0]

Hi @Lennart28213,

Thank you for reach us.

1. Excel preview By default, MDV uses the property AutoPreviewImageUrl to display a preview image of the document. If you look at the debug mode, this information is null. This is not an MDV bug. Alternatively, you can use the property PictureThumbnailURL (do not forget to include it in the Selected properties

   

2. Multi values as String It seems that is the same issue as this one https://github.com/aequos-solutions/modern-data-visualizer/issues/27

[Lennart28213]

Hi @Laul0,

Thanks for your help, the first tip works perfectly, now all files have a preview image available. Unfortunately I can't find the property ows_q_USER_<columnName>. The people columns are only displayed as normal ows_<columnName> properties. I tried to make it available with this guide, but it doesn't seem to be working. Any advice?

Thanks again and best regards,

[Laul0]

Hi @Lennart28213,

Glad to know that the first answer works for you. About the other subject, no additional solution exists, but a couple of blogs share a similar behavior as yours with a potential solution as you can see

• https://sympmarc.com/2021/04/13/crawled-properties-not-created-from-site-columns-in-modern-team-sites/
• https://learn.microsoft.com/en-us/answers/questions/180845/sharepoint-online-crawled-property-missing.html

If your behavior persists, do not hesitate to open an issue with Microsoft about the Search Schema and the Crawl.

If you find another solution, do not hesitate to share your experience. It is always appreciated and can help someone else.

Thank you

[Lennart28213]

Hi @Laul0 , Thanks for the additional links, I will try to get the properties displayed. Another problem we are facing is paging. When we click on, say, page 4, we don't jump to the top of the new page. The view stays at the bottom of the page.

Is there any way to change this? The expected behavior would be that the view scrolls back to the top of the new page.

Best regards,

[Laul0]

Hi @Lennart28213,

Please create one GitHub issue per subject. That help to track and find them easier. We will close this issue. Feel free to create a new one when you need it.

By the way, the current behavior is "correct" because the page is not refreshed and no option is existing to change this behavior yet. I think we have this point in our backlog as an enhancement for the next version.

Thank you