Questions tagged [powershell-script]
The powershell-script tag has no usage guidance.
67
questions
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?
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) ...
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:-
...
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 ...
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 ...
- 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&...
- 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 ...
- 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 ...
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 ...
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 ...
- 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.
- 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 ...
- 347
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: &...
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 ...
- 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 ...
- 43
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 ...
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 ...
- 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/"
...
- 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 ...
- 19
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 ...
- 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.
...
- 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 ...
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 ...
- 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 ...
- 105
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 ...
- 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 ...
- 467
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 ...
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 ...
- 95
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 ...
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 ,...
- 157
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 ...
- 11
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 ...
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 .....
- 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
...
- 157
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 ...
- 15
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 ...
- 21
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 ...
- 15
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 ...
- 15
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 ...
- 43
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 ...
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 ...
- 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 ...
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["...
- 125
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....
- 105
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 ...
- 13
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.
- 373
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 ...
- 451
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 ...
- 21
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 ...
- 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. ...
