Hey everyone,

I'm working on setting up some straight-to-the-point, step-by-step guides for common SharePoint Online + Power Automate headaches.

Instead of just guessing what to focus on next, I want to address actual real-world bottlenecks people run into daily.

Whether it's setting up automated deadline reminders based on dates in your SP lists, sending dynamic emails to people pulled from person columns, or dealing with folder permission changes via HTTP actions—what’s driving you crazy right now?

Drop your biggest issue in the comments below. I’ll try to look through them and work out the exact step-by-step fix for you.

What measures are you taking in SharePoint lifecycle management?

We have moved alot of our traditional files from Windows server file shares into SharePoint, but now coming up against the storage limits, unless we buy more storage.

Our firm/users will not allow for any files to be deleted indefinitely, however, we could archive them based on various parameters, e.g. size, age etc.

Curious how are others doing file archiving? Any specific tools or software being used? Using the native Microsoft archiving?

Im not looking for a backup solution, we do that already. More of a data lifecycle effort, keep our storage use low, but give the ability for general users to retrieve old data if needed

Would you believe that the creation and deletion of SPO site groups are not logged in MS Purview? Crazy stuff Microsoft...

A group "disappeared" the other day, number of factors at play and no answer will be found.

MS Purview only logs the modification of its membership and its application onto lists and items. The more you know folks.

EDIT:

https://learn.microsoft.com/en-us/purview/audit-log-activities#site-permissions-activities

Thank you pimpinthebox and AI, I double checked the doco and there it is.

About two dozen CSV extracts end up in different SharePoint folders for departments around the company. The data comes from SQL Server, mostly on weekly schedules.

Generating the files is rarely the problem. Some come from SSIS, some from SQL Agent jobs, and then a few different PowerShell scripts handle the SharePoint upload.

That's the part I keep fixing.

Someone renames or moves a folder and the upload fails, while the SQL side of the job has already completed successfully. From the department's point of view, this week's file just never appeared.

The scripts have also accumulated over the years, so there isn't really one place to check what was delivered and what failed.

Has anyone standardised this kind of recurring file delivery into SharePoint? I'm less interested in rebuilding the SQL extracts than replacing the collection of upload scripts with something easier to monitor.

Our finance team currently have an ancient Excel file with a VBA macro that they use to get the contents of a folder and compare data with

Currently this points at our on-prem NAS and we'd like to move them away from that into Sharepoint.

So rather than pointing at

\\file-nas-01\finance\data

it points at

https:\\[sharepoint].finance.com\folder\folder

Is there a good resource to help convert this into an Office Script?

Or am I able to just reframe the full VBA into an office script and are there any guides to do so?

Some of the code from the VBA Macro below;

    ' setting the variables for the process
    Dim folder_path As String: folder_path = Cells.Find("Folder with files you want to count:").Offset(1, 0)
    Dim document_type As String: document_type = Cells.Find("What type of files do you want to check?").Offset(1, 0)
    Dim next_history_row As Long: next_history_row = Sheets("History of Counter").Range("A1048576").End(xlUp).Row + 1
    Dim total_count As Long
    Dim total_money As Double

    'getting the total count of the files and the money value of the files
    total_count = get_file_count(folder_path, document_type)
    total_money = get_money_from_files(folder_path, document_type)

    'Put the next row of data in the history to record outcomes of what folder was checked,
    '   for what type, by who and when
    Workbooks(ThisWorkbook.Name).Sheets("History of Counter").Range("A" & next_history_row) = folder_path
    Workbooks(ThisWorkbook.Name).Sheets("History of Counter").Range("B" & next_history_row) = document_type
    Workbooks(ThisWorkbook.Name).Sheets("History of Counter").Range("C" & next_history_row) = total_count
    Workbooks(ThisWorkbook.Name).Sheets("History of Counter").Range("D" & next_history_row) = total_money
    Workbooks(ThisWorkbook.Name).Sheets("History of Counter").Range("E" & next_history_row) = Date
    Workbooks(ThisWorkbook.Name).Sheets("History of Counter").Range("F" & next_history_row) = Environ("username")

I'm sure this has come up, but my SP online is not connecting with the redirect too many times message. I'm creating a new tenant in Entra, licensed everyone with E5, and waited a couple of hours before attempting. I log into office fine, but when I click on the SP web app, I get the message and the page won't load. Besides clearing cookies, which don't work, does anyone have a fix? I have tried on multiple accounts using multiple different Win 11 clients.

I’m using a Microsoft List as a record of about 1,000 items that I’d like to share across our organisation. This will be regularly updated over time.

I recently discovered that other users do not get the same search results as my team does. For a query that should return 32 items, one user gets zero search results, while another gets 8. A few hours later, the second user got 15 results.

These users were given access to the list only 30 mins or so before they tested the search.

My basic understanding is this might be caused by the time it takes for Microsoft to index the list. Does that seem likely?

We need the list to be searchable instantly. Is there any way to achieve this?

Would giving users access sooner allow more time the list to be indexed? Or does it only start indexing once a user has accessed a list?

Is creating a Power App the only option? If so, can this be done by a total beginner?

Any help or ideas would be much appreciated!

Hello,

I am new to SPO and am looking for some tips. We recently migrated to SPO from on-prem and are getting several complaints on the user experience when launching SPO. Users are often getting the "Something went wrong" screen or just a blank white page that is requiring them to clear their browser cache.

Most all our users are in the office, so they are coming from trusted IPs and joined devices so we have CA policies in place to ease the login experience (SSO, sign-in frequency every 48 hours, etc). From the sign-in logs, authentication is working, its just that SPO doesn't load.

What am I missing? What tips and tricks have the veterans configured to make the experience a little smoother for your users? Any advice would be much appreciated.