Connect to SPO from Azure automation runbook using a certificate
How to connect to SPO using Pnp powershell Connect-PnpOnline using a certificate with script being executed from Azure automation runbook. I have exported a self-signed certificate and uploaded to Azure Automation. When I use the following it does not work. Another thing I noticed is that Connect-PnPOnline requires a certificatePath paramater. What are my options here when certificate is stored in Azure automation. This does not work: Connect-PnPOnline -Thumbprint "3234234" -Url $url -ClientId $clientId -Tenant "tenant.onmicrosoft.com" Alternative, with script being run from runbook what could I use for path Connect-PnPOnline -CertificatePath "??????" -CertificatePassword "3234234" -Url $url -ClientId $clientId -Tenant "tenant.onmicrosoft.com"
Rename-pnpFile gives me access denied with admin rights
Hello! I have problems renaming my files. I'm using these commands: #this is one command i tried connect-pnponline -url "https://contoso.sharepoint.com/sites/Clients" -interactive -validateconnection $file = Get-PnPFile -Url "/sites/Clients/folder/subfolder/IT_testi_password.txt" Rename-PnPFile -SiteRelativeUrl $file -TargetFileName "renamedfile.txt" -Force -Verbose # this is another connect-pnponline -url "https://contoso.sharepoint.com/sites/Clients" -interactive -validateconnection Rename-PnPFile -SiteRelativeUrl "/sites/Clients/folder/subfolder/IT_testi_password.txt" -TargetFileName "renamed.txt" -Force -Verbose I tried those commands too with overwrite but I only get access denied (I dont know what is checking to say me that because i can put everything in the source and it says me same ) the error: #I'm putting this error to show that i can put anything i want Line | 4 | Rename-PnPFile -SiteRelativeUrl "asrfeqrew" -TargetFileName "workingc … | ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ | Access denied. PS /Users/user> #and this one is a common one Rename-PnPFile: /Users/user/Desktop/project/Scripts/Untitled-1.ps1:4:1 Line | 4 | Rename-PnPFile -SiteRelativeUrl "/sites/Clients/folder/subfolder/IT_testi_password.txt" -T … | ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ | Access denied. I'm using visual studio with a mac and have Sharepoint administrator right, also i can rename the same file via web. Can someone help me with this problem?SharePoint (2019) PowerShell Command for SPSite.WebApplication.Properties
We are trying to set and get properties in WebApplication using following code SPSite site = new SPSite(<SiteUrl>) // or SPSite site = SPFeatureReceiverProperties.Feature.Parent as SPSite // set property site.WebApplication.Properties.Add("Property1", "Value1") // get property site.WebApplication.Properties["Property1] We don't get any errors in above code. Now, we want to get and update this property via powershell. We have already tried following commands: 1. Get-SPWeb $site=Get-SPWeb -Identity "<SiteUrl>" $site.Properties 2. Get-SPSite $site=Get-SPSite "<SiteUrl>" $site.WebApplication.Properties 3. Get-SPSite (OpenWeb()) $site=Get-SPSite "<SiteUrl>" $web=$site.OpenWeb() $web.Properties Unfortunately, we were unable to retrieve or set the property using these PowerShell commands, which corresponds to the functionality used in the .NET code. We need assistance in determining how to update or retrieve the property set using the mentioned code via PowerShell.
Merge the content of two folders while moving or copying if their name is same.
Is there any way, or the simplest way to merge the content of two folders when their name is the same, while we are moving or copying the folder? For example, if we move a folder named "A" and there is already a folder named "A" in the destination then, the content of source folder "A" should get merged with the destination folder name "A". This can be tested in windows explorer, if you create two folders of the same name in two different locations, and then try to copy or move the folders in that location, then you will see that the data in the destination folder is a merged version of both the folder. How to implement this in SPFx using SharePoint APIsHow to use SharePoint search query with SharePoint Granular access permissions?
I want to execute SharePoint search API with granular access for that I've changed 'Sites.ReadWrite.All' permission to 'Sites.Selected' permission, so that application would have all sites access but during search I'm getting unauthorize error ``` {"odata.error":{"code":"-1, Microsoft.Office.Server.Search.REST.SearchServiceException","message":{"lang":"en-US","value":"Unauthorized."}}} ``` Also tried to give sites.selected permission at tenant level, that also not works, if the only solution is to give 'Sites.ReadWrite.All' or 'Sites.Read' then there is no use of granular level access implementation Sites.Read.all will allow all sites if granted. My query is similar to below -: https://tenant.sharepoint.com/_api/search/query?querytext='*+AND+(Path:"https://tenant.sharepoint.com/sites/SITE1/RECORDS" OR Path:"https://tenant.sharepoint.com/sites/SITE2/RECORDS")'&trimDuplicates=false&selectProperties='Column1,Column2'&refiners='Column1OWSTEXT'&refinementFilters='Column1:equals(\"xxxxx\")'&rowLimit=5 Some other references regarding my question. https://sharepoint.stackexchange.com/questions/306397/how-to-use-sharepoint-search-query-with-sharepoint-granular-access-permissions?newreg=dbcbb62ae019481c9a864f537ecd0faf https://sharepoint.stackexchange.com/questions/306432/is-that-sites-selected-permissions-level-allows-the-sharepoint-online-global Really appreciate any response on this or alternative approach to to achieve this.
Cannot create new site page by choosing saved template
I am trying to create a new site page, however i am not able to save the page by using save as draft nor able to publish it. The page keeps on auto saving at the back end and creates multiple copies under site pages. Inner-Message: Invalid data has been used to update the list item. The field you are trying to update may be read only. Exception-Message: We're sorry, we encountered an unexpected error. Please refresh the page and try again. Refreshing the page does work out, but it removes the web parts in the saved template, which is not helpful. can anyone please help me with this.SharePoint App-Only authentication security risks
I am assessing the security risks associated with older SharePoint App-Only authentication method. As per my analysis, this method is less secure than using the Azure AD App Registrations. Both SharePoint App and an Azure AD App can authenticate with just a Client ID and a Client Secret. Anyone with these two properties can connect and invoke the APIs from anywhere in the world. However, with Azure AD App, we have some protection offered by Azure AD built-in intelligent algorithms that could detect or protect against a potential attack. Furthermore, we could use Conditional Access for Workload identities to secure these principals. On the contrary, SharePoint App Only method does not have that protection as it bypasses the Azure AD completely, no conditional access policies apply. Has anyone out there evaluated the security risks of these two and could share their thoughts?
