Setting Alert functions on folder in Sharepoint

[ACinOKC]

Good day all!

In creation of a SharePoint site part of my flow is to create folders and subfolders in the Documents section of said newly create site.

My question is, how, if possible, would I go about setting the "Alert Me" settings for specific folders that were just created?

Am I asking that correctly, in the correct location?  Appreciated in advance!

[AKRogers]

Hi there!

There isn’t a great way to set the “user alerts/alert me” in SharePoint from Power Automate. This is because there’s not really support for using the alerts web service or the wrapper, SPServices, from inside Power Automate. You could potentially use the HTTP action to talk to the web service, but I think it might not be necessary depending on what notifications you’re after.

Instead, I suggest setting up a flow that alerts the appropriate user(s) to changes in the document library. The trigger would be “when an item is created or modified.” You may need to be creative about how to isolate the changes you are looking for, so let me know if there’s more there you’d like to explore.

Take care!
Ashley

If this answered your question, please mark it as a solution so that others can easily find it. If you liked it, consider giving a thumbs up!

[RobElliott]

Potentially I would amend Ashley's (@AKRogers)  trigger slightly and use When a file is created in a folder as then you can select the folder. The downside is that if you have lots of folders it will result in multiple flows.

Rob
Los Gallardos

[Pstork1]

There are no actions in Power Automate that will let you set an alert in SharePoint. Usually, when there isn't a direct action you can do it through an HTTP REST call, but it appears that alerts can only be set using the UI or Client Side Object Model (CSOM).  There is no REST equivalent.   So I don't think you can use a flow to do what you are attempting.

[ScottShearer]

@ACinOKC 

Please see my screen shot below.  I check the "Is Folder" property for true or false.  If true, then the item created is a folder.  You can add logic to send email when folders are created in specific locations of with specific names.  Does this meet your requirements?  If so, you might also consider adding similar logic as a trigger condition rather than as a condition in the Flow.  If you do that, the Flow won't even start unless a folder has been created.

[v-alzhan-msft]

Hi @ACinOKC ,

There is no any way to set the alert in Microsoft flow currently.

Best regards,

Alice       

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[ACinOKC]

Good morning and thank you all so very much for responding!

Alas, the nice thing about utilizing the "alert me" function vs a flow is that when we hand off the sharepoint site to the team lead, they can manage the alerts going forward.  Inviting new members, removing old ones within "alert me" instead of opening the door to ALL of the flows that we have just to make these small changes.

Sounds like this will have to be one of those "please implement this solution Microsoft" as there isn't a function to even handle this.  Any CSOM type of solution would require executables and isn't feasible here, right?

[Pstork1]

It is possible to use CSOM in PowerShell and its also possible to have Flow invoke remote PowerShell on a server.  Both are pretty advanced, but it is possible.  Here's a post that explains how.

https://practical365.com/microsoft-365/how-to-run-powershell-scripts-to-automate-manual-processes-in...

[ScottShearer]

@ACinOKC 

Please note that a Flow can send an email to any valid email address.  So, there is no need to modify the Flow as team members come and go if you use a distribution group, etc..  All that would need to be done is add/remove members from the group as they come and go should you want to use the Flow solution.  There should be no need to edit the Flows.