SharePoint List Calendar View Conditional Formatting Not Displaying for Everyone
Good afternoon, I have an odd issue I'm struggling with. I've implemented some JSON code that changes the color of a Sharepoint calendar view event based on the event type. Most people see the color coding, however some people see all event types as one color (red). At first I thought it had to do with the level of MS access each user had (the first to flag it was an outside consultant), but a few others also experience this issue and their access levels range from Associate through Director. Has anyone else experienced this issue and know how to fix it? Thank you.
Conditional formatting - only show button if attachments are present
Hi, I am trying to only show a button in a column, if there is an attachment present in the same row on the attachment column. Here is what I have so far: { "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json", "elmType": "button", "txtContent": "Send Offer", "customRowAction": { "action": "executeFlow", "actionParams": "{\"id\": \"f191e7c8-1a36-4553-9d64-607764fc6f83\"}" }, "style": { "background-color": "blue", "color": "white", "visibility": "=if(([$Attachments] == false),'visible','hidden')" } } I have tried changing " [$Attachments] == false) " to equals true, 1 and 0, and there's still no use. If I look into the address bar I can see " FilterField1=Attachments&FilterValue1=1 ", but even when I enter "1" as the value the button still does not display when attachments are present. Any help is highly appreciated. Thank you!
Multi level group
Hi All, Within a document library view of sharepoint online, there seems to be a limit of 2 on the amount group by's that can be done. One of my clients needs to group on 3 or even more levels. My quetsions: - Is this functionality coming in future releases? - Is there any alternative to achieve this functionality? I am thinking of Conditional Formatting? Thanks in advance
Conditional Formatting in Sharepoint List based on hidden column items
Hi all, I'm facing the following issue and don't still couldn't find any solution: I made a conditional formatting of the lists-lines based on items on the column "A" now I want to hide the column "A". After it, the conditional formatting doesn't work. It works only if the column isn't hidden. Do you know the way I can hide the column and the formatting works? Thank you in advance! Best regards DimitrijUsing Power Automate to create a new item in SharePoint if the total Qty is not matched.
How can I create a flow in Power Automate or use conditional formatting in SharePoint to create a new item/separate line if the result in one column, "approved or shipped Qty" does not match the original input of "requested Qty". So the balance of what was not approved/shipped is then input into a new line/ new row as its own requested qty. Thank you.
Conditional Formatting SharePoint List
Hello team, I need your support with conditional JSON formatting of SharePoint list. I would like to format column INVEST_DUE_DATE based on current date (date cell) and based on value in column Phase (string). Right now, I implemented just formatting based on date, using following code: { "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json", "elmType": "div", "txtContent": "@currentField", "style": { "background-color": "=if(@currentField < @now , '#f7adad', if(@currentField <= @now + 864000000, '#f2d596', if(@currentField >= @now + 864000000 , '#a0dec0', '')))" } } I want to apply additional condition for it - use color formatting only if value of cell Phase = Investigation. So , it should be something like this (@currentField < @now) and @[$Phase]='Investigation' , '#f7adad', and etc.... But it does not works.... Could you please advise me how to modify initial JSON code? Thank you in advance!
