AccessOrange wishes you a prosperous and blissful Year of the Rabbit.
Thank you for your support!
祝您新的一年鴻兔大展!
WhatsApp Number
+1 555 710 1798
AccessOrange wishes you a prosperous and blissful Year of the Rabbit.
Thank you for your support!
祝您新的一年鴻兔大展!
Have you ever had to prepare a presentation that needed to include PowerBI charts & graphs? You probably ended up making screencaps of your PowerBI charts, and copying them in to your PPTX as a picture, since there as no decent way to embed a PowerBI report directly in PowerPoint… Until now!
Recently, Microsoft Announced the feature to embed live PowerBI reports into your presentation, with the possibility to refresh your data as well! No wasted time spent on updating your sales presentation whenever the sales data got updated.
Open your PowerBI Report via Powerbi.com, and click on the share button
Choose the permissions you want to grant and who you want to grant them to, and click on PowerPoint.
Click on Copy to copy the report page link.
Open your PowerPoint presentation and click on Insert – PowerBI.
Paste the link you copied from PowerBI, and click insert.
Now you have your PowerBI report embedded in PowerPoint!
You can also refresh your data via the refresh button:
More questions on PowerBI? Let us know!
Dynamics 365 Sales is a customer relationship management (CRM) software solution that is part of the Dynamics 365 suite of business applications. It is designed to help sales teams manage their relationships with customers and prospects and streamline sales processes. With Dynamics 365 Sales, salespeople can access customer data and interactions from a single platform, track sales activities and opportunities, automate tasks, and collaborate with other team members and departments.
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 price change has been detected in a Dynamics 365 Pricelist.
Go to https://make.powerautomate.com/ and click on “Create”, and select “Automated Flow”
Give the flow a name, and search for “dataverse” and select “When a row is added, modified or deleted”
On the next screen we will configure the trigger. We will configure the Change Type to “modified” to ensure that the trigger only runs when a price list has been modified.
Table name: Price List Items (as we want to target Price List Changes in this case)
Scope: Organization (We want this flow to run for the entire dataverse organization, not just our user scope)
First we need to get the record of the Product that had a price change. 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 “Products” and for Row ID we will select “Product (Value)”
In our case we have price lists with different currencies, hence we will need to retrieve the actual currency of the pricelist.
We do that again with a Dataverse : Get Row by ID and select Currencies and Row ID: Currency (Value)
Since the Teams “Post message in a chat or channel” is sometimes buggy when it comes to message layouts, it is recommended to draft your message in a compose, and parse the compose to the next step.
Here is our chat message including a little layout tweaking such as adding <strong> </strong> to make some letters bold.
We want to show the product code, which in our case is a custom field named “Product ID”. The amount is the local amount from the price list, for which we add the Curency as well in order to be complete.
Now we can do the final step, which is to post our chat message in a group chat or in a channel. In our case we have a chat specifically for our sales team, where we want to post the message in.
The actual message is the output of our compose in step 6
When you’re done with above, the entire flow should have the following elements:
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.
Exchange Online Plan 1 and Microsoft 365 Business Basic are two different subscription plans offered by Microsoft. Both plans offer email and calendar capabilities, but there are some key differences between them that may make one plan more suitable for a business than the other.
Exchange Online Plan 1 is a standalone email and calendar service that is part of the Microsoft 365 suite of products. It is designed for businesses that need a robust email and calendar solution, but do not require the additional productivity and collaboration tools that are included in other Microsoft 365 plans. Exchange Online Plan 1 includes features such as 50GB of email storage, support for email and calendar sharing, and integration with Microsoft Outlook and other email clients.
Microsoft 365 Business Basic, on the other hand, is a comprehensive productivity and collaboration suite that includes Exchange Online Plan 1 as well as other tools such as Microsoft Word, Excel, PowerPoint, and OneDrive. It is designed for small and medium-sized businesses that need a full suite of productivity and collaboration tools to help them work more efficiently and effectively. In addition to email and calendar capabilities, Microsoft 365 Business Basic also includes tools for document creation and sharing, online meetings and video conferencing, and team collaboration.
One of the main differences between Exchange Online Plan 1 and Microsoft 365 Business Basic is the scope of features and tools included in each plan. Exchange Online Plan 1 is a standalone email and calendar service, while Microsoft 365 Business Basic is a comprehensive suite of productivity and collaboration tools. This means that if you are a business that only needs email and calendar capabilities, Exchange Online Plan 1 may be a better fit for you. However, if you need a full suite of tools to help your business run more efficiently and effectively, Microsoft 365 Business Basic may be a better choice.
Another difference between the two plans is the pricing structure. Exchange Online Plan 1 is typically offered as a monthly or annual subscription, while Microsoft 365 Business Basic is typically offered as an annual subscription. This means that if you choose Microsoft 365 Business Basic, you will need to pay for the full year upfront, while with Exchange Online Plan 1 you have the option to pay on a monthly or annual basis.
Exchange Online Plan 1 and Microsoft 365 Business Basic are two different subscription plans offered by Microsoft that cater to different needs and budgets. Exchange Online Plan 1 is a standalone email and calendar service that is suitable for businesses that only need these capabilities, while Microsoft 365 Business Basic is a comprehensive suite of productivity and collaboration tools that is suitable for small and medium-sized businesses that need a full range of tools to help them work more efficiently and effectively.
Your business should consider choosing Exchange Online Plan 1 over Microsoft 365 Business Basic if they only need email and calendar capabilities and do not require the additional productivity and collaboration tools offered by Microsoft 365 Business Basic. Exchange Online Plan 1 is a standalone email and calendar service that is part of the Microsoft 365 suite of products and is designed specifically for businesses that only need these capabilities.
That being said, Microsoft 365 Business Basic is a comprehensive productivity and collaboration suite that includes Exchange Online Plan 1 as well as other tools such as Microsoft Word, Excel, PowerPoint, and OneDrive. It is designed for small and medium-sized businesses that need a full suite of tools to help them work more efficiently and effectively. If a business requires a full range of productivity and collaboration tools in addition to email and calendar capabilities, Microsoft 365 Business Basic may be a better fit.
In general, the choice between Exchange Online Plan 1 and Microsoft 365 Business Basic will depend on the specific needs and budget of the business. If a business only needs email and calendar capabilities, Exchange Online Plan 1 may be a more cost-effective option. However, if a business needs a full suite of productivity and collaboration tools, Microsoft 365 Business Basic may be a better choice. It is important for businesses to carefully evaluate their specific needs and budget when deciding between these two subscription plans.
Please see below table for a more complete overview of the differences between each edition.
(Microsoft prices per 12-2022. Contact us to get the best deal for your organization!)
Want to know more? Contact us at [email protected] and we’ll have one of our consultants discuss with you what is the best option for your organization.
In the latest Microsoft Teams Update, Microsoft has introduced a new feature called “Scheduled Send Chat Messages”.
With this new feature is possible to choose a specific time to send out your chat message. It is similar to the “Delay Delivery” option in Outlook, that lets users schedule messages to be sent at a time convenient to their recepients.
With the new Scheduled Send feature, it is also possible to edit or delete the message before they are being delivered to the recepients.
All scheduled messages can only be delivered no more than 7 days in the future and cannot be flagged as urgent or important. Inline images and attached files will only be accessible by others in the chat once the message has been delivered.
To schedule a message in Teams, desktop users will need to right-click on the Send button and choose a date and time within 7 days. Review the schedule details in the compose box and click the Send at scheduled time button to deliver it at the scheduled date and time.
On mobile, users will need to type the message and long press the send button to open the scheduling menu. Select the date and time and tap the “Send at scheduled time button” to deliver it at a later time.
What do you think? Great feature, isn’t it?
Microsoft 365 is a powerful and feature-rich platform, but like any software, it is not immune to issues such as data loss, cyber attacks, or other disasters.
By having a separate backup, you can protect yourself against these types of events and ensure that you have access to your data even if something goes wrong with your Microsoft 365 environment.
In addition to providing an extra layer of protection, having a separate backup also allows you to more easily recover from data loss or corruption. If you only have one copy of your data, you may have to wait longer to restore your data if the primary copy becomes damaged or is otherwise unavailable. With a separate backup, you can restore your data more quickly by choosing the backup that is most recent and therefore most likely to be intact.
Also, having a separate backup allows you to store your data in a different location, which can help to protect against physical disasters such as fires or floods. For example, you could store your backup in a cloud-based storage solution such as MSP360. This way, if your primary location is compromised, you still have access to your data from another cloud location.
Having a separate backup can also help to reduce the risk of data loss due to human error. For example, if you accidentally delete a file or overwrite an important document, you can restore it from your backup rather than having to recreate the data from scratch.
Therefore we recommend to have a separate backup of your Microsoft 365 environment in order to protect against data loss and ensure that you have a reliable backup plan in place. By taking the time to set up a separate backup, you can safeguard your data and have peace of mind knowing that your important information is secure.
MSP360 Backup (formerly known as CloudBerry Backup) is a data backup and recovery software that can protect your Microsoft 365 data.
Here are a few ways in which MSP360 Backup can help protect your Microsoft 365 data:
MSP360 Backup is a powerful tool that can help you to protect your Microsoft 365 data and ensure that you have a reliable backup plan in place. By automating your backups and offering multiple backup destinations and data encryption, MSP360 Backup can help you to keep your data safe and secure.
For more information on Microsoft 365 Backup solutions or MSP360, contact us at [email protected] or chat with us on our website.
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:
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:
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:
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.
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:
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:
Some examples of how Power Automate can be used to benefit an organization include the following:
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.
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:
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:
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:
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.