Column Validation Evaluation Changes
Hello! I'm wondering if I am going crazy, but I have seen breaking changes to a couple of client tenancies where column validation is now occurring for any item/file creation or modification event. This was not happening a month or so ago, and I've got evidence of that with files being able to be placed in a library previously, and not, now. This is because it is clearly trying to validate on column information that is not entered by the (flow) creation of the file. If I were to try to deal with this INSIDE the validation formula for all my lists, ever ... this could effectively cripple me! 😅 --- I'm not posting a problem that needs fixing, here, so please, I do not need to be asked what I have and haven't tried ... I'm simply asking if others have noted a similar thing happening.
Retrieving information about the SiteUserInfoList using REST API results in a 403 error
I tried to send the following GET request, authenticated as an administrator: https://<tenant-domain>.sharepoint.com/<site_path>/_api/web/lists?$select=Author,BaseTemplate,BaseType,Created,DefaultViewUrl,Id,LastItemModifiedDate,Title,DefaultView/ServerRelativeUrl,HasUniqueRoleAssignments,RootFolder/ServerRelativeUrl,RoleAssignments/Member/Id,RoleAssignments/Member/LoginName,RoleAssignments/RoleDefinitionBindings&$expand=Author,DefaultView,RootFolder,RoleAssignments/Member,RoleAssignments/RoleDefinitionBindings I got a 403 status code, with the error: "Due to organizational policies, you can't access this resource." To investigate the source of the problem, I tested the following request, which returned a valid output: https://<tenant-domain>.sharepoint.com/<site_path>/_api/web/lists I then iterated over the lists in the response, and for each such list I sent a request to get its data. All the requests returned a valid response, except one: SiteUserInfoList. When I tried to get information about this list, I got the same error mentioned above. I Googled it up and discovered this is a hidden list, maintained by SharePoint to store and manage user information profiles for authenticated users at the site collection level. I have a few questions: As administrator, does it make sense that I am forbidden from retrieving information about the SiteUserInfoList? Was the SiteUserInfoList always part of the lists shown in the _api/web/lists response? Or was it added recently? Is there a workaround I can apply to make this request work? https://<tenant-domain>.sharepoint.com/<site_path>/_api/web/lists?$select=Author,BaseTemplate,BaseType,Created,DefaultViewUrl,Id,LastItemModifiedDate,Title,DefaultView/ServerRelativeUrl,HasUniqueRoleAssignments,RootFolder/ServerRelativeUrl,RoleAssignments/Member/Id,RoleAssignments/Member/LoginName,RoleAssignments/RoleDefinitionBindings&$expand=Author,DefaultView,RootFolder,RoleAssignments/Member,RoleAssignments/RoleDefinitionBindings
Lookup Column content disappears with conditional formatting
Hi all, SharePoint and it pointless limitations (or bugs) drive me crazy again... I have a list, that is used by different people. As it´s still not possible to color headers or similar, I got used to insert lines left or right of a column via conditional formatting. With such, I create "blocks" of columns for each user. Better that nothing... But now comes the kicker. It worked fine so far, but now with a lookup column, the content just disappears. This is my list without the border, numbers visible to the left. Now with formatting applied to the left lookup column, the content is just gone. I start with "no style" at formatting, as I only want to have the border. The teaser clearly shows, that text should be visible: The json code has some "hidden" attributes in there, but no matter what I change, the content does not reappear. { "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json", "elmType": "div", "style": { "box-sizing": "border-box", "padding": "0 2px", "overflow": "hidden", "text-overflow": "ellipsis" }, "attributes": { "class": "sp-field-borderRightBold sp-field-borderRightSolid sp-field-fontSizeMedium" }, "children": [ { "elmType": "span", "style": { "overflow": "hidden", "text-overflow": "ellipsis", "padding": "0 3px" }, "txtContent": "[$PA_x0020_Nr_x002e__x003a__x0020_.lookupValue]", "attributes": { "class": "sp-field-fontSizeMedium" } } ] } Please help... How do I get the border AND my content? Thanks!
Embedded list view - messed up columns
Sometimes, when I embed a list with a custom view, the columns are drastically different on a co-workers computer, while they look fine on mine. I fiddle with the JSON formatting, hiding/showing the column headers, adjust the column sizes, etc, but nothing seems to work. Is this a known issue? Any suggestions to deal with this? My screen (Edge browser): My co-worker's screen (Edge):Status Change tracker
#Sharepoint Hello, I have a list with a column " Status" . We have "open" " rejected" " sent to vendor" " closed" Can we track the status changes in Sharepoint and measure how long it takes for each case from the " open " to the "closed " status? We would like to measure performances if this is possible. Best Regards GD.
Microsoft Lists form How to color different Sections to make it easy to fill out
I have a created a Microsoft List. There are sections of related questions ie column fields. In Configure Layout, Format Body, I have added JSON code to display different sections (areas) for the fields. which looks great when entering as a form. Is there a way to apply color to the different sections to distinguish the different sections to make it easier for the end user to enter. eg see screenshot example layout of Patients template form different sections in different colors How can this be achieved? TIA
Need help pulling dates from Calendar
We have a calendar that tracks all the meetings we have with clients. Our leadership is requests that we provide them an excel spreadsheet at the beginning of each month showing all the meetings that we had with our clients the previous month. This works well but because we have many recurring meetings, those are not showing up. I have a start time and end time for the meetings. So in order to extract the data I created a field for the month and year based off the start time. Here is my example: In May 2023, we created a recurring meeting every first Monday of each month. This is showing on our Calendars correctly, but when I pull the month and year from the start date, it is pulling May 2023 for every event. I need it to pull November 2024 for the November meeting and December 2024 for the December meeting and so on. How can I show the start and end time as the real time of the meeting?
Get all versions' check-in comments through API
I'm trying to use the REST API through Power Query to get all history check-in comments of an item. I could see all the comments from the version history but output of the API shows the lastest comment for the both two versions: I'm using a Power Query function I get from the Power BI forum and all other things it returns are correct, except the check-in comments let Source = (VersionsRelevantSharePointListName as text, VersionsRelevantSharePointLocation as text, VersionsRelevantItemID as number) => let Source = Xml.Tables(Web.Contents( "https://tenatename.sharepoint.com/sites/", [RelativePath = VersionsRelevantSharePointLocation & "/_api/web/Lists/getbytitle('" & VersionsRelevantSharePointListName & "')/items(" & Text.From(VersionsRelevantItemID) & ")/versions"] )), entry = Source{0}[entry], #"Removed Other Columns2" = Table.SelectColumns(entry,{"content"}), #"Expanded content" = Table.ExpandTableColumn(#"Removed Other Columns2", "content", {"http://schemas.microsoft.com/ado/2007/08/dataservices/metadata"}, {"content"}), #"Expanded content1" = Table.ExpandTableColumn(#"Expanded content", "content", {"properties"}, {"properties"}), #"Expanded properties" = Table.ExpandTableColumn(#"Expanded content1", "properties", {"http://schemas.microsoft.com/ado/2007/08/dataservices"}, {"properties"}) in #"Expanded properties" in Source Does this API support return all comments? Or I need to get all comments from elsewhere.
JSON Conditioning with multiple IF statements
Hello I am trying to format a date column. The date in the column is a date that someone completed a certification and that certification expires after one year. I am trying to using conditional formatting comparing the date in the column against the current date to show if the certification is still valid, getting close to expiring, or expired. I can't seem to get it to work. { "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json", "elmType": "div", "attributes": { "class": "=if((@currentField >= @now – 31536000000 && @currentField <= @now – 5184000000), 'sp-field-severity--good', if((@currentField >= @now – 5183999999 && @currentField <= @now – 2592000000), 'sp-field-severity--warning', if(@currentField >= @now – 2591999999, 'sp-field-severity--severeWarning', 'sp-field-severity--blocked'))) + ' ms-fontColor-neutralSecondary'" }, "children": [ { "elmType": "span", "style": { "display": "inline-block", "padding": "0 4px" }, "attributes": { "iconName": "=if(@currentField >= @now – 31536000000 && @currentField <= @now – 5184000000), 'CheckMark', if(@currentField >= @now – 5183999999 && @currentField <= @now – 2592000000), 'Error', if(@currentField >= @now – 2591999999, 'Warning', 'ErrorBadge')))" } }, { "elmType": "span", "txtContent": "@currentField" } ] }
