Questions tagged [powershell-script]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
1 vote
1 answer
2k views

SharePoint online ExecuteQuery command giving exception

I am writing a powershell script to copy the sharepoint online list items from one sharepoint online list to another while that list consist of 77 fields. I am getting below error. While the same copy ...
0 votes
1 answer
1k views

Powershell script that outputs all workflows,their title and status from sharepoint 2013 site that has workflows attached to every list

The SharePoint 2013 site has a few subsites and each subsite has further subsites that have lists in it. To these lists there is a workflow attached. How do I write a powershell script to retrieve ...
0 votes
1 answer
1k views

Delete unique permissions of a File or Folder in a document library

I have a document library which has 3 folders in it and inside each folder there is a document (docx, xls, ppt). My objective is to iterate every file inside my document library and check if It has ...
0 votes
1 answer
2k views

Converting DOC to DOCX within SharePoint Online

Based on this solution to convert .xls to .xlsx, is there a way to convert .doc to docx within SharePoint Online? We migrated a lot of files and folders from NTFS folders to SharePoint online but did ...
2 votes
2 answers
13k views

Conversion of csv file to xlsx via Flow or SharePoint

I have a Flow to store email attachments (in .csv format) to SharePoint. Now, I want to use the file in Power-BI from SharePoint. However, I want the file in .xlsx format. Could you please suggest how ...
1 vote
1 answer
3k views

Get-PnPList cmdlet not returning anything

I'm trying to retrieve information from two columns on a sharepoint list in order to use them in powershell. Here's my code so far: $SiteURL = "https://xxxx.sharepoint.com/sites/xxxxx/" ...
0 votes
1 answer
13 views

Get-Team cmdlet runs but returns no data

I attempting to create a PowerShell script which will return a complete list of Teams in an M365 Tenancy as a csv file. My script appears to run successfully but it does not return the expected data. ...
4 votes
1 answer
3k views

Get users who have permission through a sharing link Powershell sharepoint Online

I want to generate a report of every document and permissions on it. Permissions contains General Permission and Users who have permission through a sharing link/ or external sharing link. When I run ...
0 votes
0 answers
17 views

Bulk file move same file extension

I need to move files with from user. Sharepoint.com to user.onedrive.com. I tried using the SharePoint Migration Tool but it’s giving an error. Can someone help me with the easiest way to code this?
0 votes
1 answer
306 views

.Replace() will return empty string inside my Powershell script

I have the following PnP PowerShell to get the URL of a file and remove the ".lock" string from the file name using Replace:- $url = $item.File.ServerRelativeUrl Write-Host "$(Get-Date) ...
0 votes
0 answers
25 views

PnP Script which work on file modified on 10 March 2023 >> restore previous version >> rename the restored file

We have someone who have modified many files on 10 March by adding .lock extension to the files so Test.xlsx become Test.xlsx.lock. so can i write a power shell script which do the following:- ...
0 votes
2 answers
272 views

Query more than 8 Lakhs (0.8 million) documents from SharePoint Online document library using Power Automate

I have a document library with the document set content type and document content type in it. In the document library there is more than than 8 Lakhs (0.8 million) document. In the "My Document&...
0 votes
1 answer
148 views

Need a powershell script to update 300+ SharePoint SitePages

Is there a PowerShell/PNP script that will update all "Highlighted Content" web parts within multiple site pages within a site? Need to update the web part Layout from "Grid" view ...
0 votes
0 answers
194 views

Finding and Deleting All Instances of Files Matching a Specific Name

Is there a way of being able to find files within multiple Document Libraries matching a specific name and deleting all of them? I have written a script using the Find-PnPFile and Remove-PnPFile ...
0 votes
2 answers
689 views

Get service account details and their usages in SharePoint Environment

We have lots of service accounts in our SharePoint environment, now we are planning to delete the unwanted service accounts from our environment to keep the environment clean. So, I was checking ...
1 vote
1 answer
725 views

Is it possible to create a one note file in SharePoint document library from Powershell

I was hoping if someone has created a OneNote notebook file from Power Shell command and stored it in a document library in SharePoint Online. We can create sections and page of OneNote file from ...
0 votes
2 answers
4k views

How to get all column and type and internal name in my site by PnP PowerShell

I'm using ModernUI for SharePoint Online. I'd like to get all List and Library's ColumnName, Type, InternalName in my site by PnP PowerShell. I did some research myself, but I didn't understand, so I ...
2 votes
1 answer
1k views

How to export powerapp solution (.Zip file) using powershell or pnp script?

I need to download the PowerApps(canvas app) solution package(.Zip file) by using PowerApps PowerShell script or pnp script. Anyone suggest me if it is possible.
0 votes
1 answer
29 views

Can anyone provide automate script to add/deploy/update solution in SharePoint 2016

Can anyone provide automate script to add/deploy/update solution in SharePoint 2016. So that developers can run this batch file without help from SharePoint Administrators. And please suggest me best ...
0 votes
0 answers
35 views

PowerShell script to change SharePoint Designer workflow status

I want to change the status of workflow using PowerShell script. If you go into workflow settings in a library in SharePoint, and click on Remove a workflow, you see the 3 settings I'm referring to: &...
0 votes
1 answer
2k views

Export and get the list of Orphaned users from SharePoint 2016 On premises - using PowerShell

I'm using SharePoint 2016 On-premises server, we have two main site collection, I need to get a list of orphaned users in each site collection. I've come across this PowerShell script mentioned here ...
0 votes
1 answer
5k views

Edit Suite Bar Links in SharePoint 2019

I have tried all of the solutions provided for editing the Text in the Nav Suite Bar in SharePoint 2019. I am trying to change the text from "SharePoint" to "Intranet" or the name of our company. I ...
0 votes
1 answer
684 views

Q. SharePoint Online - Setting LockState property via PowerShell not successful and no error reported

I have been attempting to Unlock a ReadOnly site in SharePoint Online. I have tried with PNP Connect-PnPOnline $SiteURL -Credential $Cred Set-PnpSite -LockState "Unlock" I have tried with ...
0 votes
2 answers
340 views

Add and delete Sharepoint Groups from site

Thanks for you time reading this. We are a Technical School that's using Sharepoint 365 as way to collect files and resources. We have to open a Sharepoint to each class and I'm compiling a Powershell ...
0 votes
1 answer
470 views

How to verify retention labels at site level?

In our SharePoint Online, we have n number of sites where retention labels are being assigned for the contents. Though, we are not sure if we have labeled everything and would like to verify what has ...
0 votes
1 answer
217 views

Caml Query | How to copy today's list items from one SharePoint online list to another in batches?

I am trying to write a Caml Query to get only today's list items and then later copy it into the new list. I am using the batch method to copy data from source list to destination. source list gets ...
0 votes
1 answer
158 views

How to pick up data using PowerShell from SharePoint Web Parts

We have a manual process at the moment where we have assigned "Content Owners" to out Sites/Sub-Sites. Content Owners, essentially have no greater permissions than regular users, but our Governance ...
0 votes
1 answer
67 views

Sharepoint 2013 - Script to Allow Sharing Site or library only to administrators

I'd like to disable sharing to all members except administators on ALL Site Collections. Is there a Powershell command that match my request ? Or maybe only admistrators will approve sharing request. ...
0 votes
1 answer
24 views

Workflow to be run for every specific document or content type?

I will need to look for the solution to implement the manual script initiation for specific file type in the document library (ex. force unlocking a document). Idea is that I will add additional ...
1 vote
1 answer
35 views

Best way to chain together two SPO cmdlets

In the Sharepoint Online Management Shell my goal is to call the cmdlet Invoke-SPOSiteDesign (doc) with one fixed Design (i.e. the -Identity parameter) onto all SPOSites on my tenant. I can get all ...
0 votes
3 answers
1k views

several site collection add into "Readonly" mode using powershell script

We have 100+ site collections on csv file and we need to mark all sites into "Read Only" mode access based on csv file using powershell script. Anyone suggestion highly appreciate. we am ...
0 votes
0 answers
326 views

Getting Forbidden error while connecting to SP Online using CSOM Powershell

I have one powershell script where I am connecting to SP 2013 Library to download a file using Server side powershell script. After That in the same script file I am trying to connect to SP Online ...
0 votes
1 answer
849 views

How to update "Lookup column" values from csv to Sharepoint Online using Powershell Script?

I have a Parent list called country and the child list where I want my values updated is call Continents. the lookup filed name in Continents is "Country". Any help will be greatly ...
0 votes
1 answer
136 views

How to get last crawl duration in SP 2013 using power-shell

I'm using the below PowerShell commands to get the last crawl duration. when the Crawl In-progress the 'Crawl Completed' field is empty, I the output as duration in negative values. Could you please ...
0 votes
2 answers
3k views

Check who has given permission to a user in sharepoint online

In sharepoint line for a site I have a few site owners. One owner has stopped inheriting permissions for a library and a folder and gave access to a user. As a tenant admin I want to know who that ...
0 votes
1 answer
959 views

powershell script to replace a user Identity with a different identity

I'm having SharePoint 2016 On-premise environment, now we have a requirement as follows. we have nearly 100 SharePoint Groups, where we had already have many user's identity added as DOMAIN\username ,...
0 votes
1 answer
350 views

SharePoint site is lock

I ran below script to unlock SP site. $admin = new-object Microsoft.SharePoint.Administration.SPSiteAdministration (“Site-Collection-URL”) $admin.ClearMaintenanceMode() Getting below error message ...
1 vote
1 answer
641 views

security error:script execution is disabled on this system:I can’t access Sharepoint from Powershell

I am in the process of configuring my Sharepoint Framework development environment, I installed node.js and visual code everything is fine but after the powershell level I ran into this error that I ...
0 votes
0 answers
727 views

Powershell Convertto-HTML from list items also outputs raw objects before the actual HTML

I am writing a Powershell Script to read SPListItems, create a PSObject for each, add it to the PS Array and after the loop ends I use the following to convertto-html myArray | convertto-html -path .....
0 votes
2 answers
720 views

How to count number of lines and words in a SharePoint online Page

I am requested to generate a report that illustrates the number of pages and plus the count of words on each page, and the number of files in that site (word, PDF, images..etc.). Is there any custom ...
0 votes
2 answers
1k views

How do I delete a specific folder from SharePoint using Power Shell script?

I have multiple main folders on SharePoint online each with their own sets of sub-folders and files. I need to delete a specific folder (and its full contents including any sub-folders and files) from ...
0 votes
1 answer
2k views

Power Shell Error: Exception calling "ExecuteQuery" with "0" argument(s): "File Not Found."

I am building a script to essentially copy an entire directory to a SharePoint online library. I have gotten as far as building the folder directory on SharePoint but cannot seem to load any files ...
1 vote
2 answers
1k views

How to copy a network share directory to SharePoint online using Power Shell

I am trying to write a script using Power Shell to copy an entire Directory (Main Folders, Sub-Folders, and all Files in between) on a Network Share to SharePoint online. The most I have accomplished ...
3 votes
3 answers
1k views

SharePoint Online credential is not working in PowerShell

I am able to log in to my SharePoint online site using my credential but when I am connecting to the same SharePoint online site using the same credentials using PowerShell CSOM - getting the invalid ...
0 votes
1 answer
78 views

p1 script not running with schedule job

I have SP2010 in WIN2008R2, i have script(datemodifier.ps1) to update the diff of 2 dates in SP list daily, When I run the script manually its updating the list, but when i schedule it with a task on ...
0 votes
1 answer
1k views

Powershell script to get workflow tasks for each list item

I have a lot of number of webs (sub-sites) within a site collection that have lists that have list items with Approval workflows running on them. How would I get all tasks for each list item in ...
0 votes
2 answers
916 views

Not getting All FieldValues in Powershell CSOM Sharepoint 2016

I have created powershell script to get File/Folder Size details of Sharepoint site. However, I am not able to get all fieldValues of listItems. I am getting values for $listItem.FieldValues["...
3 votes
1 answer
378 views

Run a PowerShell script interactively on a SPO site (modern)?

So, I've found my perfect PowerShell script to archive Groups in a really nice way. The PS script is interactive and "asks some questions" (Prompt command), so to speak. :) The script looks as follows:...
0 votes
1 answer
330 views

get list of al users on farm level on SharePoint 2010 application

I am trying run below script on SP 2010 environment for getting list users on farm level. But i am getting error. Can someone please correct me. Powershell script Add-PSSnapin Microsoft.SharePoint....
0 votes
2 answers
51 views

Need help on running PowerShell command related to Sharepoint Client ID

By referring i see that i need to run the command but when i try to run i am getting below error PowerShell Command When i run i am getting below error i am new to powershell and i dont know what ...