SpringhouseConsulting

The matrix of where Loop components are stored is available in the docs: learn.microsoft.com/en-us/mi…

so like OneDrive, a process is needed for handling this content when an employee leaves. This gets a bit complex, as this does not impact loop components created in a Teams chat or channel, as those are stored in OneDrive or SharePoint.

Loop components created in the Loop workpace and Copilot pages are both stored in a SharePoint embedded container for the user. These containers are listed and managed in the SharePoint admin center. Like OneDrive, a user's container will be deleted when the account is deleted...

and it's probably also good to make sure the agents aren't too easy to access, so that it doesn't replace search. Standard disclaimer: I'm not a licensing person, so do your due diligence. The licensing guide with more details is available here: learn.microsoft.com/en-us/po…

But, many folks are now using AI instead of search. If people start this same habit with copilot, those costs are going to be significant. Training users on when to use copilot vs search seems to be important,

If the copilot says "hello" (1 message), then answers a simple question using general generative ai (2 messages), and then a question that uses tenant data (30 messages), we're at about 33 cents for the conversation. If this saves a help desk call, this represents huge savings...

The licensing of Copilot is interesting. It costs about 1-30 cents per message to chat with a Copilot agent, for users without Microsoft 365 Copilot licenses. Yes, that's a big range, as the cost depends on what the copilot needs to do to answer the question.

Docs on this new feature are here: learn.microsoft.com/en-us/po…

across apps and flows. Using these functions requires the Dataverse connector, which means that users of these apps/flows will need premium licenses. This will also require good governance practices, as changing a function could impact multiple apps/flows.

"Functions" are in preview in Power Apps. These allow you to create a function in a solution, and then use it from any other app or flow in the environment. This would allow you to create complex logic once, and then use it as-needed, rather than copying and pasting...

and the AI can assist with troubleshooting or modifications.

to a file to create a library of snippets, making it easier to re-use controls across apps without having to rebuild them. Get assistance, as pasting code into a forum will make it easier for others to see what's going on. Use AI, as you can paste code into an AI ...

Code view in Power Apps is now generally available. r-click on a control or a screen and select "view code". A few good uses for non-developers: Compare two controls to find differences. Copy and paste controls or screens between apps. Copy code from a complex control...

If you were missing the ability to rearrange folders in New Outlook, that was recently added. Just drag and drop as desired.

SharePoint List Forms allow users to submit items to a list without having permission to the list or site. But, if the form includes a lookup column, the user needs read access to the lookup list. Without that permission, the form will submit, but the lookup field will be empty

To see basic capabilities and to learn the syntax, see the "getting started" template available on this MS blog post: techcommunity.microsoft.com/…

But, if you're looking to do data analysis with data frames, including the use of Python visualizations, then this is a pretty interesting addition to Excel.

Python in Excel rolled out a while ago, but is also now available in Excel for the Web. This is for more advanced users, and does not replace basic Excel functions. Well, it could, but performance and maintainability will be easier with native Excel functions when possible...

The February Power BI feature summary is out, and many of the updated features relate to Copilot. As a reminder, Copilot for Power BI is not included in the Microsoft 365 Copilot license, but is included in Power BI Premium licenses. (which means it's not available to pro users)

to convince your colleagues to use it also to get the most value out of it. Docs are here: support.microsoft.com/en-us/…