How to connect the Add-In for SharePoint?

I am interested in trying to use PowerShell against our company SharePoint portal, We have some automation Tools like MS Flow and Alteryx Server that we are leveraging and I am trying to connect to a Workflow History listing. However, it is hidden from these other tools and I hoping Powershell might be an option.

I am trying to install and get it to work our on AWS EC2 environment and I keep having a lot of trouble adding the Add-In for SharePoint,

I tried following this kind of instruction but had zero success.
https://blogs.msdn.microsoft.com/opal/2010/03/07/sharepoint-2010-with-windows-powershell-remoting-step-by-step/

We are SharePoint Online/O365

Any suggestions?

Regards,

Adam
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Kyle SantosQuality Assurance Engineer at Dassault Systemes

Commented:
Hi,

I am following up on your question.  Do you still need help?

If you solved the problem on your own, would you please post the solution here in case others have the same problem?

Regards,

Kyle Santos
Customer Relations
Adam EhrenworthLead Technology Analyst

Author

Commented:
I did not solve this issue. Still looking for guidance. My biggest need is to delete over 5000 rows at once from a SharePoint list based on criteria.
Most Valuable Expert 2013
Awarded 2012
Commented:
Hi,
as you are on SharePoint Online you should use the SharePoint PnP for SharePoint Online module.
https://github.com/SharePoint/PnP-PowerShell

With that it should be a piece of cake to connect to your tenant and run the delete on the list items.

The link you provided is only possible for local on-premises installations AND due to the fact it uses SharePoint built-in PowerShell module it has to run on a server where SharePoint is actually installed.
PnP PowerShell uses the SharePoint Client runtime and can therefore run on any PowerShell enabled device (e.g. Server 2016, 2012R2 or even Win10).

HTH
Rainer
(P.S.: sorry for the late reply - vacation time)

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial