Onboarding New hires via Sharepoint List and Powershell

Question

question

RicM-7135 asked Dec 22, '21 AndreasBaumgarten commented Dec 23, '21

Onboarding New hires via Sharepoint List and Powershell

I'm looking to automate our onboarding of new users process. If someone can point me in the right direction that would be greatly appreciated. What I am looking for or need some guidance for is. I am working on getting the process started of making a PowerShell script that will check a SharePoint list for a new entry. Then take the information from the entry and create the user in AD, Waits for Office 365 to sync then assign the license. The part I'm struggling with right this moment is getting the SharePoint part of the script built.

Environment: Hybrid (On prem AD that syncs to office 365)

Logic:
-Check the Share Point List
-On Local Run the New User Powershell Script
-Check for new user in powershell
-Scripted Changed from Manual Input to Automatic input.
-Wait 60 minutes (Powershell sleep command let)
-Connecting to Office 365 Cloud
-Assign Licesnse
-Delay 5 Minute (Powershell sleep command let)
-Enable Archiving and Lit. hold

office-sharepoint-online windows-server-powershell

· 5

5 |1600 characters needed characters left characters exceeded

Attachments: Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

EmilyDu-MSFT · Dec 23, 2021 at 06:48 AM

@RicM-7135

Whether you want to check new items in the list then add users into AD by using new items in the list through automatically PowerShell.

Per my knowledge, above requirement is not available. You only could create AD users through csv file.

Reference:
How to Create New Active Directory Users with PowerShell

Note: Microsoft is providing this information as a convenience to you. The sites are not controlled by Microsoft. Microsoft cannot make any representations regarding the quality, safety, or suitability of any software or information found there. Please make sure that you completely understand the risk before retrieving any suggestions from the above link.

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

0 ·

RicM-7135 EmilyDu-MSFT · Dec 23, 2021 at 01:40 PM

@EmilyDu-MSFT

Is there not a way to check for new entry or pull data from a sharepoint list? I feel like there is or at least there was based off this part of a script I found. Unfortunately it does not work for me when i fill in the required data. Im not sure how out of date the script is as its one we found stored in a folder share at my company.

160124-sharepoint-powershell.txt

0 ·

sharepoint-powershell.txt (3.3 KiB)

AndreasBaumgarten RicM-7135 · Dec 23, 2021 at 02:49 PM

Hi @RicM-7135 ,

did you fill the missing details in the attached script?
What error messages did you get?

(If the reply was helpful please don't forget to upvote and/or accept as answer, thank you)

Regards
Andreas Baumgarten

0 ·

Show more comments

question