SharePoint
display of date-values changes within JSON formatted view
Target SharePoint environment
SharePoint Online
What SharePoint development model, framework, SDK or API is this about?
Declarative list formatting
Developer environment
None
What browser(s) / client(s) have you tested
- [ ] 💥 Internet Explorer
- [X] 💥 Microsoft Edge
- [ ] 💥 Google Chrome
- [ ] 💥 FireFox
- [ ] 💥 Safari
- [ ] mobile (iOS/iPadOS)
- [ ] mobile (Android)
- [ ] not applicable
- [ ] other (enter in the "Additional environment details" area below)
Additional environment details
No response
Describe the bug / error
The formatting of the date-values used as categories / groups changes, from "YYYY-MM-DD" to "MM/DD/YYYY hh:mm"
Steps to reproduce
a custom SharePoint-List with data from an RSS-Feed has been created, with the following columns:
The view of the SharePoint-List has been grouped by the field "pubDate":
The display of a SharePoint-List with has been customized using the JSON available at:
https://github.com/pnp/list-formatting/tree/master/view-samples/faq-accordion
Please note: only the reference of the field "Answer" has been updated to field "Title", no other changes have been made
If you expand a group / date in the view, the entries within that group ( i.e. from that date) become visible
if you scroll up, expand a second group / date above the first expanded group and collapse that second group / date again, then the date-value of the first group is displayed in a different way:
In the console of Microsoft Edge Version 128.0.2739.42 (Official build) (64-bit), no error shows up.
Expected behavior
The formatting of the date-values used as categories / groups should NOT change
@MSFT-klpinhac What are the settings of the PubDate column? Can you please add a screenshot of the Edit column panel?
Also, could you please check your build number using _spModuleLink.buildNumber on the dev tools console?
Here is the screenshot of the settings of the "pubDate" column:
The "Column Validation" is empty ( i have not included that into the screenshot, so that the screenshot is not oversized )
nothing special, i think
@MSFT-klpinhac Is it possible for you to share a sample list with credentials? If not, could you create a new empty list from the existing list and share the csv file using "Export to csv with schema" ?
i think i used this file to create the list, @arkogupta RSSExport_20240826.xlsx the data has been collected from a public german news rss-feed. Maybe you want to delete a few rows to stay below 5000 elements in the SharePoint List
@MSFT-klpinhac Thanks for sharing the excel. I am able to repro now. It only seems to occur when the groups are collapsed by default. Working on a fix rn.
@MSFT-klpinhac The fix ha been merged and should reach you in the week of 7th October.
Hello @MSFT-klpinhac , Thank you for your patience. Is the issue resolved now?
We are closing this issue for now. If the problem persists, feel free to reopen it or open a new one.