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/2Views0likes0CommentsAD 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?Fish_TacosJan 21, 2025Brass Contributor40Views0likes2CommentsChanging Proofing Language for an Entire Presentation in PowerPoint
Turns out you can't just change the Proofing Language for an entire presentation in PowerPoint. You have to select text boxed one by one in order to change the proofing language. So the question is, is this the only way or there is some workaround to it? Thanks.Solvedjahongir abdurahmonovJan 21, 2025Brass Contributor231KViews1like31CommentsPractical 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/6Views0likes0CommentsEmail Approval
I am the admin for Office365. I have one employee who gets an email from outside the agency that comes to me for approval. This address has been whitelisted. I have checked the employees settings. I do not find a cause. Again it is only from one particular person. It is a Yahoo account but others come in with no need for approval. I'm at a loss.Solvedsmb985Jan 21, 2025Copper Contributor48Views0likes4CommentsMigrating 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 adviseAmr KhattabJan 21, 2025Brass Contributor4KViews0likes4CommentsPrimer: 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/10Views0likes0CommentsSharepoint 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-8024DaStiviJan 20, 2025Copper Contributor2.9KViews3likes5CommentsFormula 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.PravchaJan 20, 2025Copper Contributor1View0likes0CommentsHow 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/15Views0likes0Comments
Resources
Tags
- office 3658,061 Topics
- exchange2,029 Topics
- microsoft 3651,619 Topics
- admin1,404 Topics
- sharepoint1,197 Topics
- Microsoft 365 Apps1,117 Topics
- Microsoft 365 Groups768 Topics
- outlook673 Topics
- microsoft teams616 Topics
- security611 Topics