microsoft 365
2068 TopicsAre Microsoft partners using the Business Process Catalog? Looking for real-world adoption insights
Hi community, I'm curious to hear from Microsoft partners about your experience with the Business Process Catalog (BPC)- Microsoft's structured library of end-to-end business processes for D365 implementations. Specifically, I'd love to understand: Are you actively using the BPC in your D365 engagements? If yes, how and where does it fit into your delivery methodology? If not, what's holding adoption back — awareness, tooling, client readiness, or something else? We're seeing increasing attention on BPC as a foundation for structured implementation approaches, and I'm interested in how partners are (or aren't) integrating it into their practice. Would love to hear honest takes from the field. -Ellie36Views0likes2CommentsPlanning to Migrate OST Files to Microsoft 365 - Need Some Guidance Before I Start
Hey folks, I have a task coming up where I need to migrate OST files into Office 365 mailboxes. A few of the OST files I'm dealing with are orphaned or corrupted which is making me a bit nervous about the whole process. A couple of things I'm unsure about: How to handle OST files that are no longer linked to an active profile Whether corrupted OST files can still be migrated to Office 365 without major data loss Best way to verify data integrity after migration Haven't started yet and want to make sure I'm going in the right direction before I begin. Has anyone migrated corrupted or orphaned OST files to Office 365? What approach worked best for you?39Views1like2CommentsPower Apps + Excel Online: RFC 3339 Date/DateTime Format Error When Patching to Excel Date Columns
Hi everyone, I need help with a Power Apps canvas app connected to an Excel workbook stored in SharePoint/OneDrive. The app is a warehouse inventory system using Excel tables as the data source. The app has these Excel tables: tblSKU tblLocation tblInventory tblTransactions The main issue is with date fields when using Patch() from Power Apps to Excel. Error Message I keep encountering this error: Expected value "" to be valid RFC 3339 'date-time' format. Allowed ISO 8601 format(s): 'YYYY-MM-DDThh:mm:ssZ', 'YYYY-MM-DDThh:mm:ss+hh:mm', 'YYYY-MM-DDThh:mm:ss'. This happens during receiving / issuing / stock count transactions when patching to Excel. Date Columns Involved In tblTransactions, I have: DateTime TransDate ProductionDate ExpiryDate In tblInventory, I have: ProductionDate ExpiryDate LastUpdated These columns are formatted in Excel as Date or Date/Time. Current Patch Logic I already changed my formulas to stop saving formatted text like this: DateTime: Text(Now(), "dd mmm yyyy") TransDate: Text(Today(), "dd mmm yyyy") ProductionDate: Text(dpProductionDate.SelectedDate, "yyyy-mm-dd") ExpiryDate: "" Now I am trying to patch real date values instead: DateTime: Now(), TransDate: Today(), ProductionDate: If( IsBlank(dpProductionDate.SelectedDate), Blank(), dpProductionDate.SelectedDate ), ExpiryDate: If( IsBlank(varExpiryDate), Blank(), varExpiryDate ), LastUpdated: Now() However, I still sometimes get the RFC 3339 error. Sample Receiving Patch Here is the relevant part of my receiving button: Patch( tblTransactions, Defaults(tblTransactions), { TransID: Text(GUID()), DateTime: Now(), TransDate: Today(), Type: "RECEIVE", SKU: varSKU.SKU, Barcode: varBarcode, Description: varSKU.Description, Category: varSKU.Category, UOM: varSKU.UOM, LotNo: Upper(txtLot.Text), ProductionDate: If( IsBlank(dpProductionDate.SelectedDate), Blank(), dpProductionDate.SelectedDate ), ExpiryDate: If( IsBlank(varExpiryDate), Blank(), varExpiryDate ), Location: drpLocation.Selected.LocationCode, Qty: Text(Value(txtQty.Text)), User: User().FullName, Status: "POSTED", Remarks: "" } ) Expiry Date Calculation The expiry date is calculated based on SKU shelf life: Set( varShelfLifeDays, IfError( Value(varSKU.ShelfLifeDays), 0 ) ); Set( varExpiryDate, If( varShelfLifeDays > 0, DateAdd( dpProductionDate.SelectedDate, varShelfLifeDays, TimeUnit.Days ), Blank() ) ); Related Issue In galleries and labels, Excel sometimes returns date values as serial numbers, for example: 46192 So I had to use formulas like: Text( DateAdd( Date(1899,12,30), Value(Text(ThisItem.ExpiryDate)), TimeUnit.Days ), "dd mmm yy" ) This works for display, but I am still unsure about the correct way to patch date/date-time values back to Excel. Any guidance would be very much appreciated. Thank you.29Views0likes1CommentThe latest mobile apps killed mobile first when working with files
Hi, I really enjoyed working only with mobile devices when we started with M365. On iOS the OneDrive app was paramount when organising files in SharePoint/Teams Sites. Easy up- and downloads, drag‘n drop. Move and copy all was there to manage a companies files on mobile devices even when only on mobile network connections. But the upgrades that happened over the last 1-2 years completely break this kind of workflows. There is no really mobile-first paradigm visible anymore. The OneDrive app was worst. All the pretty well integration file management stuff is gone. No drag‘n drop. No useful integration into iOS Files app. Copying between OneDrive and SharePoint got a pain. Bulk operation just silently fail. Files get renamed without any warning (numbers get added to the name or are just increased so no one will ever find the file again). So just two simple usability examples that are a mess: to select multiple files in a folder you have to press the word ‚Select‘ that is not a button or something. This shows up like a column heading in the file view. Right beside ‚Name‘ and ‚Date Modified‘. Why are active user elements placed in table headings? If you browse into some SharePoint folders and quickly want to go back to your OneDrive files you either have to press the back button over and over again until your back to the top level view or you can press-hold the back button and then select ‚Files‘. Butthe latter brings you to the top level Library view and you still have to manually go to ‚Files‘. The old app design just had a top menu bar where views could easily be switched. Am I the only one who wants to work on mobile devices? Does Microsoft still expect everyone to use a laptop and run desktop apps? Annoying.40Views0likes1CommentBest way to run pulse surveys inside Teams?
I’m looking for a lightweight way to run recurring pulse surveys directly in Teams. Forms works fine for basic questions, but follow-up, reminders, anonymity, and reporting become manual pretty quickly. Curious what others are using for short employee check-ins or sentiment surveys inside the Microsoft ecosystem. Or am I not using Forms to its full potential?20Views0likes1CommentHow Much Will the July 2026 License Increases Cost Your Microsoft 365 Tenant?
July 1, 2026, sees a bunch of monthly price increases that will affect Microsoft 365 tenants. How much will the increases cost your tenant? One way to find out is to use PowerShell to find which licenses assigned to user are affected by the price increases and compute the effect of the monthly increase (which varies across products). It’s a great example of how flexible PowerShell is for tenant management. https://office365itpros.com/2026/06/16/monthly-license-increase-july-2026/99Views0likes2CommentsDoes CSPP Support Microsoft Copilot
We are working on an integration with Microsoft's Cloud Storage Partner Program and already started getting questions on Copilot support. Does CSPP support using copilot in the Microsoft for the web editors? I wasn't able to find anything mentioning it in the documentation for CSPP or CSPP+.24Views0likes1CommentCost Savings In Microsoft 365
Long story short, I had a client say, "We have more M365 licensed users than employees. Please help us find them." It took me about a week to find all the waste (first time always takes forever). Now I've run the same steps for a dozen other clients (takes less than an hour now). On average, I've been able to save clients 22% of their budget. Thought I'd share exactly how I do it. There are 5 areas of waste in Microsoft 365: Remove licenses from disabled users. Remove licenses from inactive users. Downgrade licenses on over-licensed users. Stop paying for unassigned licenses. Redefine the license terms. NOTE: I have the steps using the admin center, PowerShell, and a third-party app, but it's too long to re-post in Reddit. Go to Microsoft 365 License Audit to see all the steps. Find Disabled Users Log in to the Microsoft 365 admin center. Users > Active Users > Export > Continue. Open the spreadsheet. In the Home Ribbon, click Sort & Filter > Filter Click the dropdown in the Licensed column > uncheck Unlicensed > click OK Click the dropdown in the Block credential column > uncheck FALSE > click OK. Find Inactive Users NOTE: You need to either have a Microsoft Entra P1 license or use a third-party app to get this data. Open Microsoft Entra Admin Center Users > Manage view > Edit columns. Remove, replace, or add so the only columns you can see are: Display name, User principal name, User type, Identities, Assign licenses, and Last interactive sign-in time. Click Save. Click Download users > Start bulk operation Wait for the success pop-up message to appear, then click the notification bell at the top of the page. Under the notifications menu, click Success!, and then select the [report name]. Open the downloaded spreadsheet. Click Sort & Filter > Filter to enable the column filters. Click the drop-down in the assignedLicenses column. Uncheck any empty options, i.e., []. Click OK. Click the drop-down in the signInActivity column. Click Sort A to Z. Any users who have an empty signInActivity or a sign-in that was over 30 days ago can be safely disabled, and the license removed after the data is properly secured. Find Downgradable Users Review the report located on the website, then click Export. Open the CSV in Excel. Next, download the Microsoft 365 apps spreadsheet by going back to Reports > Usage and clicking View More located under “Active users - Microsoft 365 Apps” Review the report and click Export. You can start by deleting everyone that you’ve already determined hasn’t logged on or is currently disabled. Add the filter by clicking Sort & Filter in the home ribbon > Filter. Add a column for Current Licenses. Copy the licenses from the How To Use The Admin Center To Find Inactive Users spreadsheet you downloaded earlier into the new column. Be sure to align the user names in both spreadsheets. Add a column for Microsoft 365 Apps. Copy the Last Activity Date column from the Pro Plus Usage report you downloaded above in step 7 into the Office 365 app usage spreadsheet you’ve been using. Be sure to align the new data with the appropriate users in the Office 365 app usage report. For each of the following columns, click the drop-down next to the column name and filter out any logins that have happened in the last month. OneDrive Last Activity Date SharePoint Last Activity Date Skype For Business Last Activity Date Yammer Last Activity Date Team’s Last Activity Date Microsoft 365 Apps The users who have not been filtered out are excellent candidates for Exchange Online-only licenses. You may want to double-check their usage of other apps before making any license changes on their accounts. Find Unassigned Licenses Open the Microsoft 365 admin center. Click Show All > Billing > Licenses. On that webpage, you’ll see a list of all your licenses in your organization, along with a column labeled “Available Licenses”. Any number above 0 in the Available Licenses column is typically safe to remove from your organization with two caveats. Some licenses aren’t assigned to users through the Microsoft 365 admin center. NOTE: Some licenses are consumed as they are used. For example, additional storage licenses for SharePoint Online may show as available, but removing them will decrease the amount of free space available in SharePoint Online and possibly cause a disruption to SharePoint Online usage. Redefine The License Terms Microsoft adjusted its pricing model, charging different rates for the same license based on commitment terms, billing frequency, or sector-specific eligibility. The subscription length Billing Frequency Go to the Microsoft 365 admin center Click Billing > Licenses > Select the license you want to review. Click ellipsis (…) next to the subscription > Manage subscription settings. You can view the billing settings right on this page.51Views1like1CommentAnnouncing Microsoft 365 for IT Pros (2027 Edition)
The editorial team is happy to announce the publication of Microsoft 365 for IT Pros (2027 edition) eBook, the most comprehensive and up-to-date book covering tenant management. Previously named Office 365 for IT Pros and now spanning four books with the addition of Microsoft Purview for IT Pros and Power Platform for IT Pros, Microsoft 365 for IT Pros includes coverage of Exchange Online, SharePoint Online, Entra ID, Teams, Planner, and many other aspects of the Microsoft 365 ecosystem, including hundred of examples of using PowerShell and the Microsoft Graph to automate tenant operations. https://office365itpros.com/2026/07/01/microsoft-365-for-it-pros/51Views1like0Comments