Month: September 2024
O365 Groups | Removing group membership in bulk for certain groups
Hi,
I have a csv list of O365 groups that I want to remove all user memberships from.
Does anyone have a script to achieve that?
Thanks/Brgds
joao
Hi,I have a csv list of O365 groups that I want to remove all user memberships from.Does anyone have a script to achieve that?Thanks/Brgdsjoao Read More
Unable to edit meeting options
I’m the IT Administrator for our company. We frequently organise Teams-meetings from shared mailboxes. As an invitee and delegated mailbox user i’m not able to edit the meeting options and make myself co-organisor. This should be possible according to https://learn.microsoft.com/en-us/microsoftteams/troubleshoot/meetings/teams-meeting-with-shared-mailboxes. Is there any chance to make this work?
I’m the IT Administrator for our company. We frequently organise Teams-meetings from shared mailboxes. As an invitee and delegated mailbox user i’m not able to edit the meeting options and make myself co-organisor. This should be possible according to https://learn.microsoft.com/en-us/microsoftteams/troubleshoot/meetings/teams-meeting-with-shared-mailboxes. Is there any chance to make this work? Read More
Calculate duration of cells but within a certain range
Hello!
I’ve been trying out different formulas but I can’t get it to work. So as per below data, column B is a set of duration timecodes. I want to calculate the duration of the timecodes that only fall between C to T (coloured). And the formula won’t repeat itself on the same set of C to T. Does anyone know how? thank you!
Hello! I’ve been trying out different formulas but I can’t get it to work. So as per below data, column B is a set of duration timecodes. I want to calculate the duration of the timecodes that only fall between C to T (coloured). And the formula won’t repeat itself on the same set of C to T. Does anyone know how? thank you! Read More
Need Assistance with Wallpaper Configuration on Fully Managed Android Devices
Hi everyone,
I’m trying to configure Android devices (specifically Samsung A7) as fully managed with a custom wallpaper for both the home and lock screens, using a launcher app.
I’ve set up a configuration policy under Device Restrictions > Device Experiences, with the experience type set to Microsoft Launcher (fully managed). I included the wallpaper URL, sized correctly to the device’s pixel resolution. However, the image appears zoomed in on the home screen and lock screen.
Interestingly, when I tested the same setup in Kiosk mode, the image displays correctly on the home screen, but it doesn’t apply to the lock screen. In contrast, the Microsoft Launcher (fully managed) setup does apply the wallpaper to both screens, but the image is zoomed in on the home screen.
Does anyone have suggestions for fixing this issue? I’d consider using Kiosk mode if it allowed setting the lock screen image as well, but it only sets the home screen. Additionally, I’m unable to get the camera app to appear in Kiosk mode.
Any ideas would be appreciated!
Hi everyone, I’m trying to configure Android devices (specifically Samsung A7) as fully managed with a custom wallpaper for both the home and lock screens, using a launcher app. I’ve set up a configuration policy under Device Restrictions > Device Experiences, with the experience type set to Microsoft Launcher (fully managed). I included the wallpaper URL, sized correctly to the device’s pixel resolution. However, the image appears zoomed in on the home screen and lock screen.Interestingly, when I tested the same setup in Kiosk mode, the image displays correctly on the home screen, but it doesn’t apply to the lock screen. In contrast, the Microsoft Launcher (fully managed) setup does apply the wallpaper to both screens, but the image is zoomed in on the home screen.Does anyone have suggestions for fixing this issue? I’d consider using Kiosk mode if it allowed setting the lock screen image as well, but it only sets the home screen. Additionally, I’m unable to get the camera app to appear in Kiosk mode.Any ideas would be appreciated! Read More
Spreadsheet integrity review
I have an Excel workbook with 15 sheets, 8334 cells with data, and 5851 formulas.
Objective: Perform an integrity review, i.e. reviewing a spreadsheet to ensure that its data, formulas, and overall structure are accurate, reliable, and free from errors or inconsistencies.
For example, to perform tests such as:
Check Data Integrity
Validate Data Entries to ensure that all data entries are accurate, complete, and in the correct format, e.g. by looking for:
Inconsistent data types (e.g., mixing text with numbers in a column).Duplicate entries or missing data.Data that doesn’t make logical sense (e.g., negative values where only positives are expected).
Apply data validation rules to ensure that data inputs are within expected ranges and formats.
Review Formulas & Calculations
Check for Formula Accuracy to verify that all formulas are correct and reference the correct cells, by looking for common errors such as:
Incorrect cell references (e.g., referencing the wrong sheet or row).Use of hard-coded numbers instead of cell references, which can lead to errors when data changes.Ensure there are no unintended circular references, as these can create errors or misleading results.
Test Error Handling
Look for Error Values: Review the spreadsheet for any error messages (e.g., #DIV/0!, #VALUE!, #REF!). Investigate and resolve any errors found.
Is there a way (add-in, tool, macro) that has been purpose-built to perform such tests?
I have an Excel workbook with 15 sheets, 8334 cells with data, and 5851 formulas. Objective: Perform an integrity review, i.e. reviewing a spreadsheet to ensure that its data, formulas, and overall structure are accurate, reliable, and free from errors or inconsistencies. For example, to perform tests such as:Check Data IntegrityValidate Data Entries to ensure that all data entries are accurate, complete, and in the correct format, e.g. by looking for:Inconsistent data types (e.g., mixing text with numbers in a column).Duplicate entries or missing data.Data that doesn’t make logical sense (e.g., negative values where only positives are expected).Apply data validation rules to ensure that data inputs are within expected ranges and formats.Review Formulas & CalculationsCheck for Formula Accuracy to verify that all formulas are correct and reference the correct cells, by looking for common errors such as:Incorrect cell references (e.g., referencing the wrong sheet or row).Use of hard-coded numbers instead of cell references, which can lead to errors when data changes.Ensure there are no unintended circular references, as these can create errors or misleading results.Test Error HandlingLook for Error Values: Review the spreadsheet for any error messages (e.g., #DIV/0!, #VALUE!, #REF!). Investigate and resolve any errors found.Is there a way (add-in, tool, macro) that has been purpose-built to perform such tests? Read More
best crypto presale
The crypto world is buzzing about Artemis Coin! 🚀 If you’re looking for the best crypto presale, Artemis Coin stands out with its real-world use in global trade and an innovative blockchain platform. 🌐 Secure your spot in this game-changing presale before it’s too late! Learn more here: best crypto presale and be part of the future of cryptocurrency!
The crypto world is buzzing about Artemis Coin! 🚀 If you’re looking for the best crypto presale, Artemis Coin stands out with its real-world use in global trade and an innovative blockchain platform. 🌐 Secure your spot in this game-changing presale before it’s too late! Learn more here: best crypto presale and be part of the future of cryptocurrency! Read More
New Custom and Managed Python images in Azure Data Explorer
Azure Data Explorer (ADX) supports running Python code embedded in KQL query using the python() plugin . The plugin runtime is hosted in a sandbox, an isolated and secured environment hosted on ADX existing compute nodes. This sandbox contains the language engine as well as common mathematical and scientific packages. The plugin extends KQL native functionalities with a huge archive of OSS packages, enabling ADX users to run advanced algorithms, such as machine learning, statistical tests, time series analysis and many more, as part of the KQL query.
We are constantly working to improve the Python plugin capabilities, and today we introduce new managed Python images as well as the option to fully customize the Python image to include your required Python packages:
Managed images are Python environment that are built and maintained by the Kusto team, containing specific Python engine and a set of packages. We are adding today Python 3.11.7 and Python 3.11.7 DL (containing torch & tensorflow), both images contain up to date Python engine 3.11.7 and packages (you can review the full contents of these images by clicking the respective links).
Custom images let you create your specific Python images in case you need additional packages or different versions of the Python engine and/or packages. You can create a custom image from scratch by specifying the Python engine and supplying a requirements text file containing full list of packages, or by selecting a base existing image and supplying a minimal requirements file containing only the additional packages to install on top of the base image.
Defining a custom Python image from ADX portal
For further information see Create a custom image – Azure Data Explorer | Microsoft Learn and Python plugin packages – Kusto | Microsoft Learn
You are welcome to try it and share your feedback!
Microsoft Tech Community – Latest Blogs –Read More
Showing remaining options on a list
Hoping that someone might be able to help answer a question about lists in Excel. I’m trying to find a way of listing the remaining options not selected from a list and was wondering if this is possible to do. For instance, in devising a rota where two people out of a group of 6 need to work each week and are listed in column A and B respectively, is there a way of listing those not working (i.e. the remaining 4 who would be on reserve) in column C? Any advice or suggestions would be much appreciated!
Hoping that someone might be able to help answer a question about lists in Excel. I’m trying to find a way of listing the remaining options not selected from a list and was wondering if this is possible to do. For instance, in devising a rota where two people out of a group of 6 need to work each week and are listed in column A and B respectively, is there a way of listing those not working (i.e. the remaining 4 who would be on reserve) in column C? Any advice or suggestions would be much appreciated! Read More
Finance Licensing MOQ
Just need some help got a partner quoting on Finance – minimum order quantity 20 obviously
Another partner has advised the customer that they could mix say 11 finance with say 9 project ops. Every time we tried to do this in the past its been a no – it has to be 20 of the same product or has this changed?
I believe the other partner is getting confused but just need to double check with you and see if you have any MS info on it? The license guide & product info is not very helpful unfortunately
Just need some help got a partner quoting on Finance – minimum order quantity 20 obviously Another partner has advised the customer that they could mix say 11 finance with say 9 project ops. Every time we tried to do this in the past its been a no – it has to be 20 of the same product or has this changed? I believe the other partner is getting confused but just need to double check with you and see if you have any MS info on it? The license guide & product info is not very helpful unfortunately Read More
Agents are the Most Interesting Initiative in Copilot Wave 2
Microsoft’s big launch of Copilot Wave 2 featured many new capabilities, like a super-duper focused Inbox for Outlook (one that works this time), Python in Excel, and a profusion of agents for SharePoint Online. The idea behind agents is pretty good and should be valuable, even if IT might have some dark thoughts about how agents might allow people to access information that they shouldn’t (this won’t happen).
https://practical365.com/copilot-wave-2-agents/
Microsoft’s big launch of Copilot Wave 2 featured many new capabilities, like a super-duper focused Inbox for Outlook (one that works this time), Python in Excel, and a profusion of agents for SharePoint Online. The idea behind agents is pretty good and should be valuable, even if IT might have some dark thoughts about how agents might allow people to access information that they shouldn’t (this won’t happen).
https://practical365.com/copilot-wave-2-agents/ Read More
Lookup column does not display data from source list if it reaches the threshold limit in sharepoint
I have two lists: Source and target list
The source list has reached the threshold limit but I am able to view the items by creating views and adding filters. The problem is the lookup column. In the target list, the lookup column does not gather data from the source list because it has reached the threshold limit.
The lookup column also does not consider the views created or the filters added. It grabs ALL of the items in the list.
Can someone please explain how to bypass the threshsold limit in sharepoint online?
I have two lists: Source and target listThe source list has reached the threshold limit but I am able to view the items by creating views and adding filters. The problem is the lookup column. In the target list, the lookup column does not gather data from the source list because it has reached the threshold limit.The lookup column also does not consider the views created or the filters added. It grabs ALL of the items in the list.Can someone please explain how to bypass the threshsold limit in sharepoint online? Read More
Azure Devops — Pipeline Issue
Hey all,
I have a repo on Azure devops, and as I am trying to create a build pipeline. However, I am facing this error:
Please tell me how to resolve this .
Thanks !
Hey all, I have a repo on Azure devops, and as I am trying to create a build pipeline. However, I am facing this error:Please tell me how to resolve this . Thanks ! Read More
MS Forms – Sorry, something went wrong error
I have a user that is adamant that they created a form that they can no longer access, they keep getting ‘sorry, something went wrong’ error.
Im not sure how to check form details, like ownerID, she might not be the original owner etc.
I have a user that is adamant that they created a form that they can no longer access, they keep getting ‘sorry, something went wrong’ error. Im not sure how to check form details, like ownerID, she might not be the original owner etc. Read More
Auto Hide Row based on Drop Down Selection
I’m trying to find a way to have a perpetually running filter that will auto hide the row anytime I select “Yes” from the Dropdown in column H. I want it to only hide that row in which “Yes” is selected.
I can manually run a Filter from Data>Filter and then on that Column select the filter and uncheck the word “Yes” which will hide the rows.
The problem is that, this is a ever growing list and each time I enter new information and select “Yes” it does not auto hide and I have to rerun the filter. I’m hoping there is a way to run something to have this happen every time I select “Yes” without having to rerun the action after new data is entered.
If it helps the Rows that this would apply to, are 6-50 and as stated before the value “Yes” will be selected from the dropdown in Column H.
I’m trying to find a way to have a perpetually running filter that will auto hide the row anytime I select “Yes” from the Dropdown in column H. I want it to only hide that row in which “Yes” is selected. I have yes selected in Column H and it highlights the whole row green I can manually run a Filter from Data>Filter and then on that Column select the filter and uncheck the word “Yes” which will hide the rows. I can apply a filter to remove all the Yes’sThe problem is that, this is a ever growing list and each time I enter new information and select “Yes” it does not auto hide and I have to rerun the filter. I’m hoping there is a way to run something to have this happen every time I select “Yes” without having to rerun the action after new data is entered. When I select Yes again on a new Row afte applying filter it doesn’t filter it out and I have reapply the filter on any new data added. If it helps the Rows that this would apply to, are 6-50 and as stated before the value “Yes” will be selected from the dropdown in Column H. Read More
Get-Mailbox Versus Get-ExoMailbox
Microsoft’s advice is to use the Get-ExoMailbox cmdlet instead of its older Get-Mailbox counterpart. Generally, this is good advice that you should follow. However, the older cmdlet can do a job in certain circumstances, so don’t write it off completely. More importantly, make sure that filtering of objects is done using server-side filters. This will improve script performance significantly.
https://office365itpros.com/2024/09/19/get-exomailbox/
Microsoft’s advice is to use the Get-ExoMailbox cmdlet instead of its older Get-Mailbox counterpart. Generally, this is good advice that you should follow. However, the older cmdlet can do a job in certain circumstances, so don’t write it off completely. More importantly, make sure that filtering of objects is done using server-side filters. This will improve script performance significantly.
https://office365itpros.com/2024/09/19/get-exomailbox/ Read More
How can I unlock iPhone without passcode as I forgot passcode?
Hi everyone,
I’ve unfortunately forgotten the password to my iPhone, and I’m completely locked out. I’ve tried a few attempts but don’t want to keep guessing and risk locking myself out even longer. What are the best methods or tools available to unlock an iPhone without passcode or Face ID in this situation? It could be best without factory reset or losing data.
Any guidance or step-by-step instructions would be greatly appreciated! Thanks in advance for your help!
Hi everyone, I’ve unfortunately forgotten the password to my iPhone, and I’m completely locked out. I’ve tried a few attempts but don’t want to keep guessing and risk locking myself out even longer. What are the best methods or tools available to unlock an iPhone without passcode or Face ID in this situation? It could be best without factory reset or losing data. Any guidance or step-by-step instructions would be greatly appreciated! Thanks in advance for your help! Read More
When is the September TSP Community Call?
Can you share the date and link please?
Thanks
Matt
Can you share the date and link please? ThanksMatt Read More
Email Sent Frequency
Hi all,
I am looking into email frequency.
I have exported data that showcases the email addresses that have had an email sent to them, i need to showcase how many times each email address was emailed by a user.
I have looked into multiple formula options including COUNTIFS and FREQUENCY but all require a reference to measure against, and as i don’t know how many times these email addresses have been used nor do i know what the threshold would be i’m not too sure how to measure this.
Any advice would be great! 🙂
Hi all, I am looking into email frequency. I have exported data that showcases the email addresses that have had an email sent to them, i need to showcase how many times each email address was emailed by a user. I have looked into multiple formula options including COUNTIFS and FREQUENCY but all require a reference to measure against, and as i don’t know how many times these email addresses have been used nor do i know what the threshold would be i’m not too sure how to measure this. Any advice would be great! 🙂 Read More