How do I check email users from SharePoint groups?

I have my SharePoint site "Group1" and the site has an email How can I see which users receive the email for this email? I am the owner and site administrator for the sharepoint, but I cannot find the location where this is specified.

My website has multiple owners, but only a few seem to have received the email. Where can I find the people linked to the email?

Access to SWF files in the SharePoint document library

We upload SWF files to a document library in SharePoint Online.

When we try to download the files with full url like Documents/Folder/file.swfthere is message in the browser 403 FORBIDDEN.

When we try to copy the URL of the SWF file using the "Copy Link" function, the URL is given as rather than folder path.

I found some articles like this and this that indicate that we can't upload SWF files to SharePoint Online. However, I can't find an official MSDN article about it.

How can I allow users to download files stored in the SharePoint document library?

sharepoint online – currency number in the email to the approver within the river

I have connected a SharePoint list to a PowerApp. In the sharepoint list there is a total cost field with the value 20.

The value 800.0000000000000 was displayed in PowerApps. I was able to change this to € 800.00 using the following formula: "€" & text (value (ThisItem.TotaalKosten; "en-US"); "($ -nl-NL) 0.00")

I also use an approval flow. In step & # 39; start approval & # 39; I added text for the approver in the detail field, e.g. B. the value of the Cost field. The details sent to the approver are given in a sentence with no spaces. So it looks like it doesn't support HTML.
And in the email the approver receives, the value 800 is rewritten as 800.0000000000000.

  1. Can you change that in currency?
  2. How can I ensure that the approval email contains whitelines?

Enter the image description here

sharepoint online – compare rows in the same column

I'm working on validating a SharePoint list. One of the requirements is contained in column A. no serial number included These are the numbers that differ in a way only +1 from each other.

For example in column A:







In this example, the number in the top 4 lines only differs by +1 and should return an error in the validation.

I found a way to extract the number separately from the character. However, you still need help comparing the different lines to identify the +1 different and the return error.

I hope to have help from the community. Thank you in advance.

Development – How do I get site collection and document libraries in SharePoint Online with MFA enabled?

I make a Winforms Program that allows users to connect to their own SharePoint Online environments to download and upload files from their document libraries. I am using the code below to get Site and List Objects. My current problem with this method is that a login window appears every time it is called (by GetWebLoginClientContext Method) and disappears because the user would have been logged in from the beginning. I need to use this method because it works with accounts that have multi-factor authentication enabled.

Is there any other way to log in to SPO with MFA enabled without having to see the popup every time it needs to be loaded? Sites and Lists ?

I've read about app-only authentication with client ID and client secret, but it only works with the SP site that creates the ID and secret.

    private void GetSitesAndLists(string siteUrl, out Dictionary teamSites, out List documentLibraries)
        using (ClientContext clientContext = _authManager.GetWebLoginClientContext(siteUrl))
            Web web = clientContext.Web;
            WebCollection site = web.GetSubwebsForCurrentUser(null);
            clientContext.Load(site, we => we.Include(w => w.Url, w => w.Title));
            teamSites = site.ToDictionary(w => w.Url, w => w.Title);
            teamSites = teamSites.OrderBy(kvp => kvp.Value).ToDictionary(k => k.Key, k => k.Value);
            ListCollection libraries = web.Lists;
            clientContext.Load(libraries, l => l.Include(li => li.DefaultViewUrl, li => li.BaseType, li => li.Title, li => li.BaseTemplate, li => li.Hidden));
            documentLibraries = libraries.Where(lib => lib.BaseType == BaseType.DocumentLibrary && lib.Hidden == false && lib.BaseTemplate == 101).ToList();                

Is it possible to delete files older than x days in a sharepoint folder using powershell?

I want to run a script every night to delete zip files that are older than 7 days. In documents I have a folder called Folder1 and in that folder there are subfolders with zip files. I saw examples of websites / lists but no folders. The following cold will return:

However, I would like to recursively delete all ZIP files in folder1 that are older than 7 days.

Try {
   #Setup the context
   $securePassword = ConvertTo-SecureString $SPOnlinePassword -AsPlainText -Force
   $Context = New-Object Microsoft.SharePoint.Client.ClientContext($SiteURL) 
   $Context.Credentials = New-Object Microsoft.SharePoint.Client.SharePointOnlineCredentials($SPOnlineUserName, $securePassword)

   #Get the List
   $List = $Context.Web.lists.GetByTitle($ListName)

   #Define CAML Query to Filter
   $Query = New-Object Microsoft.SharePoint.Client.CamlQuery
   $Query.ViewXML = "

   #Get List Items
   $ListItems = $List.GetItems($Query)

   Write-host -f Green "Number of List Items Found:"$ListItems.Count
   write-host $ListItems.Name
   #Get Each Item's Created Date
   $ListItems | ForEach-Object { Write-host ("List Item:{0} was created on {1}" -f $_("FileLeafRef"), $_("Created")) }

   foreach ($item in $ListItems) {
Catch {
   write-host -f Red "Error:" $_.Exception.Message

Edit: The code above works until I get Fehler Error: Exception when calling "ExecuteQuery" with the arguments "0": "The operation has expired."

Are there any restrictions on the SharePoint Server 2016 trial?

Does the trial version of SharePoint Server 2016 have a limitation just to be a trial version?

How long can I use it before it explodes?

I want to be able to explore some advanced features, such as:

  • Hybrid architecture
  • Power BI
  • Create some SP add-ins
  • Migrate large amounts of data

I need time to create some POCs and present them to some people. Can I back up a test SP farm before it explodes, and if I activate my license, can I continue where I left off?

sharepoint online – column not visible in the new library settings and library views

I created a site column with a field definition that contains hidden equal to true and added this site column to the document content type. Now I have created some content types that inherit the document content type and the content types used by libraries. Now I have a situation where I have to display that particular site column in library views.

To do this, I get the field of the document content type and set it to false and update the field.

This way I can add the column in the library views, but the problem is that when I create a new library, this column is not visible to add to a view.

Field field = clientContext.Web.GetContentTypeByName(contentType).Fields.GetFieldByInternalName(siteColumn);
field.Hidden = false;
clientContext.ExecuteQueryRetry(ConfigHelper.ThrottleRetryCount, ConfigHelper.ThrottleDelay);

and tried this too

Field field = clientContext.Site.RootWeb.Fields.GetFieldByInternalName(siteColumn);
field.Hidden = false;
clientContext.ExecuteQueryRetry(ConfigHelper.ThrottleRetryCount, ConfigHelper.ThrottleDelay);

Managed Property – SharePoint Online (Modern) – Create a tenant-wide category for messages that is suitable for all site collections

SharePoint Online (Modern) – Create a tenant-wide category for messages that is suitable for all site collections.

I want to implement a messaging solution on my intranet that uses categories as a filter.
I have this in a single collection, but I need this to work with the filters across collections in my tenant.

The problem I have is that when I select a news source that is not in my local collection, I can no longer filter by categories. I will explain …

Local collection that works (This site)

-I choose "This Page" as my news source and then scroll down to "Filters".
-I choose "Page Properties" and then the "Property Name" of my custom category "Message Destination" is available.

Cross-collection does not work (select sites)

-I choose the collection from which I want to retrieve messages.
-I choose "Managed property" as "Filter" (page properties are no longer available).

Here is the crux of my problem. How can I get News Target custom files to appear as a "managed property" in all site collections, just like I did with "Page properties" in a single collection?

Ideally, I would like a drop-down menu from my term store called "News Target" for news sites / articles in the page library, but at this point everything would be better than nothing. I tried to create tenant-level content types and couldn't get it to work.

Does anyone have any ideas on where I can get more information on how to create a kind of "managed property" that can be used as a filter that I can apply to messages on the page library?