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.

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.

What measures are you taking in SharePoint lifecycle management?

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!

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.

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.

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")

Summary

Microsoft will disable creation of classic publishing sites and pages in SharePoint Online starting March 1, 2027, and make existing classic user-created pages read-only by October 1, 2028. Custom scripting will be disabled. Organizations should assess usage and plan phased modernization to modern SharePoint experiences.

Message Center Link
https://admin.cloud.microsoft/?ref=MessageCenter/:/messages/MC1464926

Small shop, 5 of us doing IT for a few hundred users, all M365. Trying to figure out what people at our size actually run for a helpdesk because everything I look at is either overkill or per agent per month forever.

Also asking because I know at least two places that had some SharePoint based ticketing thing just stop loading in April when the add-in stuff got turned off, and they ended up on a shared mailbox again lol. One went to freshdesk, the other is still "figuring it out"

So far the answers I get are basically: shared mailbox, a sharepoint list someone built years ago that nobody wants to touch, freshdesk/zendesk/jira SM, one of the appsource ones (helpdesk 365, plumsail, steadypoint), or planner.

What I'm curious about

- what and why are you on and how long

- roughly what it costs you a year

- and does the per agent per month cost bug anyone else at our size or is that just me

Just want to hear what's actually working for people

Thx

Como posso mover uma biblioteca enorme pra outro site? Eu usei powershell mas acusa erro no tamanho por ser muito grande, e manualmente na interface não da certo pelo mesmo motivo, muito grande as pastas, eu não sei mais o que fazer pra movimentar, alguem tem uma dica?

As the title says, is there a way to search using wildcards that actually works?

E.g. I know there’s a file that exists that ends in “995-TR”, but I don't know the full name.

If I search:

• 995-TR
• *995-TR
• 995-TR*

SharePoint cannot find anything!

However, when I finally manage to track down the full filename and search for “ZXT995-TR”, it has no problems finding it.

So is there a wildcard that works?

And if not, how is it that something produced by such a large, established software company fails at basic search usability?

Inconsistent behavior has been identified in the search implemented with PnP Modern Search in SharePoint Online.

The filters are displayed correctly, show a consistent document count, and retrieve the values stored in the Managed Property. However, when selecting values that contain special characters (accents, cedillas, etc.), the search returns 0 results, even though there are documents associated with the selected value.

This behavior does not occur with values without accents. The filter displays the correct number of documents. When the value is selected, the result is 0 documents. A test was performed using KQL directly, and the documents were returned correctly.

✅ The documents are indexed.

✅ The Managed Property is populated.

✅ The Search Schema is functional.

✅ Direct KQL queries return the expected documents.

✅ The refiner retrieves the values correctly.

✅ The refiner correctly calculates the document count.

❌ Applying the filter through the PnP Search Filters component returns 0 results when the selected value contains special characters.

Has anyone else encountered this issue? What should be done in this situation?

Hi All,

Every month we send out a whole-staff newsletter. The newsletter is published in Sharepoint and sent out using the "Send as Email" sharing option to a dynamic email list.
Todays email doesn't send, instead we just get a very generic "this email could not be sent" error with no error code or troubleshooting info. The error message only shows when we try to send to the distribution list. When we try to send to a single person at a time, the error message doesn't come up but they never actually receive the email.

I have tried re-sending out previous months newsletters and get the same issue, so it's feeling like it's something broken on Microsofts side.

Is anyone else experiencing this issue?

Thanks

Hey y'all!

I work for a company that hosts a bunch of PDF documents about health that my team and I create. We are the only ones that manage them (so the site contents are exclusively managed by our small time).

Background:

We have 4000+ PDF documents. I've been trying to brainstorm solutions to improve search. I know I need to add metadata columns to the document libraries to document:
- language
- location
- health topic
(Among others).

The goal is to add these metadata tags to our existing documents, and refine the search to allow for filtering based on those metadata tags.

Goals:

Ideally, I wanted to move our PDF documents out of the 60 document libraries they live in. Because it doesn't make sense when we're updating things to need to go find the appropriate document library and do the changes. And the document libraries are doing what we would want metadata columns to do anyways (they are the general health topic).

Problems:

One issue is that the document libraries don't match up with what the health topics should be. And it's a weird amalgamation. We have a translations library (when the translated items should just be in the appropriate topic library, not a separate translation library), libraries for locations instead of health topics, etc.

My initial plan was to tag the documents with the appropriate metadata. Then either move them into one singular document library or move them into new document libraries built based off of the health topic.

The primary issue? We migrated to SPO from OnPrem. Our SP team set up a big redirect rule to replace the first part of the link with the new URL. But it keeps everything like "/[doc library name]/[filename.pdf]".

The links to our files are saved ALL OVER THE PLACE. Like thousands of hyperlinks to our pieces across different apps, SharePoint sites, etc.

If I change the document libraries that the pieces live in, all of those redirects break. This would've been an issue regardless I suppose, but this makes things even more complicated to me

My questions:

- What's the best approach to improving our overall catalog structure?

- Should we just keep all the document libraries and add the appropriate metadata tags?

- Is there any way we can set it up or create a system where we don't need to identify the exact document library a piece is in to update it (like a singular place to drag and drop)?

- Any general advice?

Hi everyone and thank you in advance for your help.

I'm trying to find a solution that has the following characteristics:

1. Is free or very cheap for about 128-300 logins a month.
2. Uses Auth0–or any other services that support authenticating a user via an sms
3. Can use OIDC or SAML to connect to third party applications
4. Can be used to log in people into a SharePoint site as a guest or unlicenced users in my tenant
5. One central "ledger" of people and their permissions, which sync automatically between Microsoft and Auth0
6. Isn't complicated to maintain, and preferrably doesn't have expiring certificates (my successors may not as tech savvy).

The use case: a Residents' Association. We already use phone numbers for everything including our WhatsApp and I understand sms authentication isn't the best but it's the only way that maximises the chances of participation. Anything requiring to create _yet another credential_ means we lose people who don't have much time or aren't tech savvy.

The issue is that I would like to hold one central register of RA members and their roles in one place, so that when there are any changes, the secretary only has to do them in one single place.

The more places to needed to make changes, the less likely it'll be done properly. I should add that we are volunteer run, and that our RA will be set-up as a Company Limited by Guarantee, with non-profit entrenched in our articles of association and constitution. However I understand many services require a charity status / FCA registration which we don't intend to do.

What do you think?

Have a user that needs to edit lists. I know I can go into "Site Contents" and just change permission to each list currently there. But I want to give the same access to any future list created. Is that possible for a single user to get edit access to the list feature?

This user is in the "site visitor" group so they have read only access on the site level and it needs to stay that way.

List A

1) Tital

2) Formula that opens List B filteded.

List B

1)Lookup column from List A

Have 5 views in List B but dont want people when presing tje link in List A to go to regular List and see all views or be able to change filter.

Is there a native way of doing so? Maybe I can open Page with a filtered web part? Dynamic filters dont look good

In case you're looking to learn more about what the HTML pages can and can't do.

Head over to your tenant and hit this page.

https://yourtenant.sharepoint.com/_html

I’ve noticed AI summaries of pages showing up on news feeds where it hasn’t been added. It’s blank in page details, you have to go into site pages and see the description column to read them.

is there any info about this? It’s a pain as it uses an emoji at the start, which I’ve been telling users not to do!

So a weird issue I’ve run into. I’m trying to give one of registrations read access to an SP list. I’ve followed MS documentation to grant the app Lists.selectedperation.selected and used the app id with a graph post to add the permissions. Now graph tells me it’s a success and when I run a get-pnplist for that list and enumerate its role assignments I can see the assingment. But the dev gets a 403 when he tries to run a get and I don’t actually see the newly created read grant using graph either. I created a test list on this site that’s inheriting permissions (the initial list ask had unique. Perms) and same issues.

Now when I test this on a different site. Everything is fine and I can see th read grant in graph and Pnp.

Not sure what’s up.