Issue with flat views in SharePoint Online

[h3nn3]

There are 2 problems:

FlatViewProblem.mp4

1. Problem with column formatting (setValue)

Description

I use folders within a SharePoint list to organize list items. Additionally, I apply column formatting to update values in a column via button click using customRowAction (setValue). So far, so good…

However, when I switch to a flat view (view without folders), this functionality no longer works, and error messages appear.

Steps to Reproduce

1. Create a SharePoint list with folders.
2. Apply column formatting that includes a button with customRowAction: setValue.
3. Switch to a flat view (view that does not display folders).
4. Click on any button that triggers the setValue action.
5. Observe that the action does not work, and an error message appears.

Expected Behavior
• The setValue action should function the same way in flat views as it does in non-flat views.

Observed Behavior
• The functionality fails in flat views, and error messages appear.
• This issue only affects items stored within folders.

---

2nd Issue: Quick Edit Date Localization

Description

There is another issue when using Quick Edit in a flat view:
• If I set a date field for an item inside a folder, the localization is incorrect.
• Example: Selecting April 1st results in January 4th (German localization).
• This issue only occurs in flat views and only for items inside folders.

Expected Behavior
• The selected date should be saved correctly regardless of whether the item is inside a folder or not.

Observed Behavior
• The date is incorrectly interpreted due to localization issues.
• Items outside of folders or in a non-flat view do not experience this issue.

---

Additional Info: Adding the ID column does not change anything. The error message is misleading.

---

Environment
• SharePoint Online
• List with folders
• Flat View (View without folders)

Impact
• Prevents correct use of setValue in flat views.
• Causes incorrect date localization when using Quick Edit in flat views.

---

I already had a Microsoft support ticket open, but unfortunately, I was informed that Microsoft Support cannot help me. However, this is definitely a SharePoint issue and not something caused by custom development or similar. Only built-in features were used.

I also opened a discussion on the techcommunity page https://techcommunity.microsoft.com/discussions/sharepointdev/issue-with-flat-views-in-sharepoint-online/4397498

---

Would appreciate any insights or fixes on this! Thanks! 🚀

[Ashlesha-MSFT]

Hello @h3nn3,
Thank you for bringing this issue to our attention. We will look into it and get back to you shortly.

[Ashlesha-MSFT]

@h3nn3,
Regarding issue 1
How do you create a column of type "folder" since there is no type like "folder" or "file" inside the list of a site?

Or else can we use document library to reproduce the issue?

[Ashlesha-MSFT]

@h3nn3,
Regarding issue 2,
We were able to reproduce the issue, and we are investigating it. We have logged this as a bug, and our engineering team will look into it.

Thank you for your patience!

[h3nn3]

@h3nn3, Regarding issue 1 How do you create a column of type "folder" since there is no type like "folder" or "file" inside the list of a site?

Or else can we use document library to reproduce the issue?

It is not a column type "folder" it is just a folder inside a SharePoint list. You can enable folders in the list settings of a SharePoint list. Then you can create or drag and drop a list item inside a folder

[Ashlesha-MSFT]

@h3nn3,
For issue 1 also,
We were able to reproduce the issue, we have logged this as a bug, and our engineering team will work on it.

Thank you for your patience!