Month: July 2024
Why are disabled users removed from Org Chart?
Someone brought to my attention that when a user leaves the organisation and the account deleted, the user is removed from the org chart with every other users who directly or indirectly report to that user. I thought why not just disable the user first and give some time to allow updating the manager field for those who directly report to that user. So I did a to disable a user account but was surprised to see that even if the account was only disabled, it still got removed from the org chart.
What’s the reason behind this? An account can be disabled temporarily for any reason and does not necessary mean the user is no longer with the organisation. Removing the disabled user and everyone reports to them from the org chart does not make much sense to me.
Someone brought to my attention that when a user leaves the organisation and the account deleted, the user is removed from the org chart with every other users who directly or indirectly report to that user. I thought why not just disable the user first and give some time to allow updating the manager field for those who directly report to that user. So I did a to disable a user account but was surprised to see that even if the account was only disabled, it still got removed from the org chart. What’s the reason behind this? An account can be disabled temporarily for any reason and does not necessary mean the user is no longer with the organisation. Removing the disabled user and everyone reports to them from the org chart does not make much sense to me. Read More
Smartsheet Conversation functionality in SP Lists
Hi All
I want to build a SP List that has the functionality found in Smartsheet where you are able to have a conversation on a row like it is in smartsheet. SP List has the functionality to post comments on a row, but at this point it’s not possible to upload any attachments. I want to build out the frontend of this List in Power Apps. Is there a way that this could be done to closely resemble the functionality as in smartsheet? Here is a video of this functionality: https://www.youtube.com/watch?v=8K-ZK6b7u8E
Hi All I want to build a SP List that has the functionality found in Smartsheet where you are able to have a conversation on a row like it is in smartsheet. SP List has the functionality to post comments on a row, but at this point it’s not possible to upload any attachments. I want to build out the frontend of this List in Power Apps. Is there a way that this could be done to closely resemble the functionality as in smartsheet? Here is a video of this functionality: https://www.youtube.com/watch?v=8K-ZK6b7u8E Read More
Fundamentals of machine learning
Machine learning is in many ways the intersection of two disciplines – data science and software engineering. The goal of machine learning is to use data to create a predictive model that can be incorporated into a software application or service. To achieve this goal requires collaboration between data scientists who explore and prepare the data before using it to train a machine learning model, and software developers who integrate the models into applications where they’re used to predict new data values (a process known as inferencing).
What is machine learning?
Machine learning has its origins in statistics and mathematical modeling of data. The fundamental idea of machine learning is to use data from past observations to predict unknown outcomes or values. For example:
The proprietor of an ice cream store might use an app that combines historical sales and weather records to predict how many ice creams they’re likely to sell on a given day, based on the weather forecast.A doctor might use clinical data from past patients to run automated tests that predict whether a new patient is at risk from diabetes based on factors like weight, blood glucose level, and other measurements.A researcher in the Antarctic might use past observations automate the identification of different penguin species (such as Adelie, Gentoo, or Chinstrap) based on measurements of a bird’s flippers, bill, and other physical attributes.
Machine learning as a function
Because machine learning is based on mathematics and statistics, it’s common to think about machine learning models in mathematical terms. Fundamentally, a machine learning model is a software application that encapsulates a function to calculate an output value based on one or more input values. The process of defining that function is known as training. After the function has been defined, you can use it to predict new values in a process called inferencing.
Let’s explore the steps involved in training and inferencing.
The training data consists of past observations. In most cases, the observations include the observed attributes or features of the thing being observed, and the known value of the thing you want to train a model to predict (known as the label).
In mathematical terms, you’ll often see the features referred to using the shorthand variable name x, and the label referred to as y. Usually, an observation consists of multiple feature values, so x is actually a vector (an array with multiple values), like this: [x1,x2,x3,…].
To make this clearer, let’s consider the examples described previously:
In the ice cream sales scenario, our goal is to train a model that can predict the number of ice cream sales based on the weather. The weather measurements for the day (temperature, rainfall, windspeed, and so on) would be the features (x), and the number of ice creams sold on each day would be the label (y).In the medical scenario, the goal is to predict whether or not a patient is at risk of diabetes based on their clinical measurements. The patient’s measurements (weight, blood glucose level, and so on) are the features (x), and the likelihood of diabetes (for example, 1 for at risk, 0 for not at risk) is the label (y).In the Antarctic research scenario, we want to predict the species of a penguin based on its physical attributes. The key measurements of the penguin (length of its flippers, width of its bill, and so on) are the features (x), and the species (for example, 0 for Adelie, 1 for Gentoo, or 2 for Chinstrap) is the label (y).
An algorithm is applied to the data to try to determine a relationship between the features and the label, and generalize that relationship as a calculation that can be performed on x to calculate y. The specific algorithm used depends on the kind of predictive problem you’re trying to solve (more about this later), but the basic principle is to try to fit a function to the data, in which the values of the features can be used to calculate the label.
The result of the algorithm is a model that encapsulates the calculation derived by the algorithm as a function – let’s call it f. In mathematical notation:
y = f(x)
Now that the training phase is complete, the trained model can be used for inferencing. The model is essentially a software program that encapsulates the function produced by the training process. You can input a set of feature values, and receive as an output a prediction of the corresponding label. Because the output from the model is a prediction that was calculated by the function, and not an observed value, you’ll often see the output from the function shown as ŷ (which is rather delightfully verbalized as “y-hat”).
Types of machine learning
There are multiple types of machine learning, and you must apply the appropriate type depending on what you’re trying to predict. A breakdown of common types of machine learning is shown in the following diagram.
Supervised machine learning
Supervised machine learning is a general term for machine learning algorithms in which the training data includes both feature values and known label values. Supervised machine learning is used to train models by determining a relationship between the features and labels in past observations, so that unknown labels can be predicted for features in future cases.
Regression
Regression is a form of supervised machine learning in which the label predicted by the model is a numeric value. For example:
The number of ice creams sold on a given day, based on the temperature, rainfall, and windspeed.The selling price of a property based on its size in square feet, the number of bedrooms it contains, and socio-economic metrics for its location.The fuel efficiency (in miles-per-gallon) of a car based on its engine size, weight, width, height, and length.
Classification
Classification is a form of supervised machine learning in which the label represents a categorization, or class. There are two common classification scenarios.
Binary classification
In binary classification, the label determines whether the observed item is (or isn’t) an instance of a specific class. Or put another way, binary classification models predict one of two mutually exclusive outcomes. For example:
Whether a patient is at risk for diabetes based on clinical metrics like weight, age, blood glucose level, and so on.Whether a bank customer will default on a loan based on income, credit history, age, and other factors.Whether a mailing list customer will respond positively to a marketing offer based on demographic attributes and past purchases.
In all of these examples, the model predicts a binary true/false or positive/negative prediction for a single possible class.
Multiclass classification
Multiclass classification extends binary classification to predict a label that represents one of multiple possible classes. For example,
The species of a penguin (Adelie, Gentoo, or Chinstrap) based on its physical measurements.The genre of a movie (comedy, horror, romance, adventure, or science fiction) based on its cast, director, and budget.
In most scenarios that involve a known set of multiple classes, multiclass classification is used to predict mutually exclusive labels. For example, a penguin can’t be both a Gentoo and an Adelie. However, there are also some algorithms that you can use to train multilabel classification models, in which there may be more than one valid label for a single observation. For example, a movie could potentially be categorized as both science fiction and comedy.
Unsupervised machine learning
Unsupervised machine learning involves training models using data that consists only of feature values without any known labels. Unsupervised machine learning algorithms determine relationships between the features of the observations in the training data.
Clustering
The most common form of unsupervised machine learning is clustering. A clustering algorithm identifies similarities between observations based on their features, and groups them into discrete clusters. For example:
Group similar flowers based on their size, number of leaves, and number of petals.Identify groups of similar customers based on demographic attributes and purchasing behavior.
In some ways, clustering is similar to multiclass classification; in that it categorizes observations into discrete groups. The difference is that when using classification, you already know the classes to which the observations in the training data belong; so the algorithm works by determining the relationship between the features and the known classification label. In clustering, there’s no previously known cluster label and the algorithm groups the data observations based purely on similarity of features.
In some cases, clustering is used to determine the set of classes that exist before training a classification model. For example, you might use clustering to segment your customers into groups, and then analyze those groups to identify and categorize different classes of customer (high value – low volume, frequent small purchaser, and so on). You could then use your categorizations to label the observations in your clustering results and use the labeled data to train a classification model that predicts to which customer category a new customer might belong.
Machine learning is in many ways the intersection of two disciplines – data science and software engineering. The goal of machine learning is to use data to create a predictive model that can be incorporated into a software application or service. To achieve this goal requires collaboration between data scientists who explore and prepare the data before using it to train a machine learning model, and software developers who integrate the models into applications where they’re used to predict new data values (a process known as inferencing). What is machine learning? Machine learning has its origins in statistics and mathematical modeling of data. The fundamental idea of machine learning is to use data from past observations to predict unknown outcomes or values. For example:The proprietor of an ice cream store might use an app that combines historical sales and weather records to predict how many ice creams they’re likely to sell on a given day, based on the weather forecast.A doctor might use clinical data from past patients to run automated tests that predict whether a new patient is at risk from diabetes based on factors like weight, blood glucose level, and other measurements.A researcher in the Antarctic might use past observations automate the identification of different penguin species (such as Adelie, Gentoo, or Chinstrap) based on measurements of a bird’s flippers, bill, and other physical attributes. Machine learning as a functionBecause machine learning is based on mathematics and statistics, it’s common to think about machine learning models in mathematical terms. Fundamentally, a machine learning model is a software application that encapsulates a function to calculate an output value based on one or more input values. The process of defining that function is known as training. After the function has been defined, you can use it to predict new values in a process called inferencing.Let’s explore the steps involved in training and inferencing. The training data consists of past observations. In most cases, the observations include the observed attributes or features of the thing being observed, and the known value of the thing you want to train a model to predict (known as the label).In mathematical terms, you’ll often see the features referred to using the shorthand variable name x, and the label referred to as y. Usually, an observation consists of multiple feature values, so x is actually a vector (an array with multiple values), like this: [x1,x2,x3,…].To make this clearer, let’s consider the examples described previously:In the ice cream sales scenario, our goal is to train a model that can predict the number of ice cream sales based on the weather. The weather measurements for the day (temperature, rainfall, windspeed, and so on) would be the features (x), and the number of ice creams sold on each day would be the label (y).In the medical scenario, the goal is to predict whether or not a patient is at risk of diabetes based on their clinical measurements. The patient’s measurements (weight, blood glucose level, and so on) are the features (x), and the likelihood of diabetes (for example, 1 for at risk, 0 for not at risk) is the label (y).In the Antarctic research scenario, we want to predict the species of a penguin based on its physical attributes. The key measurements of the penguin (length of its flippers, width of its bill, and so on) are the features (x), and the species (for example, 0 for Adelie, 1 for Gentoo, or 2 for Chinstrap) is the label (y).An algorithm is applied to the data to try to determine a relationship between the features and the label, and generalize that relationship as a calculation that can be performed on x to calculate y. The specific algorithm used depends on the kind of predictive problem you’re trying to solve (more about this later), but the basic principle is to try to fit a function to the data, in which the values of the features can be used to calculate the label.The result of the algorithm is a model that encapsulates the calculation derived by the algorithm as a function – let’s call it f. In mathematical notation:y = f(x)Now that the training phase is complete, the trained model can be used for inferencing. The model is essentially a software program that encapsulates the function produced by the training process. You can input a set of feature values, and receive as an output a prediction of the corresponding label. Because the output from the model is a prediction that was calculated by the function, and not an observed value, you’ll often see the output from the function shown as ŷ (which is rather delightfully verbalized as “y-hat”). Types of machine learningThere are multiple types of machine learning, and you must apply the appropriate type depending on what you’re trying to predict. A breakdown of common types of machine learning is shown in the following diagram. Supervised machine learningSupervised machine learning is a general term for machine learning algorithms in which the training data includes both feature values and known label values. Supervised machine learning is used to train models by determining a relationship between the features and labels in past observations, so that unknown labels can be predicted for features in future cases.RegressionRegression is a form of supervised machine learning in which the label predicted by the model is a numeric value. For example:The number of ice creams sold on a given day, based on the temperature, rainfall, and windspeed.The selling price of a property based on its size in square feet, the number of bedrooms it contains, and socio-economic metrics for its location.The fuel efficiency (in miles-per-gallon) of a car based on its engine size, weight, width, height, and length.ClassificationClassification is a form of supervised machine learning in which the label represents a categorization, or class. There are two common classification scenarios. Binary classificationIn binary classification, the label determines whether the observed item is (or isn’t) an instance of a specific class. Or put another way, binary classification models predict one of two mutually exclusive outcomes. For example:Whether a patient is at risk for diabetes based on clinical metrics like weight, age, blood glucose level, and so on.Whether a bank customer will default on a loan based on income, credit history, age, and other factors.Whether a mailing list customer will respond positively to a marketing offer based on demographic attributes and past purchases.In all of these examples, the model predicts a binary true/false or positive/negative prediction for a single possible class.Multiclass classificationMulticlass classification extends binary classification to predict a label that represents one of multiple possible classes. For example,The species of a penguin (Adelie, Gentoo, or Chinstrap) based on its physical measurements.The genre of a movie (comedy, horror, romance, adventure, or science fiction) based on its cast, director, and budget.In most scenarios that involve a known set of multiple classes, multiclass classification is used to predict mutually exclusive labels. For example, a penguin can’t be both a Gentoo and an Adelie. However, there are also some algorithms that you can use to train multilabel classification models, in which there may be more than one valid label for a single observation. For example, a movie could potentially be categorized as both science fiction and comedy. Unsupervised machine learningUnsupervised machine learning involves training models using data that consists only of feature values without any known labels. Unsupervised machine learning algorithms determine relationships between the features of the observations in the training data.ClusteringThe most common form of unsupervised machine learning is clustering. A clustering algorithm identifies similarities between observations based on their features, and groups them into discrete clusters. For example:Group similar flowers based on their size, number of leaves, and number of petals.Identify groups of similar customers based on demographic attributes and purchasing behavior.In some ways, clustering is similar to multiclass classification; in that it categorizes observations into discrete groups. The difference is that when using classification, you already know the classes to which the observations in the training data belong; so the algorithm works by determining the relationship between the features and the known classification label. In clustering, there’s no previously known cluster label and the algorithm groups the data observations based purely on similarity of features.In some cases, clustering is used to determine the set of classes that exist before training a classification model. For example, you might use clustering to segment your customers into groups, and then analyze those groups to identify and categorize different classes of customer (high value – low volume, frequent small purchaser, and so on). You could then use your categorizations to label the observations in your clustering results and use the labeled data to train a classification model that predicts to which customer category a new customer might belong. Read More
Using Azure Function to download files from an external site and storage them in the VM
Hi All,
I created a function to download files from an external site and it’s working fine from my local computer. Is it possible to modify the code so it will download the files to a specific folder on the VM after deploying the function? If so, how? Any suggestions is much appreciated.
TIA
Steve
Hi All, I created a function to download files from an external site and it’s working fine from my local computer. Is it possible to modify the code so it will download the files to a specific folder on the VM after deploying the function? If so, how? Any suggestions is much appreciated. TIASteve Read More
Modernized Excel Grid
Our latest update for web users brings you a host of powerful features designed to make your spreadsheet tasks simpler, faster, and more enjoyable. From effortless resizing and streamlined inserts to enhanced navigation and easy cell highlighting, discover how these modern tools can revolutionize your workflows.
Resize rows and columns with ease
Quickly resize rows and columns for better data visibility and presentation. Hover over the border of a row or column header, click and hold the handles, then drag to resize.
Simplified insert options
Our new simplified interface makes adding rows, or columns to your spreadsheet a snap. Just hover over the respective row or column header and then click on the small circles (convert to + on hover). Streamline your workflow and get more done in less time.
Streamlined unhide feature
Show hidden rows or columns with one click and get a complete view of your data instantly. Just hover over the row or column header and then select the small arrows that appear.
Freeze panes for better navigation
Keep important headers or columns visible as you scroll to ensure that important information stays visible, no matter how far you scroll down or across your spreadsheet.
To do so, drag the handles in the top left corner of the headers and drag them to the desired position. To change existing freeze panes, just drag the freeze pane line.
Drag & drop to rearrange elements
Effortlessly rearrange elements in your worksheet with drag and drop, making data organization a breeze.
To try the drag and drop feature, select any row or column, hold and drag when the cursor shows the hand icon, and then drop in any other row or column.
Highlight cells for clarity
Highlight important cells to emphasize critical information and improve readability. To use this feature, just select a row, column, range of cells, or individual cell.
Availability
These features are currently rolling out to all Excel for the web users.
Microsoft Tech Community – Latest Blogs –Read More
Celebrating 2024 Partner of the Year Awards Social Impact Category Winners
Congratulations to the winners and finalists for the 2024 Microsoft Partner of the Year Awards!
The Social Impact category highlights partners accelerating innovation and technology applications that are making a difference for individuals, customers, and communities around the world. We read so many strong entries of partners embracing the possibilities that AI is creating and taking the lead in applying this latest technology to solve societal challenges, creating more inclusive, equitable, and sustainable models of growth.
Together with the team behind the Partner of the Year Awards Social Impact category, we’re thrilled to honor winning partners for the inclusion changemaker, sustainability changemaker and community response awards.
POTYA Community Response winner: Simpson Associates | United Kingdom
The Community Response Partner of the Year Award recognizes a partner organization that is providing innovative and unique services or solutions based on Microsoft technologies, helping solve challenges faced by communities and making a significant social impact during unprecedented times.
Simpson Associates has been a key technical delivery partner for the Tackling Organized Exploitation (TOEX) Program in two ways. First, it implemented an Azure-based TOEX Data Platform, the first data solution to combine force, regional and national data sets from UK law enforcement agencies to create an enhanced intelligence picture of organized exploitation. Second, it delivered enhanced technical capabilities through predictive analytics to strengthen the efficiency and effectiveness of policing.
POTYA Inclusion Changemaker winner: Legal Interact | South Africa
The Inclusion Changemaker Partner of the Year Award recognizes a partner organization that excels at providing innovative and unique services or solutions based on Microsoft technologies that help customers solve challenges of diverse representation, economic access, digital inclusion, and/or accessibility.
Legal Interact’s “My AI Lawyer” bridges justice gaps in South Africa by leveraging Azure Cloud and AI on WhatsApp, offering scalable legal advice and affordable access to law. This innovation marks a significant step towards a more just society by enabling inclusive access to critical legal services.
POTYA Sustainability Changemaker winner: EY | United States
The Sustainability Changemaker Partner of the Year Award recognizes a partner organization that excels at providing innovative and unique services or solutions based on Microsoft technologies that help customers solve challenges of sustainable digital transformation.
Together, EY and Microsoft help customers make better decisions, meet regulatory requirements and generate value at every stage of their environmental, social and governance-based investing (ESG) and sustainability journey. By combining EY’s deep and broad technical expertise with Microsoft’s reputation for cutting-edge technological solutions, EY has helped over 100 clients accelerate their decarbonization journey, creating sustainable value and helping them deliver on their ESG goals.
Congratulations also to our Partner of the Year Award Social Impact category finalists!
POTYA Community Response
POTYA Inclusion Changemaker
POTYA Sustainability Changemaker
BDO Digital
Fellowmind
Kin + Carta
Join us at MCAPS Start for Partners and at Microsoft Ignite (November 18-22, 2024) to celebrate the outstanding achievements of these partners. Learn and find winners and finalists across all categories at the Partner of the Year Awards website.
Microsoft Tech Community – Latest Blogs –Read More
How do I preallocate memory
I get the error message at the end of the first for loop (after code: OutData(ii).hucID = hucID;) that I should consider preallocating memory. How do I do that for the following code:
for ii = 1:length(hucPoly)
hucSub = polyshape(hucPoly(ii).X, hucPoly(ii).Y);
hucID = hucPoly(ii).Name;
OutData(ii).hucID = hucID;
for i = 1:size(inFiles,1)
inShapeOld = shaperead([dataFolder char(inFiles.OldShape(i))]);
inPolyOld = polyshape([inShapeOld.X],[inShapeOld.Y], ‘Simplify’, false);
inShapeNew = shaperead([dataFolder char(inFiles.NewShape(i))]);
inPolyNew = polyshape([inShapeNew.X],[inShapeNew.Y], ‘Simplify’, false);
inPolyNewsub = intersect(inPolyNew, hucSub,’KeepCollinearPoints’,true);
inPolyOldsub = intersect(inPolyOld, hucSub);
[OutData(ii).intsecArea(i).Data, S] = polyIntersect(CoRegErrData, inPolyNewsub, inPolyOldsub);
OutData(ii).intsecArea(i).ID = char(inFiles.NewShape(i));
if ~isnan(S(1).X(1))
shapewrite(S, [dataFolder ‘outShapes_S’ hucID ‘_outInt_’ char(inFiles.NewShape(i))])
end
T = table(OutData(ii).intsecArea(i).Data, ‘VariableNames’, {‘outInt_acres1’ });
writetable(T, [dataFolder ‘outTables_S’ hucID ‘_outInt_’ char(inFiles.NewShape(i)) ‘.txt’])
end
endI get the error message at the end of the first for loop (after code: OutData(ii).hucID = hucID;) that I should consider preallocating memory. How do I do that for the following code:
for ii = 1:length(hucPoly)
hucSub = polyshape(hucPoly(ii).X, hucPoly(ii).Y);
hucID = hucPoly(ii).Name;
OutData(ii).hucID = hucID;
for i = 1:size(inFiles,1)
inShapeOld = shaperead([dataFolder char(inFiles.OldShape(i))]);
inPolyOld = polyshape([inShapeOld.X],[inShapeOld.Y], ‘Simplify’, false);
inShapeNew = shaperead([dataFolder char(inFiles.NewShape(i))]);
inPolyNew = polyshape([inShapeNew.X],[inShapeNew.Y], ‘Simplify’, false);
inPolyNewsub = intersect(inPolyNew, hucSub,’KeepCollinearPoints’,true);
inPolyOldsub = intersect(inPolyOld, hucSub);
[OutData(ii).intsecArea(i).Data, S] = polyIntersect(CoRegErrData, inPolyNewsub, inPolyOldsub);
OutData(ii).intsecArea(i).ID = char(inFiles.NewShape(i));
if ~isnan(S(1).X(1))
shapewrite(S, [dataFolder ‘outShapes_S’ hucID ‘_outInt_’ char(inFiles.NewShape(i))])
end
T = table(OutData(ii).intsecArea(i).Data, ‘VariableNames’, {‘outInt_acres1’ });
writetable(T, [dataFolder ‘outTables_S’ hucID ‘_outInt_’ char(inFiles.NewShape(i)) ‘.txt’])
end
end I get the error message at the end of the first for loop (after code: OutData(ii).hucID = hucID;) that I should consider preallocating memory. How do I do that for the following code:
for ii = 1:length(hucPoly)
hucSub = polyshape(hucPoly(ii).X, hucPoly(ii).Y);
hucID = hucPoly(ii).Name;
OutData(ii).hucID = hucID;
for i = 1:size(inFiles,1)
inShapeOld = shaperead([dataFolder char(inFiles.OldShape(i))]);
inPolyOld = polyshape([inShapeOld.X],[inShapeOld.Y], ‘Simplify’, false);
inShapeNew = shaperead([dataFolder char(inFiles.NewShape(i))]);
inPolyNew = polyshape([inShapeNew.X],[inShapeNew.Y], ‘Simplify’, false);
inPolyNewsub = intersect(inPolyNew, hucSub,’KeepCollinearPoints’,true);
inPolyOldsub = intersect(inPolyOld, hucSub);
[OutData(ii).intsecArea(i).Data, S] = polyIntersect(CoRegErrData, inPolyNewsub, inPolyOldsub);
OutData(ii).intsecArea(i).ID = char(inFiles.NewShape(i));
if ~isnan(S(1).X(1))
shapewrite(S, [dataFolder ‘outShapes_S’ hucID ‘_outInt_’ char(inFiles.NewShape(i))])
end
T = table(OutData(ii).intsecArea(i).Data, ‘VariableNames’, {‘outInt_acres1’ });
writetable(T, [dataFolder ‘outTables_S’ hucID ‘_outInt_’ char(inFiles.NewShape(i)) ‘.txt’])
end
end preallocate memory MATLAB Answers — New Questions
I am using MATLAB 2015b and I dont need #include #include . How to remove these files from code
I am using MATLAB 2015b and I dont need #include <string.h> #include <stddef.h>. How to remove these files from codeI am using MATLAB 2015b and I dont need #include <string.h> #include <stddef.h>. How to remove these files from code I am using MATLAB 2015b and I dont need #include <string.h> #include <stddef.h>. How to remove these files from code #include string.h #include stddef.h MATLAB Answers — New Questions
Flip(grid) in Teams
What gives – we were testing Flip(grid) as a Teams app, but it has now disappeared and is no longer available for installation. A number of our faculty would like to continue to use Flip. Will it be available in the future?
-Michael
What gives – we were testing Flip(grid) as a Teams app, but it has now disappeared and is no longer available for installation. A number of our faculty would like to continue to use Flip. Will it be available in the future? -Michael Read More
Azure sponsorship not showing up
After following the instructions here about the Azure grant:
https://nonprofit.microsoft.com/en-us/offers/azure
I received an email saying it was approved and the subscription shows up in my Azure portal but I’m not seeing the sponsorship/balance in the Azure sponsorships portal:
https://www.microsoftazuresponsorships.com/Balance#
Am I missing something, or does it just take a while until it shows up there?
After following the instructions here about the Azure grant:https://nonprofit.microsoft.com/en-us/offers/azure I received an email saying it was approved and the subscription shows up in my Azure portal but I’m not seeing the sponsorship/balance in the Azure sponsorships portal:https://www.microsoftazuresponsorships.com/Balance# Am I missing something, or does it just take a while until it shows up there? Read More
Azure Event Hub Data Connector Manage Error
When trying to manage the Azure Event Hub Data Connector I am getting this error in the attached screenshot. I can’t go any further.
When trying to manage the Azure Event Hub Data Connector I am getting this error in the attached screenshot. I can’t go any further. Read More
UNIQUE Function not working
Dear Experts,
I have a scenario , as below:-
Column A and Column B has values as below:-
In Cells, A14,B14 , I want the Count of the UNIQUE values of those columns, so A14== 2, B14==3,
I tried to use comb of COUNTIF and UNIQUE, but seems something is broken, or my logic seems not correct.
Secondly, in A15,B15 want to print the unique values( so A15== 0,1 ; B15 == 0,1,2)
I can use remove duplicated from data tab, but I don’t want that as I need to use these cells output(A14/B14) further, without modifying the columns A and B, which this option of remove-duplicate does..
Thanks in Advance,
Br,
Anupam
Dear Experts, I have a scenario , as below:-Column A and Column B has values as below:-In Cells, A14,B14 , I want the Count of the UNIQUE values of those columns, so A14== 2, B14==3,I tried to use comb of COUNTIF and UNIQUE, but seems something is broken, or my logic seems not correct.Secondly, in A15,B15 want to print the unique values( so A15== 0,1 ; B15 == 0,1,2)I can use remove duplicated from data tab, but I don’t want that as I need to use these cells output(A14/B14) further, without modifying the columns A and B, which this option of remove-duplicate does.. Thanks in Advance,Br,Anupam Read More
Did Microsoft start blocking non TLS emails?
I’m starting to get complaints about external emails being rejected with the error: Remote host said: 454 4.7.0 Connection is not TLS encrypted. Recipient organization requires TLS.
This appears to have started on 6/27/2024. I haven’t made any recent changes, so it seems like a change on Microsoft’s end?
I’m starting to get complaints about external emails being rejected with the error: Remote host said: 454 4.7.0 Connection is not TLS encrypted. Recipient organization requires TLS. This appears to have started on 6/27/2024. I haven’t made any recent changes, so it seems like a change on Microsoft’s end? Read More
Contained Database – Migrating to a contained database – dm_db_uncontained_entities
Hi,
i’m currently experimenting with contained databases.
I have started migrating to partially contained database following this guide: migrate-to-a-partially-contained-database.
The query
SELECT SO.name, UE.* FROM sys.dm_db_uncontained_entities AS UE
LEFT JOIN sys.objects AS SO
ON UE.major_id = SO.object_id;
still shows me a few usages of features like “Deferred Name Resolution”, “Database Principal” that could potentially break the contained database boundary.
“Deferred Name Resolution” is due to temp db usage.
Is there any need to worry about that? TempDB is a modified but still usable feature.
Other then that i got sa login mapped to the dbo user.
Now i could have another login mapped to the dbo user i guess, eventually using “sp_changedbowner”, but i guess that would not change the fact that its an uncontained entity.
The query also shows me another sql user that is not mapped to a login, value of SO.name is syspriorities.
Any guidance or comment on this is highly appreciated.
Thank you,
Richard
Hi, i’m currently experimenting with contained databases.I have started migrating to partially contained database following this guide: migrate-to-a-partially-contained-database. The query SELECT SO.name, UE.* FROM sys.dm_db_uncontained_entities AS UE
LEFT JOIN sys.objects AS SO
ON UE.major_id = SO.object_id; still shows me a few usages of features like “Deferred Name Resolution”, “Database Principal” that could potentially break the contained database boundary. “Deferred Name Resolution” is due to temp db usage.Is there any need to worry about that? TempDB is a modified but still usable feature. Other then that i got sa login mapped to the dbo user.Now i could have another login mapped to the dbo user i guess, eventually using “sp_changedbowner”, but i guess that would not change the fact that its an uncontained entity. The query also shows me another sql user that is not mapped to a login, value of SO.name is syspriorities. Any guidance or comment on this is highly appreciated. Thank you, Richard Read More
Defender for Cloud tags disks as not encrypted when FSLogix profiles disk are attached.
We’ve come across an issue where VM disks that are encrypted are flagged as not encrypted whenever a FSLogix profile disk is connected.
is there a possibility of modifying the detection algorithm so fslogix profile disks arent flagging these machines as not encrypted.
After lengthy support ticket with Microsoft it seems there is no realistic method to encrypt/unencrypt fslogix profile disks also.
We’ve come across an issue where VM disks that are encrypted are flagged as not encrypted whenever a FSLogix profile disk is connected.is there a possibility of modifying the detection algorithm so fslogix profile disks arent flagging these machines as not encrypted. After lengthy support ticket with Microsoft it seems there is no realistic method to encrypt/unencrypt fslogix profile disks also. Read More
URGENT: June V2 Title Plan DELAYED
Hello Partners —
Currently, we are experiencing some technical difficulties with uploading the Title Plan. We are fast at work today, to get this resolved immediately.
I hope to be able to upload a Title Plan, end of day.
In the interim, please utilize the TSP Community Call deck from last week, as it will have all course updates, upcoming new releases, and retired courses that were presented. Deck and recording can be found here: June 2024 Training Services Partner Community Call – OneDrive (live.com)
This past Friday we had two new course releases, please find the course URLs below, should you need them, as they were not created yet, on the prior Title Plan that is out.
MS-4004: Empower your workforce with Copilot for Microsoft 365 Use Cases
https://learn.microsoft.com/training/courses/ms-4004
SC-5008: Configure and govern entitlement with Microsoft Entra ID
https://learn.microsoft.com/training/paths/configure-manage-entitlement-microsoft-entra-id/
We appreciate your patience,
Thank you!
Hello Partners —
Currently, we are experiencing some technical difficulties with uploading the Title Plan. We are fast at work today, to get this resolved immediately.
I hope to be able to upload a Title Plan, end of day.
In the interim, please utilize the TSP Community Call deck from last week, as it will have all course updates, upcoming new releases, and retired courses that were presented. Deck and recording can be found here: June 2024 Training Services Partner Community Call – OneDrive (live.com)
This past Friday we had two new course releases, please find the course URLs below, should you need them, as they were not created yet, on the prior Title Plan that is out.
MS-4004: Empower your workforce with Copilot for Microsoft 365 Use Cases
https://learn.microsoft.com/training/courses/ms-4004
SC-5008: Configure and govern entitlement with Microsoft Entra ID
https://learn.microsoft.com/training/paths/configure-manage-entitlement-microsoft-entra-id/
We appreciate your patience,
Thank you! Read More
Issues with Microsoft Teams’ Milestone App – Not Functioning Properly
Hi everyone,
I uploaded the Milestones app to Microsoft Teams yesterday, but it appears to not be working as expected. When I try to use the app, I encounter the following issue:
Description of the IssueThe app does not load properly,I can’t create work items or projectButtons are not working
2. Steps I have taken to troubleshoot so far:
I tried reinstalling the app at least 6 times, restarting Teams, or checking for updates. I believe I downloaded the latest release.When trying to load it into Power App and see what happens there, I realized I see the message
3. System Information:
Microsoft Teams Version: 24152.412.2958.9166.Operating System: Windows 10 Pro
I would greatly appreciate any assistance or suggestions on how to resolve this issue.
Thank you!
Franck O.
Hi everyone,I uploaded the Milestones app to Microsoft Teams yesterday, but it appears to not be working as expected. When I try to use the app, I encounter the following issue: Description of the IssueThe app does not load properly,I can’t create work items or projectButtons are not working 2. Steps I have taken to troubleshoot so far:I tried reinstalling the app at least 6 times, restarting Teams, or checking for updates. I believe I downloaded the latest release.When trying to load it into Power App and see what happens there, I realized I see the message 3. System Information:Microsoft Teams Version: 24152.412.2958.9166.Operating System: Windows 10 ProI would greatly appreciate any assistance or suggestions on how to resolve this issue.Thank you!Franck O. Read More
Set custom sound notifications in Microsoft Teams
Hello Microsoft 365 Insiders,
New in Microsoft Teams! You can now set custom sound notifications to help you stay focused and prioritize tasks. Customize your alert sounds for different notifications or mute them when you’re busy. Learn how in our latest blog post: Set custom sound notifications in Microsoft Teams
Thanks!
Perry Sjogren
Microsoft 365 Insider Community Manager
Become a Microsoft 365 Insider and gain exclusive access to new features and help shape the future of Microsoft 365. Join Now: Windows | Mac | iOS | Android
Hello Microsoft 365 Insiders,
New in Microsoft Teams! You can now set custom sound notifications to help you stay focused and prioritize tasks. Customize your alert sounds for different notifications or mute them when you’re busy. Learn how in our latest blog post: Set custom sound notifications in Microsoft Teams
Thanks!
Perry Sjogren
Microsoft 365 Insider Community Manager
Become a Microsoft 365 Insider and gain exclusive access to new features and help shape the future of Microsoft 365. Join Now: Windows | Mac | iOS | Android Read More
Partner Case Study Series | Cloud of Things case study
Cloud of Things accelerates the creation of smart connected products
Cloud of Things, an IoT and innovation company that creates connected field service solutions, has been a Microsoft partner for two years. Based in Tel Aviv, Israel, with an office in Newton, Massachusetts, Cloud of Things works globally with companies to make their products and services smarter and more profitable. DeviceTone IoT Suite, the company’s ready-to-run IoT solution available in the Microsoft Azure Marketplace, makes it quick to create smart connected products. DeviceTone IoT Suite offers customers a multitude of features, including open APIs and customizable device management dashboards. It runs on any chip, supports any communication protocol, and connects to any cloud.
Hortica, located in Tirat Yehuda, Israel, cultivates plant-made pharmaceuticals. Hortica’s research and development team was focused on smart irrigation and cultivation, and it wanted to rapidly launch its smart cultivation unit, a type of indoor greenhouse. Hortica turned to Cloud of Things and its partner AES, whose minIoT technology enables seamless sensor-to-cloud IoT connectivity for devices.
Continue reading here
**Explore all case studies or submit your own**
Microsoft Tech Community – Latest Blogs –Read More
Assigning correct symbols and colors to group scatterplot
Dear all, could you help me please on a group scatter plot?
I have three regions (MSD, DPG and WFS) and four seasons (Winter, Spring, Summer and Autumn). I chose four colors to represent the seasons, and 3 symbols to represent the regions, however, the function doesn’t understand this way. The symbols are correct to each region, but the colors are inconsistent, I think it is because there are 3 regions, but 4 seasons. The thing is, I need always the same color to the same season at each region/symbol, but I could not figure it out yet. Please, could you help me? The data is attached and the code below. Thank you very much in advance!
load gscat.mat
gscatter(x,y,g,’rkgb’,’o*h’,6,’on’,’Hind’,’Twin’)
legend(‘Location’,’northeastoutside’)Dear all, could you help me please on a group scatter plot?
I have three regions (MSD, DPG and WFS) and four seasons (Winter, Spring, Summer and Autumn). I chose four colors to represent the seasons, and 3 symbols to represent the regions, however, the function doesn’t understand this way. The symbols are correct to each region, but the colors are inconsistent, I think it is because there are 3 regions, but 4 seasons. The thing is, I need always the same color to the same season at each region/symbol, but I could not figure it out yet. Please, could you help me? The data is attached and the code below. Thank you very much in advance!
load gscat.mat
gscatter(x,y,g,’rkgb’,’o*h’,6,’on’,’Hind’,’Twin’)
legend(‘Location’,’northeastoutside’) Dear all, could you help me please on a group scatter plot?
I have three regions (MSD, DPG and WFS) and four seasons (Winter, Spring, Summer and Autumn). I chose four colors to represent the seasons, and 3 symbols to represent the regions, however, the function doesn’t understand this way. The symbols are correct to each region, but the colors are inconsistent, I think it is because there are 3 regions, but 4 seasons. The thing is, I need always the same color to the same season at each region/symbol, but I could not figure it out yet. Please, could you help me? The data is attached and the code below. Thank you very much in advance!
load gscat.mat
gscatter(x,y,g,’rkgb’,’o*h’,6,’on’,’Hind’,’Twin’)
legend(‘Location’,’northeastoutside’) gscatter, scatter plot MATLAB Answers — New Questions