List Column Formatting - Set WHOLE Attributes Object If Column Has Content
Hi, I would essentially like to know how to achieve one of two outcomes in my view formatting dependent on the column in question having a value. The following are the two eventualities I would like to reach. IF Column HAS Content { "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json", "elmType": "a", "txtContent": "@currentField", "attributes": { "target": "_blank", "href": "@currentField" } } ELSE IF Column Is EMPTY { "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json", "elmType": "div", "style": { "display": "flex", "justify-content": "center", "align-items": "center" }, "children": [ { "elmType": "span", "txtContent": "No URL" } ] } Obviously I would expect the JSON to not resemble the above examples, they are just what I would like to achieve, here. I am suspecting this will not be possible ... at least not with the 'excel style' expressions.
Logging Tickets in Working Hours (Issues list)
I have a Sharepoint Issues List. We set the ticket logged time as the item Created Date (ie. 20/06/2025 10:00) We then set a deadline by adding x hours to the Created Date based on the category. (ie. 2hr, 3hr, 24hr, 36hr, 72hr etc). We further move the SLA Deadline if it drops on a Saturday or Sunday (Add 24 or 48hrs based on day of week). Our support team work 8am - 4pm, so they have asked if we can look at not having the SLA Deadline landing when they are not on shift. In my mind, we would create a temp calculated column that works out of the deadline time is after 4pm, and before 8am, and if so, then add 16 hours to it (16 hours is the time they are offline - 4pm - 8am) Does anyone know the formula you would use to do that calculation ?
InfoPath Unable to Submit the Data
Hi Team I have the InfoPath form which is connected with SharePoint list in the list i have added the new column and also i have added the new textbox in the InfoPath designer but while submitting the data the column value is not storing to the DataSource. The DataSource is giving the Main in the InfoPath designer. Can you anyone give me the solution Please find the Images. Newly Added the Column which is Sample Data. Can any one suggest me the solution Please Thank You, SaiKrishna.
30 Items only showing SharePoint List JSON Formatting. How to increase this number ?
Hi, I have formatted a list with JSON and I have found a peculiar error, no matter what I set the view item limit to, it only shows the first 30 items along with "See all" button after full scroll. How can I increase this number from 30 to 100 where group by has been placed on view ? Thanks, Pratik
MS Lists time zone issue
Hi everyone, Currently I'm using Power Automate, to import every new MS Form response to my Lists. I know that the MS Form's "Completion time" is based on UTC +0. So I converted my "Completion time" from UTC +0 to UTC +8 (where I located) For example: Form No. 43 is completed on 5/30/22 06:41 (UTC+0), I should have successfully converted that to 5/30/22 14:41 (UTC+8) And when I did a test in Power Automate for this flow. I also observed the Output to be "5/30/22 14:41" But when I checked the Lists, it's actually showing: 05/30 9:41, with a -5 hour time gap to my output, 14:41. Below is the screenshot: I had checked my account setting and my region is in UTC+8. I would like to know why that Lists is showing my output differently. And what causes this 5 hour gap. I know maybe I can just add 5 hour to the time, but there should be a root cause for this. If you know the answer please kindly help, thank you in advance!Open internal links in a new tab
I have a list with an item linked to internal document set to open in a new tab. When I add a webpart on the home page and add this list, the above link opens in the same tab. Why is the link not behaving in the same way as when I open the list itself? How do I make the link on the home page open in a new tab?
Automatic Version History in SharePoint Online, hourly, daily and weekly versions?
I am considering on enabling the automatic setting for version limits in SharePoint Online, however, is still unclear to me, how the algorithm identifies hourly, daily and weekly versions. From the documentation this is what it says about: All versions created within 500 count limit in first 30 days. Hourly versions (versions created at the top of the hour) between 30 to 60 day period. Daily versions (versions created at the beginning of each day) between 60 to 180 day period. Weekly versions (versions created at the beginning of the week) beyond 180 days or more are available indefinitely until the maximum 500 count limit has reached. My question is, what is considered "at the top of the hour" or "beginning of each day/week"? Does it mean that only versions created at 09:00, 10:00, 11:00 will be kept? What if the version has been created at 09:03 or 09:46? Additionally, what if there are several versions created within the same time frame, which one will keep? I hope my question is clear enough. Thank you so much in advance.SharePoint Online - How to keep left navigation expandable
Hi All, I am using SharePoint Online site collection. I have created Left navigation menus with sub menus. I want this menus should be expandable in SharePoint Online site. We had used SharePoint 2013 in that Left navigation showing expandable with sub menus so just line I need this behavior on SharePoint Online. Thanks, Harish Patil
