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?
Date and Time entry form split into two
Hi, I've been asked to support on a site that has been in place for a few years now, and they are having some issues with the date and time column. One thing that I have noticed though that on this site, the entry for the date and time is split into two, one calendar dropdown for date and another for time, but still part of the same column on the list. Does anyone know how this is achieved, and if it can be changed to the normal view with the date and time all grouped together in one cell on the form? From what I can see there is no custom formatting in place or anything else different in the standard settings. Current view Standard view Thanks!
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.
Help needed with calculated column
I am trying to add a calculated column in Microsoft Lists that follows this logic: If the value in Column A is equal to "Yes," the calculated column should take the value from Column B and subtract 16 from it. If the value in Column A is not "Yes," the calculated column should remain empty. The formula I have attempted to use is: =IF([Column A]="Yes", [Column B] - 16, "") Here: Column A: A column of type Choice or Text, where the value "Yes" can occur. Column B: A column of type Number. The formula is being added as a calculated column. Issue: The formula does not seem to work as expected. Even when the value in Column A is "Yes," the calculated column remains empty. Questions: Is the above formula supported in Microsoft Lists? Are there limitations in Microsoft Lists for using this logic or syntax in calculated columns? Is there a specific reason why this formula might not work (e.g., type settings or handling empty values)? I would appreciate your guidance on how to correct or adjust this formula to achieve the desired result.
'Created by' vs 'App Created by' columns - Sharepoint Lists
Hi All, Can someone please explain the difference between these two columns in sharepoint lists? I have a list of almost 2000 items; the 'Created by' are all people's names, as I would expect, while the majority of 'App Created by' columns are blank. The other values here are Microsoft Power Platform (5 items), and OneDrive SyncEngine (30 items). I have not been able to discover any MS documentation about how/when this is populated. I am assuming that Microsoft Power Platform means it was created via a Power App or Power Automate Flow - any way of discovering which, and if a flow, which flow? OneDrive SyncEngine I have no idea at all and would appreciate knowing for my own interest. Discovery of this has come about by realising we had 5 blank rows in the List - causing Power BI report refresh to fail - as these appeared to be 'duplicates' with no values in the Title column. These 5 rows were all 'App Created by' Microsoft Power Platform or OneDrive Sync Engine. Sharepoint version is 'Sharepoint in Microsoft 365' formerly known as Sharepoint Online Thanks in advance for any help!
Nested Dynamic Filtering on web parts does not work
I created a Sharepoint page and added an MS list web part, which I use as a "filter" selection. Then, I added a second MS list to display the main list of content items, configured with Dynamic filtering based on selecting the "filter" list. Then, I added a Document library web part, which is again configured with Dynamic Filtering based on the selection of the second content item list. Unfortunately, when you select an item from the "filter" list and then select an item from the second "content" list, the document library does not update based on the selection. HOWEVER.. If I select an item from the second "content" list without selecting an item from the "filter" list, the document library updates and shows the filtered content correctly. Any idea why it would not work and how to fix this? Seems like it should work
