Forum Widgets
Latest Discussions
Primer: Output Data Generated with an Azure Automation Runbook to a SharePoint List
The second part of the Azure Automation runbook primer brings us to output, specifically how to create items generated by a runbook in a SharePoint Online list. Once in the lists, items can be processed using Power Automate, Power Apps, or Power BI or exported to Excel. It’s a great way of capturing information generated by background jobs. https://office365itpros.com/2025/01/22/azure-automation-runbook-list/AD Hybrid MailUser
I started a new job and noticed that the Exchange Online but the AD is hybrid and all the exchange attributes need to be managed in on-premises AD for proxyAddresses and Aliases. I didn't see an Exchange Server and was told it was uninstalled. How would I check that? I need to create a few MailUsers but the user accounts already exist. I have read that I should be able to Enable-Mailuser but that doesn't exist on Exchange online. How should I proceed in converting some Users to MailUsers without an exchange server on premise?
Practical Copilot: Creating a Declarative Agent
Microsoft is all in for Copilot at present and agents are a big part of the story. Multiple ways exist to create a declarative agent for use with Copilot in BizChat and Teams. This article reviews how to create an agent with the Teams Toolkit, Copilot Studio, and Microsoft 365 Copilot - and if any usage data are created for custom agents. https://practical365.com/copilot-declarative-agent/
Migrating G suite to Office 365
Dears, Good day, I working on a company which hosted their email on G suite, and I want to migrate all mailboxes, calendar, tasks, files, all things to Office 365. kindly let me know the steps for Migration, we have 69 users needed to be completely migrated. Kindly advisePrimer: How to Use Azure Automation to Run Microsoft Graph PowerShell SDK Scripts
A reader asked why it seems so difficult to use Azure Automation runbooks to process Microsoft 365 data. In fact, it’s not so hard, and here’s a primer to help you understand how to create the necessary Azure Automation environment to develop and execute runbooks. Once modules and permissions are in place, everything falls into place. https://office365itpros.com/2025/01/21/azure-automation-runbook-primer/
Sharepoint Online Modern experience issues with custom views
Hi, i propapbly found a "bug" with the modern ui of sharepoint online... its not possible to customize the default views for root and subfolders: also postet it on uservoiceforums... https://sharepoint.uservoice.com/forums/329214-sites-and-collaboration/suggestions/34688932-different-type-of-view-in-sharepoint-document-libr http://www.cyberviva.com/sharepoint/different-type-of-view-in-sharepoint-document-library-root-sub-folder/ https://camerondwyer.wordpress.com/2014/01/06/harness-sharepoint-default-views-at-different-navigation-hierarchy-levels-to-build-more-appealing-solutions/#comment-8024
Formula not working - Dynamic array for subtraction
Currently I'm facing a error with the below formulas, which is giving Error"You have entered too many Argument for this function" or simply "Zero" is coming as output. Hence requesting any SME support to fix this formula and help me to make use in my spreadsheet. Below few trouble shoots done from my end before publish my concern here: 1. I have ensured there is no blank cells or without values. 2. I'm using MS-excel 365. where few functions in the formula is compatible for my version as mentioned on the internet. Formula 1: =IF(COUNTA(BD3:BO3)<1, "", IF(LOOKUP(2,1/(BD3:BO3<>""), BD3:BO3) = LOOKUP(2,1/(BD3:BO3<>""), OFFSET(BD3:BO3, 0, -1)), LOOKUP(2,1/(BD3:BO3<>""), BD3:BO3), INDEX(BD3:BO3, 1) - SUM(FILTER(BD3:BO3, (BD3:BO3<>"") * (BD3:BO3<>OFFSET(BD3:BO3, 0, -1))))) ) Formula 2: =IF(COUNTA(BD3:BO3)<1, "", LET( LastValue, LOOKUP(2, 1/(BD3:BO3<>""), BD3:BO3), PreviousValue, LOOKUP(2, 1/(BD3:BO3<>""), OFFSET(BD3:BO3, 0, -1)), IF(LastValue = PreviousValue, LastValue, PreviousValue - LastValue) ) ) Formula Purpose Intended: To dynamically subtract the values from left to right on the last 2 non-empty cells from the given range BD3:BO3 1. Running Subtraction: Subtract values of last 2 non-empty - Last non-empty cell from the above specified range, it should subtract the last 2 non-empty cell only, whenever the range sequentially get updated with values. 2. Ignore Duplicates: If the value being a duplicate/same in the last 2 non-empty cell, then the subtraction operation should be skipped & the formula should only give the same value in the last non-empty cell. Please help me to fix this, I have tried multiple measures but still the error persist . I have attached sheet as well.How to Replace Group Owners When They Leave the Organization
Deleting an Entra ID user account can result in ownerless groups if the account being removed is the only group owner. Before deleting accounts, it’s a good idea to proactively replace group owners. This article explains how to replace group owners in the fastest and most scalable manner using the Microsoft Graph PowerShell SDK. https://office365itpros.com/2025/01/20/replace-group-owners-powershell/
