Questions tagged [powershell-script]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0 votes
0 answers
15 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?
Lisa Jefferson's user avatar
0 votes
1 answer
237 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) ...
John John's user avatar
0 votes
0 answers
24 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:- ...
John John's user avatar
0 votes
0 answers
85 views

Bulk add owner to all Teams using PnP PowerShell?

I need some help in adding my admin account as one of the owners of all my Teams group using the Powershell https://pnp.github.io/powershell/cmdlets/Add-PnPMicrosoft365GroupOwner.html Because without ...
Senior Systems Engineer's user avatar
0 votes
0 answers
24 views

Powerhellscript for powershell 5.1 sharepoint

How to create a script in powershell 5.1 that gets list of site collections , Url, admin, size in MB, Title, number of Share Point Lists, number of share Point document libraries, number of SharePoint ...
Tej's user avatar
  • 1
0 votes
2 answers
148 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&...
SP 2022's user avatar
  • 4,014
0 votes
1 answer
109 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 ...
Luke's user avatar
  • 13
0 votes
1 answer
1k 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 ...
Andrew Wright's user avatar
0 votes
0 answers
104 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 ...
EverGrateful's user avatar
0 votes
2 answers
557 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 ...
SP 2022's user avatar
  • 4,014
2 votes
1 answer
884 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.
PGP's user avatar
  • 1,115
0 votes
1 answer
28 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 ...
Srinu Dasari's user avatar
0 votes
0 answers
33 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: &...
user99500's user avatar
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 ...
G.F's user avatar
  • 1
0 votes
1 answer
520 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 ...
EFighter's user avatar
0 votes
2 answers
296 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 ...
Vítor Verdura's user avatar
0 votes
1 answer
316 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 ...
Jag's user avatar
  • 1
1 vote
1 answer
2k 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/" ...
Ress's user avatar
  • 85
0 votes
1 answer
202 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 ...
ParshvaShah's user avatar
0 votes
2 answers
3k 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 ...
Hyonta's user avatar
  • 115
0 votes
1 answer
62 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. ...
Mapow's user avatar
  • 5
0 votes
1 answer
20 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 ...
Marko Farkas's user avatar
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 ...
Giraphi's user avatar
  • 113
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 ...
murali kuruva's user avatar
1 vote
1 answer
668 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 ...
Ankit Kumar's user avatar
  • 1,768
0 votes
0 answers
304 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 ...
Kailash Sahoo's user avatar
0 votes
1 answer
755 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 ...
Prachi Vijayvargiya's user avatar
0 votes
1 answer
108 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 ...
taruki_MS's user avatar
0 votes
2 answers
2k 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 ...
santosh kondapalli's user avatar
0 votes
1 answer
843 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 ,...
Jegan Baskaran's user avatar
0 votes
1 answer
259 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 ...
user3210176's user avatar
1 vote
1 answer
581 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 ...
chiraz azzabi's user avatar
0 votes
0 answers
672 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 .....
Ali's user avatar
  • 1
0 votes
1 answer
1k 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 ...
Jegan Baskaran's user avatar
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 ...
Tomcat1208's user avatar
0 votes
2 answers
656 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 ...
Dreamer09's user avatar
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 ...
Tomcat1208's user avatar
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 ...
Tomcat1208's user avatar
3 votes
3 answers
942 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 ...
user1133737's user avatar
0 votes
1 answer
75 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 ...
user3877505's user avatar
0 votes
1 answer
951 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 ...
frnorke's user avatar
  • 31
0 votes
1 answer
131 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 ...
Quasam Amanat's user avatar
0 votes
2 answers
877 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["...
Vishal_chorghe's user avatar
0 votes
1 answer
311 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....
murali kuruva's user avatar
0 votes
2 answers
49 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 ...
Abdul Azeez's user avatar
0 votes
1 answer
442 views

Set People picker field with sharepoint group

Is it possible to set a People picker field with SharePoint Group using powershell script ?. Thank you.
user1514428's user avatar
1 vote
2 answers
1k views

Excel/Powershell to extract substring from a URL

I want to extract root URL from full URL. how to extract that based on number of "/" in that. for example: https://teams.SharePoint.com/sites/site/communities/subsite from this URL i want to ...
Adarsh Awasthi's user avatar
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 ...
user11726782's user avatar
0 votes
0 answers
29 views

Restore/change text/background colors in sharepoint online management shell

I changed colors under properties > colors to improve readability but: 1/ the colors don't reflect the changes I made 2/ I can't restore defaults or make any other changes. I uninstalled and ...
matt's user avatar
  • 589
0 votes
1 answer
292 views

Less than symbol in formula causes error in calculated column when applying site design

I'm producing a site design script for SharePoint Online in PowerShell using Add-SPOSiteScript as per these instructions, and I can create the script and add it to a site design without any errors. ...
Bassmanjase's user avatar