SharePoint
List Formatting: Unable to update column containing deleted user with setValue
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
- [X] 💥 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
When attempting to update a multiple selectable person column using setValue, an error is displayed if the field to be updated contains a deleted user.
https://github.com/SharePoint/sp-dev-docs/assets/51254139/3943ed5a-713a-4006-9c7c-ac7da37b6b1c
The update uses the appendTo and removeFrom operators. (Reference: Advanced formatting concepts)
*Deleted user has not been removed from the user information list.
Steps to reproduce
-
Create a
Favoritescolumn (column type: Multiple Choice Person column) in the list -
Set the user to be deleted in the created column
-
Delete a user in the Microsoft 365 Admin Center
-
Set the following JSON in the
Favoritescolumn created
JSON
{
"$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json",
"elmType": "div",
"children": [
{
"elmType": "div",
"style": {
"font-size": "18px",
"padding": "2px 7px 2px 7px",
"cursor": "pointer",
"border-radius": "10px"
},
"attributes": {
"class": "ms-bgColor-themeTertiary--hover"
},
"customRowAction": {
"action": "setValue",
"actionInput": {
"Favorites": "=if(indexOf(@currentField.email , @me) > -1 , removeFrom(@currentField.email , @me) , appendTo(@currentField.email , @me) )"
}
},
"customCardProps": {
"openOnEvent": "hover",
"directionalHint": "rightCenter",
"isBeakVisible": true,
"formatter": {
"elmType": "div",
"style": {
"max-height": "300px",
"padding": "5px 20px 5px 20px",
"display": "flex",
"flex-direction": "column"
},
"children": [
{
"elmType": "div",
"txtContent": "= '💖 ' + length(@currentField)",
"style": {
"padding": "10px",
"font-weight": "bold",
"font-size": "20px"
}
},
{
"elmType": "div",
"children": [
{
"forEach": "personIterator in @currentField",
"elmType": "div",
"style": {
"margin-bottom": "5px",
"display": "flex",
"align-items": "center"
},
"children": [
{
"elmType": "img",
"style": {
"width": "32px",
"height": "32px",
"border-radius": "50%",
"margin-right": "5px"
},
"attributes": {
"src": "=getUserImage([$personIterator.email], 'S')",
"title": "[$personIterator.title]"
}
},
{
"elmType": "span",
"txtContent": "[$personIterator.title]"
}
]
}
]
}
]
}
},
"children": [
{
"elmType": "span",
"style": {
"margin-right": "5px"
},
"txtContent": "💖"
},
{
"elmType": "span",
"style": {
"font-weight": "=if(indexOf(@currentField.email , @me) > -1 , 'bold' ,'' )"
},
"txtContent": "=length(@currentField)"
}
]
}
]
}
- Click the button displayed by JSON
Expected behavior
Can be updated even if deleted users are included.
@shagra-ms @VesaJuvonen the problems with this Bugs in setValue or missing controls got bigger and bigger. Seems like something has changed in the backend but there were no json-schema-update or soemthing else.
We are using JSON-FOrmatting in Many Very Big Lists and Sites in Our Company and have very big Pain-Points since some weeks after the SharePoint-Update "MC713894 - Upgrade for the latest Microsoft Fluent Design System visual styling on Microsoft SharePoint" and we've also created some support tickest but the support engineers often says to open issues here.
So is there any idea when this problems can be solved or any idea what's the problem here?
Sorry to annoy you with that but for us its a big problem. We love json-formating sharepoint-lists but actually its giving us full grey hair :D
@dborchers-gc
have you tried with Microsoft Lists web app UI? Have you already run a test to check if setValue is supported? It's basically the same list URL but with "?env=WebViewList" at the end.
@Fedes365 doesnt work also
It is supported, it works on some lists but doesn't at the most list, since 2 or 3 weeks.
Every user who has the old ui (didn't got the MC713894 update) have no problems
Thanks for tagging me @dborchers-gc and bringing this to my attention. I will check with engineer on this.
Dear @shagra-ms,
Other referenced issues affecting users : https://github.com/SharePoint/sp-dev-docs/issues/9614 https://github.com/SharePoint/sp-dev-docs/issues/9617
Fix for this issue in currently rolling out. Please validate this again next week, and let me know if you still face problem. @tecchan1107 @dborchers-gc
Hi @shagra-ms ! Thanks for the fix, and the reply!
The problems I faced with List Formatting have been posted in this repository issue. The problems I am facing are as following. https://github.com/SharePoint/sp-dev-docs/issues/created_by/tecchan1107
Other issues related to List Formatting are as following. (Search results for List Formatting) https://github.com/SharePoint/sp-dev-docs/issues?q=is%3Aissue+is%3Aopen+List+Formatting
Hey @shagra-ms ,
also, inlineEditField doenst work in customcards anymore since the new SharePoint list update.
Hello @tecchan1107, Thank you for bringing this issue to our attention. We will look into it and get back to you shortly. Could you please confirm if the issue still persists for you?
Hello @tecchan1107, 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!