SharePoint List Export to Excel Not Updating After Refresh
Hello, My SharePoint list had 3.5k rows and recently did a huge cleanup and deleted almost half of it. It now currently has 1.6k items. I have exported that SharePoint list to an excel file but when I hit Refresh All in the file, it still has 3.5k line items and still hasn't updated. I did the update around 2pm CST yesterday, and as of writing this it is currently 8:30am CST the next day. I don't understand how when I export to CSV, everything is updated but when I export a new file to Excel or when I refresh my old export that is still linked to my SharePoint list, it isn't updating. Please help. Thank you!Sharepoint - built in approval flow: where to find approver comments ?
Hi, I am useing the built in approval flow for a sharepoint document library, by switching in on here: When an approver is approving/rejecting an item in the library, she/he can give comments: QUESTION: Where are the comments stored ??? I cannot find the comments anywhere. There is no associated column in the library. there is only a column for the approval status... I need to get the comments and send it on in a PowerAutomate notification flow... thanks for your insights. alex.
Two connected lists
Hi I have a issue I need to solve. I will try to describe is as good as I can but it feels pretty delicate. I have 2 list lets call them just "List 1" and "List 2" to make it easy. In "List 2" i have a collumn with a lookup to add items from "List 1". So far no problems. But the thing is that when I add one ore multiple items from "List 1" in the "List 2" item i would like that a Automation updates the selected List items from "List 1" with the linked name from "List 2". This needs to work wich create a new Item in "List 2" and when modifing the item. I tried to have my CoPilot to do this for me but it failed big time. Hope that someone have an greate solution for me! Thanks in advance.
How to connect SharePoint site access user details via Google Analytics data studio
Hi Experts, Good day, I would like to create new reports in Google data studio (Google Analytics), with the data source coming from SharePoint. I need to import site access user counts, including the number of views and counts. I know that we can export this data via the Microsoft 365 Compliance Center, but my client does not allow tenant access due to data privacy concerns. Could you please advise on how we can achieve this? Specifically, I need to collect SharePoint document and file access user details daily and connect this data to Google Analytics on daily basis. If you have step by step instruction details or if you have alternate way to achieve this let me know. Regards, GokulDeleting old rows from a SharePoint list
Hi, I am using a SharePoint site as a database for a desk booking system. The data is held in SharePoint lists. I want to delete old data, i.e. items older that 1 month Is there an easy way to do this?, the list contains thousands of records from the past 4 years. Thank you for your time, Ollie
How can I recover a corrupted Sharepoint list?
The user tried to delete a column and suddenly received this error: However, trying to navigate back to the list, the page only shows the title. No columns, no "Add item", no Settings "gear" icon, no Recycle Bin. Is there some way we can retrieve the list? There is no data in the list, it is just the configuration (lookups and rules, etc.) that we need to get back.Make fields required in the new list form, but not the list.
I want to have 2 different forms feed into my list. Each form has different required fields. As far as I can see I can hide required fields in the form and submit the form fine, but when I view the list it highlights a lot of errors asking for required fields. Some fields are relevant to one request and not the other request submitted via the form. It would be great if we could make the fields only required in the form and not in the list. I'm probably going to have to go back to using MS Forms for this project. It's really irritating that any attached flows also need to deal with the required fields in the list and update them each time. All I want to do is update the approval status, but I also have to update 5 fields.
SharePoint List - How to open Edit Current View option in same Tab
Hi All, Currently I am using SharePoint Online site collection. In that list if I click on Edit current view option from any view then it open in new Tab to edit view settings. How to open that in the same Tab? As in SharePoint 2013 if you modify list view then it opens in same Tab so this same behavior want in SharePoint Online. Is there any way to open in same Tab on SharePoint Online List. Thanks, Harish PatilSharePoint list - Disable double click on list item which opens default edit list form
Hi All, I am using SharePoint online list. I want to disable double click on list item as this open SharePoint default edit form. Currently we are developed Canvas power apps on the same list. Also we have given access to list to open that form through hyperlink column. But user double click on list item it open defaults SharePoint edit form. How to disable double click on list item which opens default edit list form. Thanks, harish Patil
