What's New in Microsoft EDU webinar - March 2025
Join us on Wednesday, March 12th, 2025 for our latest "What's New in Microsoft EDU" webinar! These 30 minute webinars are put on by the Microsoft Education Product Management group and happen once per month, this month both 8:00am Pacific Time and 4:00pm Pacific time to cover as many global time zones as possible around the world.
access to bookings
What does this message mean on microsoft booking, ive been trying to see my booking registry but i keep seeing this message, sometimes the massage varies when i try to access the app : Detailed message displayed: UTC Date: 2025-03-11T14:14:30.266Z Client Id: F6F199305D9541EDA2A53EE57C90EDB8 Session Id: 8009806d-b6f3-40b9-9ddd-0ef7ba2b900f Client Version: 20250310070 BootResult: network Back Filled Errors: Unhandled Rejection: Error: [object Object]:undefined|Unhandled Rejection: Error: [object Object]:undefined|undefined:undefined|undefined:undefined err: Error: [object Object] esrc: StartupData et: ServerError estack: Error: [object Object] at https://res.df.onecdn.static.microsoft/owamail/hashed-v1/scripts/owa.47106.6187e72c.js:1:71227 at async S (https://res.df.onecdn.static.microsoft/owamail/hashed-v1/scripts/owa.10245.3a6876a0.js:1:3108) at async https://res.df.onecdn.static.microsoft/owamail/hashed-v1/scripts/owa.10245.3a6876a0.js:1:2460 at async l (https://res.df.onecdn.static.microsoft/owamail/hashed-v1/scripts/owa.bookingsindexv2.b6602698.js:1:97492) at async w (https://res.df.onecdn.static.microsoft/owamail/hashed-v1/scripts/owa.bookingsindexv2.b6602698.js:1:100345)Microsoft Planner @Mention and Comment Notification in Microsoft Teams - NEW VERSION
Hi Planner Community, Thank you for the overwhelming support for my original post last year on how to @mention someone within the Microsoft Planner community and have a message automatically emailed to them. I'm excited to share that I've completely redesigned and updated the solution to now support the new Microsoft Teams Planner and remove the issues some users found with setting up the solution. Additionally, the notification is now an adaptive card within the Microsoft Teams chat to the user you @mentioned in the Microsoft Planner comment. Screenshot example above shows a comment posted by me in a Microsoft Planner task where I’ve @mentioned David at the end of the message. Screenshot example above shows the comment posted by me in Planner being automatically sent to David (thanks to the @mention in the comment) on Microsoft Teams. Allowing David to reply in either the traditional Planner or new Teams Planner. Attached is a zip file containing the Microsoft Power Automate solution, along with a detailed walkthrough to help you set it up. Enjoy! If you download the solution, all I ask is that you please give this post a thumbs up. Thanks, everyone! Matthew Davis No More Bad MondayAdding Data Points to a Table or Chart After Power Query Refresh
I have an Excel workbook that has a worksheet for calculating who doesn't have access to our system based on content on the site. These calculations use XLOOKUP to compare two other workbooks (1 CSV and 1 XLSX). I then have Power Query clean up that sheet to generate a report. The CSV and XLSX are also cleaned up with Power Query prior to the calculations taking place. The output of the final report looks like this: I would like to know the total count of people, the unique count of people, the number of people who are the sole owners, the number of people who are listed with other people who do have access. As you can see behind the blur under "Triggered Owner", there can sometimes be more than one. The tricky part here is that I would like to track these numbers in a new row in a table for each refresh, similar to the below, where the data doesn't completely erase each time. Run Date is when the refresh occurs. Is this possible?
Conditional formatting - new rule based on two related column headings
Need to create a new rule that changes cell colors (column H) based on more than 2 falls (column C) in 30 days for the same person (column A). I've found the formula for just the date - but not for adding in the same name. Goal is to be alerted (visual alert) if someone fell more than 2 times in 30 days. Thanks!
Exchange Online calendar sync tool
We have developed software that synchronizes Exchange calendars. For the past few months, we have been facing a new problem that we did not have before. We synchronize calendar entries based on the LastModifiedDateTime attribute of the Microsoft.Graph.Event class. We are puzzled by the fact that this attribute magically changes without any adjustments on our part. Do you have any advice on this?Cubeset with multiple Period range
Hey All! need help with creating a Cubeset formula! I've market data at region level for multiple period & brand! I want to know the rank of particular Brand in each region on Specific Period. Formula is working for a particular period but not working on a range! How can I use a range/dynamic period in cubeset. =CUBESET( "ThisWorkbookDataModel", "EXISTS([Brandmaster].[Brand].children, ([State_Master].[State].[Maharashtra], {[Calendar].[Month].[Oct-2024]:[Calendar].[Month].[Dec-2024]}))", "Set", 2, "{([Measures].[S_Value],[State_Master].[State].[Maharashtra],{[Calendar].[Month].[Oct-2024]})}" ) This is working for particular month but when I want to get data for 3 month like Oct-Dec =CUBESET( "ThisWorkbookDataModel", "EXISTS([Brandmaster].[Brand].children, ([State_Master].[State].[Maharashtra], {[Calendar].[Month].[Oct-2024]:[Calendar].[Month].[Dec-2024]}))", "Set", 2, "{([Measures].[S_Value],[State_Master].[State].[Maharashtra],{[Calendar].[Month].[Oct-2024]:[Calendar].[Month].[dec-2024]})}" ) I'm getting error on this. Range is working on set expression but while using same in Sort By (Highlighted Part), I'm getting the error. One way around is passing Each Month separately not tried that but I want it to be dynamic using timeline & using Min/Max function to define the range, it could be 2month or 12 month. Pls help me with this. Thanks
Issue in Days Function
Hello there, I am Balaji, I hope you are all doing well. I am using Windows 10 in Dell Latitude 7480 Laptop. I am facing an issue using the "Days" Function. DAYS Function Explanation and Description mentioned in Excel Software: DAYS FUNCTION This article describes the formula syntax and usage of the DAYS function in Microsoft Excel. For information about the DAY function, see DAY Function. Description: Returns the number of days between two dates. DAY function This article describes the formula syntax and usage of the DAY function in Microsoft Excel. For information about the DAYS function, see DAYS Function. Description: Returns the day of a date, represented by a serial number. The day is given as an integer ranging from 1 to 31. Now, If I am using the "DAYS" Function to calculate the number of days between two dates. Suggest me Which Function should I use to get the correct answer. I am Looking forward to your guidance. Thank you.
Index & Match formula not working on multiple column
https://onedrive.live.com/personal/8419718c3ad8f98c/_layouts/15/Doc.aspx?resid=8419718C3AD8F98C!s94600d3fa0044d418fefd1508e44c0e2&cid=8419718C3AD8F98C&migratedtospo=true&app=Excel Hi Folks, I'm facing error on the match formula, which I tried to apply, I'm getting #N/A error... I tried few trouble shoots to make it work (adding helper column, broke the formula with "&" to make it work, checking for any additional characters & checking the format etc) but it is not working. I have used Match formula earlier, but never had this issue. I want a single formula to MATCH & verify multiple column to return the desired output, I can do single column verification & again to do the next column verification and get the result but it is tedious and not time saving. Kindly help me to learn how to make a formula work to one validation of multiple column. Kindly attaching the sheet above for reference. Highlighted the error in yellow hue(Sheet name - result). m_tarler & HansVogelaar - Please help, Thanks in advance
