Tag Archives: microsoft
Power Query for Mac using array as data source
Its not obvious to me how to connect an array as the data source for my Power Query on Mac. I have seen some videos that show connecting to Ranges and Tables using a PC.
Its not obvious to me how to connect an array as the data source for my Power Query on Mac. I have seen some videos that show connecting to Ranges and Tables using a PC. Read More
Copilot and Mac
Before I spend the subscription fee for Copilot, will it work on the Mac Version of Office 365?
The only add-in option I see when I search for Copilot is R2 Copilot: Private ChatGPT
I am wanting to use it to help create powerpoint presentations from word documents, I have seen some really great videos on this. But they are always on a Windows Operating System.
Can I do this on a MacBook Pro running macOS 15?
thanks.
Before I spend the subscription fee for Copilot, will it work on the Mac Version of Office 365? The only add-in option I see when I search for Copilot is R2 Copilot: Private ChatGPT I am wanting to use it to help create powerpoint presentations from word documents, I have seen some really great videos on this. But they are always on a Windows Operating System. Can I do this on a MacBook Pro running macOS 15? thanks. Read More
select some staff but others are required
I would like to create bookings where customers can select certain staff, but have other staff always guaranteed to be assigned.
For example:
Operations Request Meeting
Staff:
Operations Manager
Ops staff 1
Ops staff 2
Ops staff 3
Where someone can select one of the staff members, but the Manager is always assigned to the booking
Is this possible?
I would like to create bookings where customers can select certain staff, but have other staff always guaranteed to be assigned.For example: Operations Request MeetingStaff:Operations ManagerOps staff 1Ops staff 2Ops staff 3 Where someone can select one of the staff members, but the Manager is always assigned to the booking Is this possible? Read More
public booking pages will not load for non-office users
Clients attempting to book time with me using the Bookings page are receiving this error when they click the public link:
UTC Date: 2024-08-29T14:28:44.800Z
Client Id: 2
Session Id:
BootResult: retry
Back Filled Errors: Unhandled Rejection: SyntaxError: The string did not match the expected pattern.:undefinedlUnhandled Rejec
err: Microsoft.Exchange.Clients.Owa2.Server.Core.OwaUserHasNoMailboxAndNoLicenseAssignedException
esrc: StartupData
et: ServerError
estack:
st: 500
ehk: X-OWA-Error
efe: DS7P222CA0023, SA9PR11CA0021
ebe: DM8PR01MB6933
emsg: UserHasNoMailboxAndNoLicenseAssignedError
How do I resolve this so outside users can use the link to book?
Clients attempting to book time with me using the Bookings page are receiving this error when they click the public link: UTC Date: 2024-08-29T14:28:44.800ZClient Id: 2Session Id:BootResult: retryBack Filled Errors: Unhandled Rejection: SyntaxError: The string did not match the expected pattern.:undefinedlUnhandled Rejecerr: Microsoft.Exchange.Clients.Owa2.Server.Core.OwaUserHasNoMailboxAndNoLicenseAssignedExceptionesrc: StartupDataet: ServerErrorestack:st: 500ehk: X-OWA-Errorefe: DS7P222CA0023, SA9PR11CA0021ebe: DM8PR01MB6933emsg: UserHasNoMailboxAndNoLicenseAssignedError How do I resolve this so outside users can use the link to book? Read More
Formula Help for a tally
Looking for quick help creating a formula.
What I’m working with is going to be a long table with up to 30 names that’ll be repeating often. They can also have a specific number (employee number) attached to each one, to accommodate for any misspellings. Is there a formula that can calculate how many times the name/number appears? Like, 34678 shows up 34 times in Column A, and the result is put into another table/sheet, or just displayed after setting the formula into a cell? The goal is just that, quickly identify how many times it repeats.
Thanks!
Looking for quick help creating a formula.What I’m working with is going to be a long table with up to 30 names that’ll be repeating often. They can also have a specific number (employee number) attached to each one, to accommodate for any misspellings. Is there a formula that can calculate how many times the name/number appears? Like, 34678 shows up 34 times in Column A, and the result is put into another table/sheet, or just displayed after setting the formula into a cell? The goal is just that, quickly identify how many times it repeats.Thanks! Read More
Forms in Libraries
Hi,
I hope this is the right place to post this. If not please redirect me.
I currently have a system to create customer quotes using sharepoint lists, power automate, and a sharepoint library. The user goes to the list and creates a new entry by clicking new, then fills out the form with all the information. When they click save a “Flow” starts that gets the item properties from the newly created list item, then gets a content type template (word doc with quickparts) from a sharepoint library, then populates the template with the item properties and saves a copy in the library.
My question is this: Why do I need a list and a library to do this? Could I not do this all within one library and different views? I would like to have the user go to the library and click new, then select the document type, then fill out a form, and sharepoint would create a document from the content type template with all of the form data filled out.
I have got most of the way there but am running into a few problems:
1. When you select “new document” the new document opens in Word. I want a form to open instead.
2. When I proceed with filling out the properties in Word and then try to save the document, it wants to “save as” and prompts for a new location. I want it save to the library.
Hi,I hope this is the right place to post this. If not please redirect me. I currently have a system to create customer quotes using sharepoint lists, power automate, and a sharepoint library. The user goes to the list and creates a new entry by clicking new, then fills out the form with all the information. When they click save a “Flow” starts that gets the item properties from the newly created list item, then gets a content type template (word doc with quickparts) from a sharepoint library, then populates the template with the item properties and saves a copy in the library. My question is this: Why do I need a list and a library to do this? Could I not do this all within one library and different views? I would like to have the user go to the library and click new, then select the document type, then fill out a form, and sharepoint would create a document from the content type template with all of the form data filled out.I have got most of the way there but am running into a few problems:1. When you select “new document” the new document opens in Word. I want a form to open instead.2. When I proceed with filling out the properties in Word and then try to save the document, it wants to “save as” and prompts for a new location. I want it save to the library. Read More
August V2 Title Plan now available!
Don’t forget to checkout updates made to the Title Plan, shared in its permanent location, linked above.
Please note: This is not a support forum. Only comments related to this specific blog post content are permitted and responded to.
For ILT Courseware Support, please visit: aka.ms/ILTSupport
If you have ILT questions not related to this blog post, please reach out to your program for support.
Microsoft Tech Community – Latest Blogs –Read More
Introducing granular permissions for Azure Service Bus Explorer
When working with the Service Bus Explorer in the Azure portal, you may want to grant different permissions to different users, depending on their role and responsibility. For example, you may want to allow some users to send messages to a queue, but not receive them. Or you may want to restrict access to a specific queue, topic, or subscription, but not the entire namespace.
To address this challenge, we are excited to announce granular permissions for Service Bus Explorer. To use granular permissions, you need to use Microsoft Entra authentication, and assign one of the following roles, either on the namespace level or on the entity level.
Service Bus Data Owner; Allows to execute both send and receive operations.
Service Bus Data Sender; Allows to execute send operations.
Service Bus Data Receiver; Allows to execute peek, receive, and purge operations.
In case you use a role which doesn’t have send or receive permissions, or you do not have permissions on the specific entity, the unavailable operations will be disabled. Furthermore, a notification will be shown showing which permissions are missing.
For more information on using the Service Bus Explorer, you can check our documentation.
Microsoft Tech Community – Latest Blogs –Read More
Partner Blog | Unlocking growth: leveraging Microsoft tools for growing your migration practice
By Pankaj Srivastava, General Manager, Azure Partner Sales & Strategy
In today’s dynamic digital landscape, staying relevant means continuously adapting and using the best tools available. For partners focused on building their migration practice, Microsoft offers a unique opportunity to grow their business with a robust suite of resources and offers designed to streamline migration processes, enhance operational efficiency, and drive growth. In this blog, we discuss how you can best use these assets to enhance your services and drive success.
Generate customer interest and demand
Start by accessing Microsoft CloudAscent customer propensity lists in Partner Center to identify migration and security opportunities within the SMB sector. These lists help you target the right customers for your services. For managed partners, your PDM can download additional Enterprise and SMC-C migration propensity lists, providing key information about each account where you are the incumbent. These lists include Windows Server end-of-support (EOS) opportunity flags, SQL Server EOS flags, Microsoft Defender for Cloud consumption flags, and whether an assessment has been done on the account.
Next, use the campaign in a box assets and scripted campaigns to drive demand for Azure VMware Services (AVS) and Windows Server/SQL Server migrations. These resources are crafted to help you effectively market your services and attract new clients with updated content and messaging from our marketing experts; while also helping you position your company value front and center.
Whether you need ready-to-share Digital Marketing Content OnDemand (DMC) or customizable campaigns from the Partner Marketing Center (PMC), we have assets to help you.
Digital Marketing Content OnDemand (DMC) scripted campaigns:
Migrate and Secure Windows Server and SQL Server SMB
Migrate and Secure Windows Server and SQL Server ENT
Migrate VMware Workloads to Azure
Partner Marketing Center (PMC) downloadable campaign content:
Migrate and Secure Windows Server and SQL Server SMB
Migrate and Secure Windows Server and SQL Server ENT
Migrate VMware workloads to Azure
Continue reading here
Microsoft Tech Community – Latest Blogs –Read More
Random Pool Generator excel office 365
Im trying to create a quiz generator. I have an excel file with 49 worksheets, and each worksheet covers one topic area and has a group of 20 or so related questions. Some groups have more questions, some less. I could make the worksheets into one big sheet if required, and just create a column to label each related topic area.
i want to create 30 randomly generated questions from that pool, with no more than two from any one topic area. Ive got a few ideas but nothing that seems relatively simple.
looking for formula based solution – not macro based.
TIA!
Im trying to create a quiz generator. I have an excel file with 49 worksheets, and each worksheet covers one topic area and has a group of 20 or so related questions. Some groups have more questions, some less. I could make the worksheets into one big sheet if required, and just create a column to label each related topic area.i want to create 30 randomly generated questions from that pool, with no more than two from any one topic area. Ive got a few ideas but nothing that seems relatively simple. looking for formula based solution – not macro based. TIA! Read More
Planner Premium unavailable in Power Automate
I was very happy to be able to start with Planner Premium. But … what did I experience? Power Automate doesn’t see the Planner Premium so I am unable to import activities from Monday.Com planning. There is also no import facility. How does Microsoft support customers to convert old plans to Planner Premium?
I was very happy to be able to start with Planner Premium. But … what did I experience? Power Automate doesn’t see the Planner Premium so I am unable to import activities from Monday.Com planning. There is also no import facility. How does Microsoft support customers to convert old plans to Planner Premium? Read More
Help reformatting schedule template
Hello, I like the look of the Excel “Student Schedule” template (it autopopulates into a weekly calendar view based on the “Class List” tab and highlights column for today’s day of week and row for current time/hour). I want to update this template to do a few things.
1. I won’t be using for class schedule but want to use to reserve vacant rooms in my office. So, I would change “Class Schedule” to “Vacant Room Availability” and Class List to “Sign-Up). (Changing names is simple, I can do that – but I’m not sure how it will affect formulas and conditioning that will need to be updated).
2. On the “Sign-Up” tab – I don’t need all the data in the original Class List tab. I only need ROOM (there are 2 rooms available), PERSON, DAY, START TIME, and END TIME.
-On the weekly calendar view (Vacant Room Availability tab aka Class Schedule), when you input data into a row on class list/sign-up tab – it highlights the cells according to the time duration and it has text from the “ID” column on the class list/sign-up tab. I want the text that is shown on the weekly view to be what’s under “Person” column to show John has room A from 1-2pm and Sally has room B from 8-9am.
3. I want to add dates to the sheets and I want the calendar view and sign-up/class list to update by week based on the date.
-Date could be easily added by adding a row above the named days of the week. So there can be a dedicated cell that has Sunday’s date for a given week then in the row above the words Sunday through Saturday, it will autopopulate the date for that day. When you change the date for the dedicated Sunday cell – it should update the rest of the dates above the days of the week… I’ve figured out how to do that but the issue now is making it dynamic so the weekly view “refreshes” so to speak to view corresponding bookings for that week.
-That would mean updating the Sign-Up/Class List tab to also include a cell dedicated to Sunday’s date for a given week. My hope is that when that date cell is updated the table in the Sign-Up/Class List tab will refresh. So let’s say there’s bookings in for this week 8/25/24 – that should autopopulate on weekly view. But if I change sign-up to 9/1/24 it should be blank since no bookings have been added and the weekly view should also be blank.
4. Since there are 2 different rooms that can be booked – I’m not sure if I need to copy/paste the tabs for room 2 or if they can be added on the same weekly calendar view. As is, the template only allows one highlight for a certain day/time based on data in the Class List tab. If I try to schedule 2 different things in the class list tab for Wednesday from 1-3pm – it doesn’t show both bookings.
Is there a way to show both rooms (in different colors) booked for the same day/time on the same weekly view – if so that is my preference.
If not, can I copy/paste and update the tabs for room 2 but have it in the same Excel file – how would formulas/conditionings need to be updated?
Sorry this is a lot of info and hopefully makes sense.
Hello, I like the look of the Excel “Student Schedule” template (it autopopulates into a weekly calendar view based on the “Class List” tab and highlights column for today’s day of week and row for current time/hour). I want to update this template to do a few things.1. I won’t be using for class schedule but want to use to reserve vacant rooms in my office. So, I would change “Class Schedule” to “Vacant Room Availability” and Class List to “Sign-Up). (Changing names is simple, I can do that – but I’m not sure how it will affect formulas and conditioning that will need to be updated).2. On the “Sign-Up” tab – I don’t need all the data in the original Class List tab. I only need ROOM (there are 2 rooms available), PERSON, DAY, START TIME, and END TIME.-On the weekly calendar view (Vacant Room Availability tab aka Class Schedule), when you input data into a row on class list/sign-up tab – it highlights the cells according to the time duration and it has text from the “ID” column on the class list/sign-up tab. I want the text that is shown on the weekly view to be what’s under “Person” column to show John has room A from 1-2pm and Sally has room B from 8-9am.3. I want to add dates to the sheets and I want the calendar view and sign-up/class list to update by week based on the date.-Date could be easily added by adding a row above the named days of the week. So there can be a dedicated cell that has Sunday’s date for a given week then in the row above the words Sunday through Saturday, it will autopopulate the date for that day. When you change the date for the dedicated Sunday cell – it should update the rest of the dates above the days of the week… I’ve figured out how to do that but the issue now is making it dynamic so the weekly view “refreshes” so to speak to view corresponding bookings for that week.-That would mean updating the Sign-Up/Class List tab to also include a cell dedicated to Sunday’s date for a given week. My hope is that when that date cell is updated the table in the Sign-Up/Class List tab will refresh. So let’s say there’s bookings in for this week 8/25/24 – that should autopopulate on weekly view. But if I change sign-up to 9/1/24 it should be blank since no bookings have been added and the weekly view should also be blank. 4. Since there are 2 different rooms that can be booked – I’m not sure if I need to copy/paste the tabs for room 2 or if they can be added on the same weekly calendar view. As is, the template only allows one highlight for a certain day/time based on data in the Class List tab. If I try to schedule 2 different things in the class list tab for Wednesday from 1-3pm – it doesn’t show both bookings. Is there a way to show both rooms (in different colors) booked for the same day/time on the same weekly view – if so that is my preference.If not, can I copy/paste and update the tabs for room 2 but have it in the same Excel file – how would formulas/conditionings need to be updated? Sorry this is a lot of info and hopefully makes sense. Read More
Is there a way to speed up this looped code
Hi all,
I have some code below that I am using to hide rows other than those with a specified value generated from a userform. The loop is super slow (took almost 30 minutes last night) and I am wondering how I can speed up the process. There won’t be 20k+ populated rows but the populated rows will grow over time. I am using such a large number to get more longevity out of the spreadsheet but in reality there may not be much more that 1 – 2k a year but even that will still take time to go through the loop.
I can build in something for users to purge resolved items but the # of populated rows, that aren’t resolved will still grow over time so I need to find a faster way of hiding unpopulated rows if possible.
I don’t want to use row filters because the worksheet is protected and I also need users to go through userforms to navigate the spreadsheet.
Any assistance would be appreciated.
Dim ws As Worksheet
Dim rng As Range
Dim cell As Range
‘ Set the worksheet
Set ws = ThisWorkbook.Sheets(“MAIN”)
‘ Set the range to the data range in Column H (adjust as needed)
Set rng = ws.Range(“R6:R20005”)
‘ Loop through each cell in the specified range
For Each cell In rng
If cell.Value <> CDate(courtdate) Then
‘ Toggle the row visibility
cell.EntireRow.Hidden = Not cell.EntireRow.Hidden
End If
Next cell
Hi all, I have some code below that I am using to hide rows other than those with a specified value generated from a userform. The loop is super slow (took almost 30 minutes last night) and I am wondering how I can speed up the process. There won’t be 20k+ populated rows but the populated rows will grow over time. I am using such a large number to get more longevity out of the spreadsheet but in reality there may not be much more that 1 – 2k a year but even that will still take time to go through the loop. I can build in something for users to purge resolved items but the # of populated rows, that aren’t resolved will still grow over time so I need to find a faster way of hiding unpopulated rows if possible. I don’t want to use row filters because the worksheet is protected and I also need users to go through userforms to navigate the spreadsheet. Any assistance would be appreciated. Dim ws As Worksheet
Dim rng As Range
Dim cell As Range
‘ Set the worksheet
Set ws = ThisWorkbook.Sheets(“MAIN”)
‘ Set the range to the data range in Column H (adjust as needed)
Set rng = ws.Range(“R6:R20005”)
‘ Loop through each cell in the specified range
For Each cell In rng
If cell.Value <> CDate(courtdate) Then
‘ Toggle the row visibility
cell.EntireRow.Hidden = Not cell.EntireRow.Hidden
End If
Next cell Read More
Improved user experience for Dictate in new Outlook for Windows and Outlook for the web
Hi, Microsoft 365 Insiders,
Outlook for Windows and the web just got even better!
The improved Dictate feature in the new Outlook for Windows and Outlook for the web is here to transform your email experience. With support for 50+ languages in Dictate, the new experience allows you to pause/resume dictation, adjust settings such as auto-punctuation and profanity filters, and access help articles with ease. Whether you’re drafting a quick email or a detailed message, Dictate makes it seamless.
Check out the full details in our new blog: Improved user experience for Dictate in new Outlook for Windows and Outlook for the web
Thanks!
Perry Sjogren
Microsoft 365 Insider Community Manager
Become a Microsoft 365 Insider and gain exclusive access to new features and help shape the future of Microsoft 365. Join Now: Windows | Mac | iOS | Android
Hi, Microsoft 365 Insiders,
Outlook for Windows and the web just got even better!
The improved Dictate feature in the new Outlook for Windows and Outlook for the web is here to transform your email experience. With support for 50+ languages in Dictate, the new experience allows you to pause/resume dictation, adjust settings such as auto-punctuation and profanity filters, and access help articles with ease. Whether you’re drafting a quick email or a detailed message, Dictate makes it seamless.
Check out the full details in our new blog: Improved user experience for Dictate in new Outlook for Windows and Outlook for the web
Thanks!
Perry Sjogren
Microsoft 365 Insider Community Manager
Become a Microsoft 365 Insider and gain exclusive access to new features and help shape the future of Microsoft 365. Join Now: Windows | Mac | iOS | Android Read More
Conditional Access Policy Block Downloads (Preview)
Hello Community,
I’ve been encountering a challenging issue with implementing a Conditional Access (CA) policy to block downloads on unmanaged devices and could really use some insights.
Here’s the situation:
Objective: Block downloads for unmanaged devices using Conditional Access.Setup: I’ve replicated the policy setup across two tenants, ensuring that licenses and CA policies are identical.
Problem:
In one tenant, the policy works flawlessly.In the other tenant, users experience a timeout on the “Access to Microsoft SharePoint Online is monitored” screen. After this timeout, they are given the option to bypass Defender for Cloud Apps, which is not the desired outcome.
I’ve tried the following troubleshooting steps:
Removed all conditions to isolate the issue—no success.Ensured that the test user has no roles associated.
Despite these efforts, I’m still unable to get the policy to work correctly in the problematic tenant. The timeout and bypass options are a major concern, as they defeat the purpose of the policy.
Has anyone encountered this issue before, or does anyone have suggestions for resolving this?
Thanks in advance for your help!
Hello Community,I’ve been encountering a challenging issue with implementing a Conditional Access (CA) policy to block downloads on unmanaged devices and could really use some insights.Here’s the situation:Objective: Block downloads for unmanaged devices using Conditional Access.Setup: I’ve replicated the policy setup across two tenants, ensuring that licenses and CA policies are identical.Problem:In one tenant, the policy works flawlessly.In the other tenant, users experience a timeout on the “Access to Microsoft SharePoint Online is monitored” screen. After this timeout, they are given the option to bypass Defender for Cloud Apps, which is not the desired outcome.I’ve tried the following troubleshooting steps:Removed all conditions to isolate the issue—no success.Ensured that the test user has no roles associated.Despite these efforts, I’m still unable to get the policy to work correctly in the problematic tenant. The timeout and bypass options are a major concern, as they defeat the purpose of the policy.Has anyone encountered this issue before, or does anyone have suggestions for resolving this?Thanks in advance for your help! Read More
Connection error popup low virtual memory
Getting a strange error occasionally from the Azure Remote Desktop client for my customer. I don’t think it is really about virtual memory on the client computer, and it occurs before any connection is even attempted to the virtual machine. Using client version 1.2.5620.0 (x64). I can’t seem to produce the error on demand, so far when it has occurred, it has been following a recent disconnection, but it doesn’t do it every time. I’m not finding anything too relevant in the logs on the client machine or the diagnostic logging for the Azure resources.
Remote Desktop
This computer can’t connect to the remote computer.
The problem might be due to low virtual memory on your computer. Close your other programs, and then try connecting again. If the problem continues, contact your network administrator or technical support.
Joe
Getting a strange error occasionally from the Azure Remote Desktop client for my customer. I don’t think it is really about virtual memory on the client computer, and it occurs before any connection is even attempted to the virtual machine. Using client version 1.2.5620.0 (x64). I can’t seem to produce the error on demand, so far when it has occurred, it has been following a recent disconnection, but it doesn’t do it every time. I’m not finding anything too relevant in the logs on the client machine or the diagnostic logging for the Azure resources. Remote DesktopThis computer can’t connect to the remote computer.The problem might be due to low virtual memory on your computer. Close your other programs, and then try connecting again. If the problem continues, contact your network administrator or technical support. Joe Read More
Teams left toolbar menu apps not showing
Hello guys,
Since today afternoon 29/08/2024 i have some issues with Teams left toolbar.
This is how it appear
And these are my configuration settings set by policy
As u can see my menu it’s completely messed up, and until yesterday night was ok… now i have tried to modify and apply config but nothing changes…
Any idea?
Versione
Hello guys,Since today afternoon 29/08/2024 i have some issues with Teams left toolbar. This is how it appearAnd these are my configuration settings set by policyAs u can see my menu it’s completely messed up, and until yesterday night was ok… now i have tried to modify and apply config but nothing changes… Any idea?VersioneHai la versione di Microsoft Teams 24215.1007.3082.1590.È stata ricevuta la versione più recente. È stato controllato l’ultima volta in data 29/08/2024.La versione client è 49/24080212008.Accesso in anteprima Read More
TSI Partner Community Update | August 2024
Hello Partners,
Get the latest update on Azure resources, the Dynamics 365 price promotion, Copilot for Microsoft 365 playbook and pitch deck for Nonprofits and the Digital Natives Partner Program. Be sure to attend the Copilot for Microsoft 365 CSP Activation event on September 5th and Save the Date for the Tech for Social Impact Partner Virtual Summit on September 30th!
Download the TSI August Community Update
Hello Partners,
Get the latest update on Azure resources, the Dynamics 365 price promotion, Copilot for Microsoft 365 playbook and pitch deck for Nonprofits and the Digital Natives Partner Program. Be sure to attend the Copilot for Microsoft 365 CSP Activation event on September 5th and Save the Date for the Tech for Social Impact Partner Virtual Summit on September 30th!
Download the TSI August Community Update
Read More
What’s New for Planner in Teams in August 2024
The Planner team is excited to share some fresh new updates in the Planner app for Microsoft Teams. We thank you for your valuable feedback that helps shape feature updates, and hope these capabilities significantly enhance your experience managing tasks and coordinating team initiatives.
Resize columns in Grid view
Customize your task view by resizing columns, making it easier to focus on what’s important. Try it out by navigating to Grid view in My Day, My Tasks, or any plan and hovering over any column to increase or decrease its width.
Discover Recommended Plans
We’re excited to introduce the Recommended Plans feature in the new Planner in Teams. This feature helps you quickly find relevant plans for your work by highlighting any new plans with tasks assigned to you that you haven’t yet viewed.
You’ll find the Recommended Plans view in My Plans, alongside other views like Recent, Shared, Private, and Pinned. Remember, the Recommended Plans view will only appear if there are new plans with tasks assigned to you that haven’t already been listed under Recent Plans.
An improved experience for copying plan links
Copying the link to a plan now pastes the link with the plan’s name, making it easier for you and your teammates to identify the linked plan. Select ‘Copy link to plan’ from the overflow menu of any plan and paste the link to check out this capability.
Use Copilot in Planner (preview)
While final pricing has not been announced, users with a Project Plan 3 or Project Plan 5 license can preview Copilot in Planner capabilities. Copilot in Planner (preview) can supercharge your project planning, task managing, and progress tracking processes. For more information on Copilot in Planner (preview), see: Try out the new Copilot in Planner (preview) today in the new Microsoft Planner in Teams – Microsoft Community Hub.
If you’d like to try this feature but don’t have a Project license, you can start a free 30-day trial of a Project Plan 3 license by selecting the diamond icon within the Planner app in Teams.
Access Planner in GCC
Government Community Cloud (GCC) users can now access the Planner app in Teams, ensuring secure and efficient task management. To learn more about this update, check out: The new Microsoft Planner in Teams is now available in GCC – Microsoft Community Hub.
Open premium plans faster
We’ve recently made several changes so you can open your premium plans 15% faster than before. We know that app performance is important to complete your work successfully and this is one of many enhancements we plan to make in this area. Try it out and let us know if you can feel the difference!
Share your feedback
Your feedback helps inform our feature updates and we look forward to hearing from you as you try out Planner’s new and existing capabilities! To share your feedback about the new Planner app in Teams, including bugs you’ve observed in our product, you can navigate to the ? icon in the Planner app and select ‘Feedback’ as seen in the GIF below. We also encourage you to share any features you would like to see in the app by adding it to our Planner Feedback Portal.
Learn more about the new Planner
Register now for our 9/17 inside look at the new Planner The new Microsoft Planner: What’s New and What’s Coming Next and AMA
Watch our first Meet the Makers and AMA
Watch the new Planner demos for inspiration on how to get the most out of the new Planner app in Microsoft Tea…
Read about our investments for organizations using the new Planner with frontline workers.
Try out the new Copilot in Planner (preview) today in the new Microsoft Planner in Teams
Check out the new Planner adoption website and explore new resources such as Day in the Life Guides to use Planner for task management, collaborative work management and project management.
We’ve got a lot more ‘planned’ for the new Planner this year! Stay tuned to the Planner Blog – Microsoft Community Hub for news.
For future updates coming to the new Planner app, please view the Microsoft 365 roadmap here.
Learn about Planner and Project plans and pricing here.
Read the FAQs here.
Microsoft Tech Community – Latest Blogs –Read More
New Microsoft Copilot Dashboard Features Now Available – August 2024
Introducing exciting new features to help you better understand and improve adoption and impact of Copilot for Microsoft 365 through the Copilot Dashboard. These features will help you track Copilot adoption trends, estimate impact, interpret results, delegate access to others for improved visibility, and query Copilot assisted hours more effectively. This month, we have released four new features:
Updates to Microsoft Copilot Dashboard:
Trendlines
Copilot Value Calculator
Metric guidance for Comparison
Delegate Access to Copilot Dashboard
We have also expanded the availability of the Microsoft Copilot Dashboard. As recently announced, the Microsoft Copilot Dashboard is now available as part of Copilot for Microsoft 365 licenses and no longer requires a Viva Insights premium license. The rollout of the Microsoft Copilot Dashboard to Copilot for Microsoft 365 customers started in July. Customers with over 50 assigned Copilot for Microsoft 365 licenses or 10 assigned premium Viva Insights licenses have begun to see the Copilot Dashboard. Customers with fewer than 50 assigned Copilot for Microsoft 365 licenses will continue to have access to a limited Copilot Dashboard that features tenant-level metrics.
Let’s take a closer look at the four new features in the Copilot Dashboard as well as an update to more advanced reporting options in Viva Insights.
Trendline Feature
Supercharge your insights with our new trendline feature. Easily track your company’s Copilot adoption trends over the past 6 months. See overall adoption metrics like the number of Copilot-licensed employees and active users. Discover the impact of Copilot over time – find out how many hours Copilot has saved, how many emails were sent with its assistance, and how many meetings it summarized. Stay ahead with trendline and see how Copilot usage changes over time at your organization. For detailed views of Copilot usage within apps and Copilot impact across groups for timeframes beyond 28 days, use Viva Insights Analyst Workbench (requires premium Viva Insights license). Learn more here.
Copilot Value Calculator
Customize and estimate the value of Copilot at your organization. This feature estimates Copilot’s impact over a given period by multiplying Copilot-assisted hours by an average hourly rate. By default, this rate is set to $72, based on data from the U.S. Bureau of Labor Statistics. You can customize it by updating and saving your own average hourly rate and currency settings to get a personalized view. This feature is enabled by default, but your Global admin can manage it using Viva feature access management. See our Learn article for more information on Copilot-assisted hours and value.
Metric Guidance for Comparisons
Discover research-backed metric guidance when comparing different groups of Copilot usage, for example, Copilot active users and non-Copilot users. This guidance is based on comprehensive research compiled in our e-book and helps users interpret changes to meetings, email and chat metrics. For the best results, compare two similar groups, such as employees with similar job functions or ranks. Use our in-product metric guidance to interpret results and make informed decisions with confidence. Click here for more information.
Delegate Access to Copilot Dashboard
Leaders can now delegate access to their Microsoft Copilot Dashboard to others in their company to improve visibility and efficiency. Designated delegates, such as the leader’s chief of staff or direct reports, will be able to view Copilot Dashboard insights and use them to make data-driven decisions. Learn more about the delegate access feature here. Admins can control access to the delegation feature by applying feature management policies.
Go Deeper with Viva Insights – Copilot Assisted Hours Metric in Analyst Workbench
For customers wanting a more advanced, customizable Copilot reporting experience, Viva Insights is available with a premium Viva Insights license. With Viva Insights, customers can build custom views and reports, view longer data sets of Copilot usage, compare usage against third party data, and customize the definition of active Copilot users and other metrics.
The Copilot assisted hours metric featured in the Microsoft Copilot Dashboard is now also available to query in the Viva Insights Analyst Workbench. When running a person query and adding new metrics, Viva Insights analysts will be able to find this metric under the “Microsoft 365 Copilot” metric category. The metric is computed based on your employees’ actions in Copilot and multipliers derived from Microsoft’s research on Copilot users. Use this new available metric for your own custom Copilot reports.
Summary
We hope you enjoy these new enhancements to Copilot reporting to help you accelerate adoption and impact of AI at your organization. We’ll keep you posted as more enhancements become available to measure Copilot.
Microsoft Tech Community – Latest Blogs –Read More
