Not able to create a Gallery View that works
Hello all! I'm trying to create a Gallery View on a Sharepoint list, but when I create it the only thing that I'm able to see is that: If I try to format de view, I'm not even able to see the option Card Designer. Doing the same steps in any other list on the same Sharepoint site works perfectly ok, being able to see the information in a gallery format. I have checked the fields, the settings of the list and everything... and all seems ok. If someone has had the same 'incident' before and has been able to solve it, I would highly appreciate your help. Thanks!Excel to Microsoft Lists: Import Multi-Choice Columns the Smart Way! 🚀
✨ Want to import an Excel table into Microsoft Lists without losing multi-choice column data? This video shows you a smart workaround that lets you: Use ;# to separate multiple values in a cell Import those into SharePoint / Microsoft Lists as Choice columns Automatically convert them into an array for use with JSON formatting, filters, and searches Say goodbye to manually editing items one by one! 🙌 👉 Follow me for more Microsoft 365 & SharePoint tips! 📌 Post inspired by: LinkedIn post kudos to Federico Sapia
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.
