Forum Widgets
Latest Discussions
Power 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.
Outlook Classic - Crashes When Drafting with Copilot in RDS environment
Hi all, I'm interested to see whether anyone else is experiencing this issue, particularly in an RDS environment. We have a number of users who have paid-for Microsoft 365 Copilot licences, including the integration within Office applications such as Outlook, Word and Excel. In Outlook Classic running on our Windows Server 2019 RDS environment, Copilot no longer works correctly. When a user presses Alt + I to Draft with Copilot, or clicks the Copilot pencil icon within the body of an email, and then enters a prompt, Copilot displays "Writing your email" and the blue progress bar starts moving from left to right. At that point it freezes, Outlook crashes, and closes. In some cases Outlook will automatically reopen after the crash. The Copilot integration appears to work fine in Excel and Word. Is anyone else running Outlook Classic in a Windows Server 2019 RDS environment with Microsoft 365 Copilot licences? I would be interested to know if you have experienced the same issue. I've tried repairing and reinstalling Office apps, and always ensure they are fully up to date. Thanks.
Best Approach to generate Users Permission Matrix report for specific all Site Collection in tenant
Hi , I am looking for the best approach we can opt for to fetch permission of a specific user for all site collection in a tenant. -The permission matrix should include permission given to a user through m365 group , security group and SharePoint groups. Note: My client Tenant is already huge and still increasing Any suggestions are most welcome.
Cannot install addins
I am a Microsoft 365 Personal user. When I try to add the Claude for Excel Addin (for the Desktop version of Excel), I get an error: "Error loading add-ins. One or more add-ins failed to load. See your add-ins.". However, this is not specific to the Claude addin, since every addin gives the same error. When I click on the My-Addins option and then "refresh", I get another error: "Access denied to catalog." Signing in and out of Office does not fix the issue. Clearing the Office 365 cache did not fix the problem. The issue extends to Powerpoint and Word as well. I cannot add any addins to the web versions of Office either. Interestingly, if I download an XML manifest file, I can use the "Manage my addins" option in the web versions of Office 365 to manually add the addins. But still no luck with the Desktop versions. Anyone have any thoughts on how to fix this? Do I need to manually reinstall Office 365? I also noticed that the "Get Add-ins" button in "Account" settings is disabled.Word for iPad cannot edit documents marked as “Recommended Reading” in Windows
I have a Word document created in Windows that was saved with the “Recommended Reading” option. When I open it in Word for iPad, the file is locked in reading mode and there is no option to switch to editing mode. Word Online can edit the document without any issues, so it seems that the limitation affects only the Word app for iPad. This appears to be a recent limitation, since the document could be edited without any issues a couple of months ago. Is this a known limitation in Word for iPad? Is there any way to remove this flag from the iPad or force editing mode without having to return to Windows? Thank you.
The 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.
Are 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. -Ellie
How do you roll up individual goals into department or company goals in M365?
We’re trying to manage goals across teams using Microsoft 365, but the structure gets messy fast. Individual goals live in different places, and it’s hard to see how they connect to department or company-level objectives. With Viva Goals out of the picture, has anyone built a clean way to roll up goals in M365, or is this something better handled with a dedicated OKR/performance tool? (I honestly wouldnt want to use something third party and much rather keep things in MS 365)
