Multiple-selection-enabled People field properties access for View Formatting.
Hello dears, I've a list with a people field ("Owners") allowing multiple selection. There will always be at least 2 people in that field. Is it somehow possible to access the properties of the people field in the context of View Formatting (RowFormatter) ? I'm pretty sure its not possible to loop through the values of such array but maybe its possible to arbitrarily choose like for the 2 first elements? Something like [$Owners].[0].email ? Thanks for your help!Formatting column to hide button based on created by or author
Hi I'm trying to format a column so that a Submit button that triggers a flow is to be only visible for the person who created the item. Columns real names are Submit and Author Submit is Single line of text column. Author is a Person or Group column. I know I have to added a visibility line to the formatting but I'm not sure what to put. I tried "visibility": "=if(((indexOf([$Author],'[Me]')) == 0),'hidden', 'visible')" but it didn't work. Any help is appreciated!
Quick help with Json formatting of List based on Githhub resource.
Hi everyone, Can someone help me with the following: I created a list and a board view according to the guidance and resources here in Github: https://github.com/pnp/List-Formatting/tree/master/view-samples/board-tags However, I have no idea where to put the Json code in the list advanced formatting... These are the json resources: https://github.com/pnp/List-Formatting/blob/master/view-samples/board-tags/board-tags-boxes.json https://github.com/pnp/List-Formatting/blob/master/view-samples/board-tags/board-tags-cards.json https://github.com/pnp/List-Formatting/blob/master/view-samples/board-tags/board-tags.json Can anyone help me/point me to where I need to copy paste this code in the list I created? Many thanks!
Text Hover Over only works if Column is Showing (not hidden)
Hi! I've created a risk tracker for my team and have it set up so that risk is reflected using icons / colour coding. What I've also done is captured the description of risk which I then show using the following code on hover over: "customCardProps": { "openOnEvent": "hover", "directionalHint": "rightCenter", "isBreakVisible": false, "formatter": { "elmType": "div", "style": { "font-size": "12px", "display": "block", "margin-left": "auto", "margin-right": "auto", "width": "180px", "padding": "4px" }, "txtContent": "[$ResourceRiskDescription]" } }, But what I've found, is that the hover over only populates with the text if I've got that column "Resource Risk Description" showing in my view. The whole point of the hover over is so that I can hide the column in the view and show only my icons. Anything wrong with my code?
Column Formatting - Render html
've a client that updates a SP List via Layer 2 and a stored procedure. Works great. An update at the data source level (outside of 365) now merges 5 seperate fields into one new one for which the content appears as folllows; <b>Manager</b>:</br>Mouse, Mickey</br><b>Director</b>:</br>Mouse, Minnie</br><b>Area Manager</b>:</br>Duck, Donald</br> Any thoughts on using JSON to format this to render properly? My coding is a little rusty.
Column Formatting in List View Web Part
I have created a Site Page, where I added a List View Web Part with reference to a list which has JSON-conditional formatting in it. For myself the conditional formatting works (doesn't exactly looks the same but hey, at least I see the colors.), but other coworkers don't see the formatting at all. Those coworkers have the same (or even higher) permissions to the site page and the lists themself, so rights should not be the issue. Does this feature for you guys work and if yes, whats your setup (rights) etc. If my coworkers go to the list them self they see the formatting.JSON Date Formatting Referencing Today Problem
I've discovered an issue with trying to apply formatting to SharePoint list data. Simply put I need to exclude today in the formatting application. Basic example is due dates. If the due date is today I don't want to do anything, but if it is yesterday or further back I want to set it to red. Microsoft uses this example on their reference documentation but don't directly note this won't work if the reference date is today. In this very simple example using "<" or ">=" in the code doesn't return the expected result. My thought is @now is using both date and time so I tried to add in the operator "toLocaleDateString()" but I'm guessing it's not added correctly as I lose all formatting with it included. The use case is for project milestone dates where we want to bring obvious attention to dates in the past but not when it is the current date. Any insight on what I'm missing would be greatly appreciated. Attached are simple examples where it doesn't work as expected with Project02 being the current date - I don't want to have it formatted.
