With PowerShell, you can automate tasks and manage your Microsoft 365 tenant, including adding multiple users to your organization.

To bulk import users into Microsoft 365 using PowerShell, you will need to first install the Azure Active Directory PowerShell module. You can do this by opening a PowerShell window and running the following command:

Install-Module AzureAD

Next, you will need to connect to your Microsoft 365 tenant. You can do this by running the following command and entering your Microsoft 365 global administrator credentials when prompted:

Connect-AzureAD

Now that you are connected to your tenant, you can start importing users. There are a few different ways you can do this, depending on the information you have about the users you want to import.

One option is to use a CSV file to import your users. The CSV file should contain the following information for each user:

  • UserPrincipalName: the email address of the user
  • DisplayName: the name of the user that will be displayed in Microsoft 365
  • Password: the password that the user will use to sign in to Microsoft 365

Once you have your CSV file ready, you can import the users by running the following command:

Import-Csv -Path <path to CSV file> | ForEach-Object {New-AzureADUser -UserPrincipalName $_.UserPrincipalName -DisplayName $_.DisplayName -Password (ConvertTo-SecureString -String $_.Password -AsPlainText -Force)}

Another option is to import users directly from a database or other data source. To do this, you will need to use the New-AzureADUser cmdlet and specify the required parameters for each user. For example:

New-AzureADUser -UserPrincipalName user1@example.com -DisplayName "User 1" -Password (ConvertTo-SecureString -String "Pa$$w0rd" -AsPlainText -Force)

You can use a loop or other method to iterate over the data and create the users one by one.

It’s important to note that when you bulk import users into Microsoft 365 using PowerShell, they will not be assigned a license by default. You will need to assign a license to each user using the Set-AzureADUserLicense cmdlet.

For example:

Set-AzureADUserLicense -ObjectId <object ID of the user> -AssignedLicenses <license ID>

You can also use the Set-AzureADUser cmdlet to assign other properties to the users, such as their department or job title.

For a full list of available parameters, you can use the Get-Help cmdlet to view the Set-AzureADUser cmdlet’s documentation:

Get-Help Set-AzureADUser -Detailed

In conclusion, PowerShell is a powerful tool for managing your Microsoft 365 tenant, including bulk importing users. With the Azure Active Directory PowerShell module and the appropriate cmdlets, you can easily import multiple users at once and assign them licenses and other properties.

Migrating files from an on-premises file server to SharePoint Online can be a useful way to improve collaboration, access, and security for your organization. Here are some steps you can follow to migrate your files:

  1. Determine what needs to be migrated: The first step in any migration is to identify what needs to be migrated. This includes not only the files themselves, but also any metadata or other related information.
  2. Plan your migration: Once you know what needs to be migrated, you can start planning the details of the migration. This includes deciding on a timeline, identifying any potential issues or challenges, and determining the resources that will be needed.
  3. Prepare your files: Before you start the actual migration, you will need to make sure that your files are organized and ready to be moved. This includes verifying that all the files are in a consistent format, renaming any files that may cause issues, and cleaning up any outdated or unnecessary files.
  4. Choose a migration tool: There are several tools available that can help you migrate your files to SharePoint Online. Some options include Microsoft’s own SharePoint Migration Tool (see below), or third-party tools like CodeTwo. Choose a tool that meets your needs and budget.
  5. Migrate your files: Once you have chosen a migration tool, you can start the actual process of moving your files to SharePoint Online. This may involve uploading your files to the tool, configuring any necessary settings, and verifying that the migration was successful.
  6. Test and verify: After the migration is complete, it’s important to test and verify that all of your files have been transferred correctly and are accessible in SharePoint Online. This may involve checking individual files or groups of files, or running a comparison between the on-premises file server and the new SharePoint Online location.
  7. Clean up: Once you have verified that everything has been migrated correctly, you can begin the process of cleaning up your on-premises file server. This may include deleting any outdated or unnecessary files, archiving any files that are no longer needed, and making sure that the file server is organized and ready for the next phase of use.

Using the Free Sharepoint Migration Tool

The SharePoint Migration Tool (SPMT) is a free tool provided by Microsoft that allows organizations to easily migrate their files, folders, and other content from various sources, including on-premises file servers and other cloud services, to SharePoint Online or OneDrive for Business.

Here are some steps to follow when using the SharePoint Migration Tool:

  1. Download and install the tool: The first step is to download and install the SharePoint Migration Tool on your computer. You can find the tool on the Microsoft Download Center.
  2. Create a migration batch: A migration batch is a collection of items that you want to migrate together. To create a new migration batch, open the SharePoint Migration Tool, select “New batch,” and give the batch a name.
  3. Add your files and folders: Once you have created a migration batch, you can start adding your files and folders to it. To do this, click “Add” and select the files and folders you want to migrate. You can also use the “Add from file” option to import a list of files and folders from a CSV file.
  4. Configure your migration settings: Before you start the migration, you will need to configure your migration settings. This includes choosing your target location (either SharePoint Online or OneDrive for Business), setting any advanced options (such as file versioning or metadata mapping), and specifying any custom permissions that you want to set.
  5. Start the migration: Once you have configured your migration settings, you can start the migration by clicking “Start.” The SharePoint Migration Tool will begin transferring your files and folders to your target location. You can monitor the progress of the migration in the tool’s dashboard.
  6. Test and verify: After the migration is complete, it’s important to test and verify that all of your files and folders have been transferred correctly and are accessible in your target location. This may involve checking individual files or groups of files, or running a comparison between the source and target locations.

Migrating files from an on-premises file server to SharePoint Online can be a complex process, but by following these steps and using the right tools, you can make the transition smoothly and effectively.

AccessOrange can Help

A Microsoft Partner like AccessOrange can also help you with the migration.

There are many benefits to having AccessOrange help with a SharePoint migration. Here are some of the key benefits:

  1. Expertise: Microsoft partners such as AccessOrange are trained and certified experts in SharePoint and other Microsoft technologies. This means that they have the knowledge and experience needed to help you plan and execute a successful SharePoint migration.
  2. Support: Working with a Microsoft Partner such as AccessOrange means that you have access to support and resources from Microsoft itself. This includes technical support, best practices guidance, and other resources that can help you get the most out of SharePoint.
  3. Cost savings: AccessOrange can help you save time and money by streamlining the migration process and identifying any potential issues before they become major problems. This can help you avoid costly mistakes and ensure that your migration is completed on time and on budget.
  4. Custom solutions: AccessORange can work with you to develop custom solutions that are tailored to your specific needs and requirements, such as MetaData migration or other complex migration scenario’s where standard tools are not sufficient. This can include custom integrations, custom applications, and other solutions that can help you get the most out of SharePoint.
  5. Ongoing support: AccessOrange can provide ongoing support and maintenance after your SharePoint migration is complete. This can include technical support, training, and other resources to help you get the most out of SharePoint in the long term.

Overall, working with AccessOrange can provide a range of benefits that can help you achieve a successful SharePoint migration. From expert guidance and support to cost savings and custom solutions, AccessOrange can be an invaluable resource for organizations looking to migrate to SharePoint.

For more information, contact us at [email protected] or chat with us on the website.

Power Automate is a powerful tool that allows users to automate various processes and tasks within their organization. This can help to save time, increase efficiency, and reduce the risk of errors. Some of the key benefits of using Power Automate include the following:

  1. Increased productivity: By automating routine and repetitive tasks, Power Automate can help to free up time for more important and value-added activities. For example, instead of spending time manually entering data into a spreadsheet, Power Automate can be used to automatically transfer data from one system to another, eliminating the need for manual intervention.
  2. Improved accuracy: Automating tasks can help to reduce the risk of errors, as there is no longer a need for manual data entry or other manual processes. This can help to ensure that the data is accurate and consistent, which is important for making informed decisions.
  3. Better collaboration: Power Automate can be used to automate the sharing of information and documents within an organization, making it easier for teams to work together and collaborate. This can help to improve communication and coordination, leading to better outcomes.
  4. Greater flexibility: Power Automate allows users to create custom automated processes that can be easily tailored to their specific needs and requirements. This means that users can design and implement processes that are tailored to their specific business needs, making it easier to adapt to changing circumstances.

Example Use Cases

Some examples of how Power Automate can be used to benefit an organization include the following:

  1. Automating the onboarding process for new employees: Instead of manually collecting and entering information about new hires, Power Automate can be used to automate the process. This can involve sending emails to new employees, updating HR systems with their information, and assigning tasks to the appropriate team members.
  2. Automating the generation of reports: Instead of manually collecting data and creating reports, Power Automate can be used to automatically generate reports on a regular basis. This can involve pulling data from multiple sources, applying any necessary calculations, and formatting the report in the desired format.
  3. Automating the process of sending out marketing emails: Marketing teams can use Power Automate to automate the process of sending out newsletters, promotional emails, and other marketing communications. This can save time and effort, allowing the team to focus on other tasks.
  4. Automating the process of reconciling accounts: Financial teams can use Power Automate to automate the process of reconciling their company’s accounts. This can improve accuracy and reduce the risk of errors, ensuring that the financial data is always up-to-date and accurate.
  5. Automating the process of sending out project updates: Project managers can use Power Automate to automatically send out updates to team members when a project is updated. This can improve collaboration and communication within the team, ensuring that everyone is always up-to-date on the latest project developments.
  6. Automating the process of backing up important data: IT teams can use Power Automate to automate the process of backing up important data. This can ensure that the data is always protected and easily accessible, reducing the risk of data loss in the event of a disaster.
  7. Automating the process of scheduling meetings and appointments: Administrative staff can use Power Automate to automate the process of scheduling meetings and appointments. This can save time and effort, allowing them to focus on other tasks.

License Requirements

To use Power Automate, you must have a valid license. There are different types of licenses available for Power Automate, each of which provides access to different features and capabilities. The specific license you need will depend on your specific needs and how you plan to use the service.

One common license for Power Automate is the Microsoft 365 Business Premium license. This license includes access to Power Automate, as well as other Microsoft products and services such as Office 365, Exchange Online, and SharePoint Online. The Microsoft 365 Business Premium license is suitable for small and medium-sized businesses that want to automate their processes and improve productivity.

Another common license for Power Automate is the Microsoft 365 Business Standard license. This license includes access to Power Automate, as well as other Microsoft products and services such as Office 365 and Exchange Online. The Microsoft 365 Business Standard license is suitable for small and medium-sized businesses that want to automate their processes and improve productivity, but do not need all of the features and capabilities included in the Business Premium license.

Finally, the Microsoft 365 E1 license is another option for Power Automate users. This license includes access to Power Automate, as well as other Microsoft products and services such as Office 365, Exchange Online, and Skype for Business. The Microsoft 365 E1 license is suitable for organizations that want to automate their processes and improve productivity, but do not need all of the features and capabilities included in the Business Premium or Business Standard licenses

In conclusion, Power Automate is a valuable tool for organizations looking to save time, improve productivity, and work more efficiently and effectively. By automating repetitive and time-consuming tasks, it can help teams to focus on more important tasks, improving overall organizational performance.

How can we help?

A Microsoft Partner Such as AccessOrange can help with the development of Power Automate flows in a number of ways.

For example, a we can assist with the design and implementation of Power Automate flows by providing guidance on best practices and offering expertise in specific areas such as data integration, business process automation, and user experience design.

In addition, we can help with the deployment and management of Power Automate flows, including setting up the necessary infrastructure, integrating with other systems, and providing ongoing support and maintenance.

Overall, working with a Microsoft partner such as AccessOrange can help organizations to maximize the value of Power Automate by leveraging the partner’s expertise and experience in implementing and managing these types of solutions.

For more information, contact us at [email protected] or chat with us on our website.

Microsoft 365 offers a range of benefits for businesses, including improved collaboration, enhanced security, scalability, accessibility, and integration with other Microsoft products. These benefits can help businesses operate more efficiently and effectively, leading to better outcomes and improved bottom-line results:

These are the top 5 benefits:

  1. Improved Collaboration: One of the biggest benefits of Microsoft 365 is its ability to improve collaboration among team members. With tools like Microsoft Teams, SharePoint, and OneDrive, employees can easily share documents and collaborate on projects in real time, regardless of their location. This can help teams work more efficiently and effectively, resulting in better outcomes for the business.
  2. Enhanced Security: Another key benefit of Microsoft 365 is its focus on security. The platform uses advanced security measures, such as multi-factor authentication and data encryption, to protect business data from threats like hacking and ransomware. This can give business owners peace of mind and help them comply with industry-specific regulations.
  3. Scalability: Microsoft 365 is a highly scalable platform, which means it can grow with a business as its needs change. Whether a business is small and just starting out, or large and well-established, Microsoft 365 can provide the tools and services it needs to operate effectively.
  4. Accessibility: Microsoft 365 is a cloud-based platform, which means it can be accessed from anywhere with an internet connection. This makes it easy for employees to work remotely and stay connected to the rest of the team. It also enables businesses to respond quickly to changing circumstances and adapt to new challenges.
  5. Integration with Other Microsoft Products: Finally, Microsoft 365 is closely integrated with other popular Microsoft products, such as Excel, PowerPoint, and Outlook. This means businesses can use the tools they are already familiar with, while also benefiting from the added features and functionality of Microsoft 365.

How to Migrate to Microsoft 365

Migrating from your current IT system to Microsoft 365 can bring many benefits to your business, including improved collaboration, enhanced security, and access to a range of powerful productivity tools. Here are some key steps to help you make the transition smoothly:

  1. Plan ahead: Before you start the migration process, take some time to plan out how you will move your data and applications to Microsoft 365. This will help you avoid any disruptions to your business and ensure that the transition goes smoothly.
  2. Choose the right Microsoft 365 plan: Microsoft 365 offers a range of plans to suit different business needs. Choose the plan that best meets your requirements, taking into account the number of users, the type of data and applications you need to migrate, and any specific features you require.
  3. Prepare your data and applications: Before you can migrate to Microsoft 365, you will need to ensure that your data and applications are ready. This may involve cleaning up and organizing your data, as well as updating any applications that are not compatible with Microsoft 365.
  4. Use the Microsoft FastTrack service: Microsoft FastTrack is a free service that can help you plan and execute your migration to Microsoft 365. The service includes a range of tools and resources, as well as expert support to help you every step of the way.
  5. Test and verify: Once you have migrated your data and applications to Microsoft 365, it is important to test and verify that everything is working as expected. This will help you identify any issues and ensure that your business is ready to start using Microsoft 365.
  6. Provide training and support: To ensure that your employees can make the most of Microsoft 365, it is important to provide training and support. This may involve creating training materials, holding workshops, or offering one-on-one support to help your employees get up to speed with the new system.

Choosing a Migration Partner

Working with a Microsoft Partner such as AccessOrange can be a great way to ensure a smooth and successful migration to Microsoft 365. A Microsoft Partner is a company that has been certified by Microsoft to provide a range of services related to Microsoft products, including migration to Microsoft 365.

Here are some key ways in which a Microsoft Partner can help with the migration to Microsoft 365:

  1. Expertise and experience: A Microsoft Partner has the expertise and experience to help you migrate to Microsoft 365 quickly and efficiently. They have extensive knowledge of the Microsoft 365 platform, as well as the tools and processes needed to migrate data and applications seamlessly.
  2. Planning and execution: A Microsoft Partner can help you plan and execute your migration to Microsoft 365, ensuring that your data and applications are migrated smoothly and without any disruption to your business. They can provide guidance on the best approach to take, as well as help you manage the migration process from start to finish.
  3. Support and training: A Microsoft Partner can provide support and training to help you and your employees make the most of Microsoft 365 once it is up and running. This may involve creating training materials, holding workshops, or providing one-on-one support to help your employees get up to speed with the new system.
  4. Cost savings: Working with a Microsoft Partner can help you save time and money on your migration to Microsoft 365. A partner can provide cost-effective solutions and services, as well as help you avoid costly mistakes and ensure that your migration is successful.

Overall, working with a Microsoft Partner can be a great way to ensure a smooth and successful migration to Microsoft 365. A partner can provide the expertise, support, and guidance you need to make the transition smoothly and take full advantage of the many benefits of Microsoft 365.

Want to know more information about migrating to Microsoft 365? Contact us via email at [email protected] or chat with us on our website.

Fortinet warns of actively abused zero-day leak in VPN software

Fortinet is warning organizations of an actively exploited zero-day vulnerability in FortiOS SSL-VPN that could allow a remote attacker to take over vulnerable VPN servers. By sending specially crafted requests, an attacker can cause a heap-based buffer overflow and execute code on the system. Attackers do not need any credentials to carry out the attack.

The impact of the vulnerability has been assessed on a scale of 1 to 10 with a 9.3. Fortinet says the vulnerability, designated CVE-2022-42475 , was actively attacked even before the release of the security update, but does not provide further details about the target of the attacks. The security bulletin does contain information that can be used to recognize a successful attack on the VPN server.

“Vulnerabilities in VPN interfaces can therefore provide a starting point to penetrate a network, after which other systems may also be compromised. Depending on the situation, an attacker can, for example, gain access to sensitive information in this way or carry out a ransomware attack” , according to the National Cyber ​​Security Center.

The Australian Cyber ​​Security Center and the American Cybersecurity and Infrastructure Security Agency are calling on organizations to immediately install the security update and check whether their VPN servers have not been compromised.

Do you have a Fortinet Firewall installed in your organization? Reach out to us for assistance with the security update installation.

Contact us at: [email protected]

Dynamics 365 Sales is a cloud-based CRM solution that enables salespeople to build strong relationships with their customers, take actions based on insights, and close deals faster. With Dynamics 365 you can manage your customer relationships, from first contact (lead) to qualifying (opportunity) to deal (Quote/Order).

Dynamics 365 can be used by Microsoft Power Automate to automate almost anything within Dynamics 365. Dynamics 365 and Power Automate together, make a great combination for further enhancement of your sales process.

In this example we will teach you how to use Power Automate to send a message to your sales staff via Microsoft Teams when a new lead has been assigned to them in Dynamics 365.

Step 1: Create new Power Automate Flow

Go to https://make.powerautomate.com/ and click on “Create”, and select “Automated Flow”

Step 2: Enter Flow name and select Dataverse

Give the flow a name, and search for “dataverse” and select “When a row is added, modified or deleted”

Step 3: Configure Trigger that will start up our Flow

On the next screen we will configure the trigger. We will configure the Change Type to “added or modified” to ensure that the trigger only runs when a new lead is added, or when a lead is modified.

Table name: Leads (as we want to target leads in this case)

Scope: Organization (We want this flow to run for the entire dataverse organization, not just our user scope)

Select Columns: We will enter “ownerid” here because we want to make sure that our trigger only runs when the field “ownerid” (which is the lead owner) is added or changed

Step 4: Get Current Lead

First we need to get the record of the lead that had an addition/change to the lead owner. We will add a new action to our flow and search for “dataverse” and select “get a row by ID”

We will select the table name “Leads” and for Row ID we will select “lead ID”

Step 5: Ignore Closed Leads

To make sure we’re not going to process leads that have been closed already, we need to filter out the closed leads with a condition. We can do that by terminating the flow if the “Lead Status” is equal to 0.

 

Step 6: Get Lead Owner

For the leads that are not closed, we continue by getting the lead owner from the relationship between table “leads” and “users”. We can do that by retrieving the Table “Users” and get the row id from the Owner Value from the Leads.

Step 7: Get Lead Owner Email Address

Since we want to send a teams message, we will need to retrieve the primary account UPN for that particular owner. We can do that by creating an action called “Get user profile (V2)”, and search the user based on the primary email address we got from the previous step.

Step 8: Get a Mention token for a user in Teams

Since we want to send a message in a particular channel, and tag the owner in the message, we need to get a “mention token” for this user. We can do this with the task “Get an @mention token for a user” from Teams, and use the user principal name we got from the previous step:

Step 9: Delay task for 1 Minute

In order to make sure that Teams is ready to accept our message with mention token, it is recommended to add a 1 minute delay, to make sure no errors occur:

Step 10: Post a Message in a Chat or Channel

Now we have all the information we need, we can post a message in a Teams Channel. In our case we post it in a group chat, but you can also choose a channel.

For the message, we will include not only the Lead Company Name and Lead Topic, but we also want to include a link to the actual lead in dynamics.

Make sure that you enter the fields using the Code View “</>” option, so your urls will not be truncated or broken. In the Code View option, you can enter HTML code to change the layout of the text. (We use <p> for paragraphs, <br> for lines etc

You can see from above screenshot, we first add the “mention token” and then we also include a link to the URL of the lead in Dynamics.

How to get the Lead URL in Dynamics:

  1. Go to Dynamics 365 – Leads
  2. Click on any Lead
  3. Extract the URL from your browser, and remove the last guid from the url (see orange below)

The URL you should use should looks something like:

https://xxxxxxxxxxxxx.dynamics.com/main.aspx?appid=xxxxxx&pagetype=entityrecord&etn=lead&id=

Now paste that in your Flow and make it a Link using the html <a href=””>  lead </a> code.

When you’re done, your flow should have the following steps:

Now you can test your flow, and (hopefully) it should work. Here is an example of how it looks on our side:

Great Work! Feel free to reach out if you have any issues or questions regarding above flow.

Microsoft Power Automate (earlier known as Microsoft Flow) allows you to automate repetitive manual tasks and paper processes via an easy to use drag-and-drop wizard.

Microsoft Power Automate can create workflows to sync data across apps and software, generate real-time notifications to alert stakeholders, update databases with new information and collect data from Power Apps or other data sources.

In this example we will teach you how to use Power Automate to create recurring tasks in Microsoft Planner.

For this example we imagine that we want to remind our finance department to check and send out a monthly invoice to the customer.

Step 1: Create new Power Automate Flow

Go to https://make.powerautomate.com/ and click on “Create”, and select “Scheduled Cloud Flow”

Step 2: Enter Flow Name and Set Schedule

Give the flow a name, and enter the schedule. In our example we want to have a monthly reminder, so we set the repeat time to every 1 month.

Now we can see the Flow editor screen, with our monthly recurring task as starting point. We click on new step:

Step 3: Create New Task in Planner

We find Planner and select “Create a Task”

After that we select which Planner Plan the task need to be created, and we fill in the information that we want to show in the planner task.

In our example we want to enter some dynamic fields, for the Start Date, Due Date and also to show a dynamic date and time in the Title.

For the Start Date we want today’s date, so we will have to fill in a Dynamic Expression:

Expression:

utcNow()

For the Due Date, we want to set it 15 days from today, hence we fill use the expression adddays() to add 15 days from today (utcnow()):

For the Title we also want to add the Due date, hence we will add the adddays function as well there:

Expression 1:

formatDateTime(adddays(utcnow(),-15),'MM')

Expression 2:

formatDateTime(utcNow(),'yyyy')

Important: For Assigned User Id’s, fill in the email addresses of the users that you want to assign the task to.

Step 4: Update Planner Task Details

Now we have created the main task, we can also update or add more details under the planner task details. For this we add one more flow called “Update task details””.

In this task, we need to refer to our original planner task ID.

 

And after that we can add some more information. In our case we add a link to the billing sheet we want the finance department to use, which is an Excel file. But you Can also add a checklist here.

That’s it! Now our Flow is ready. We can save it, enable it and test it out. If everything runs smooth, your task will now appear in Microsoft Planner every month.