Month: June 2024
Boost engagement with Copilot in Forms
We have been continuously enhancing Copilot’s capabilities over the past few months, focusing on everything from form creation to distribution, to make it your ultimate form creation assistant. This June, we enabled more capabilities for distributing forms, helping you boost audience engagement and increase response rates. Let’s explore the new capabilities together!
Rewrite the invitation message with Copilot
The invitation message is the first thing responders see when they receive a form. Crafting a compelling message is key to grabbing their attention and prompting a quick response. When your form is ready to go, Copilot will help you rewrite the default message, adding details like the form’s topic, estimated completion time, and due date.
Rewrite the invitation message with CopilotRespondents will receive an email invitation in Outlook or a Teams message with the customized message. They can begin filling out the form by clicking “Start now”.
Customized invitation message in Outlook
Customized invitation message in Teams
Follow up with non-responders
If you send out the form and don’t receive enough responses after some time, Copilot can help you draft reminder messages to prompt respondents to reply. It offers several options, allowing you to choose your favorite and send it with just one click.
Draft a reminder with Copilot
Respondents will receive a nudge email with the personalized message in their inbox. With just one click, they can start filling out the form.
Nudge email in Outlook
Please note that a Copilot for Microsoft 365 license is required to access Copilot in Forms. Discover more about Copilot for Microsoft 365 here.
Microsoft Tech Community – Latest Blogs –Read More
How to get loan value for fixed time span and payment
Hi everyone,
I am wondering, how I can get the remaining value of a load or annuity after a fixed time span with a fixed rate.
Say e.g. I have a loan of $100.000, an annual interest rate of 11% and a monthly payment fo $1.500. What amount of money is left after this time?
All functions I have found (e.g. amortize, annurate, …) either provide as output
a timespan to completely pay the loan or
a rate that need to be payed
Many functions even provide an additional input "FutureValue", but I would need that as an output of my function. Did I overlook something? Or does that function simply not exist?
Thanks!Hi everyone,
I am wondering, how I can get the remaining value of a load or annuity after a fixed time span with a fixed rate.
Say e.g. I have a loan of $100.000, an annual interest rate of 11% and a monthly payment fo $1.500. What amount of money is left after this time?
All functions I have found (e.g. amortize, annurate, …) either provide as output
a timespan to completely pay the loan or
a rate that need to be payed
Many functions even provide an additional input "FutureValue", but I would need that as an output of my function. Did I overlook something? Or does that function simply not exist?
Thanks! Hi everyone,
I am wondering, how I can get the remaining value of a load or annuity after a fixed time span with a fixed rate.
Say e.g. I have a loan of $100.000, an annual interest rate of 11% and a monthly payment fo $1.500. What amount of money is left after this time?
All functions I have found (e.g. amortize, annurate, …) either provide as output
a timespan to completely pay the loan or
a rate that need to be payed
Many functions even provide an additional input "FutureValue", but I would need that as an output of my function. Did I overlook something? Or does that function simply not exist?
Thanks! amortize, loan, finance MATLAB Answers — New Questions
Saving a Structured Array (containing plot parameters) to a mat file
Hi, Im trying to save plot data by using a structured arra
ax=app.UIAxes;
ax.Children;
h1 = findall(ax, ‘type’, ‘line’); % Line objects
nlines=numel(h1);
Assign the desired plot parameters to a struct "S"
for i=1:nlines
thisLine=h1(i);
S(i).Xdata=thisLine.XData; S(i).Ydata=thisLine.YData;
S(i).Colour=thisLine.Color;
S(i).LineStyle=thisLine.LineStyle;
S(i).LineWidth=thisLine.LineWidth;
S(i).DName=thisLine.DisplayName;
end
Save to a .MAT file
try
[file,folder]=uiputfile({‘*.mat’,’Matlab Files’},’Save Data’,app.startfolder);
catch
[file,folder]=uiputfile({‘*.mat’,’Matlab Files’},’Save Data’,’C:’);
end
app.startfolder=folder;
savepath=fullfile(folder,file);
save(savepath,"-struct",’S’)
But I keep getting this error:
Error using save
The argument to -STRUCT must be the name of a scalar structure variable.
I have checked the class of S and the fieldnames contained within it:
fields = fieldnames(S)
class(S)
fields =
6×1 cell array
{‘Xdata’ }
{‘Ydata’ }
{‘Colour’ }
{‘LineStyle’}
{‘LineWidth’}
{‘DName’ }
ans =
‘struct’
Thanks for any helpHi, Im trying to save plot data by using a structured arra
ax=app.UIAxes;
ax.Children;
h1 = findall(ax, ‘type’, ‘line’); % Line objects
nlines=numel(h1);
Assign the desired plot parameters to a struct "S"
for i=1:nlines
thisLine=h1(i);
S(i).Xdata=thisLine.XData; S(i).Ydata=thisLine.YData;
S(i).Colour=thisLine.Color;
S(i).LineStyle=thisLine.LineStyle;
S(i).LineWidth=thisLine.LineWidth;
S(i).DName=thisLine.DisplayName;
end
Save to a .MAT file
try
[file,folder]=uiputfile({‘*.mat’,’Matlab Files’},’Save Data’,app.startfolder);
catch
[file,folder]=uiputfile({‘*.mat’,’Matlab Files’},’Save Data’,’C:’);
end
app.startfolder=folder;
savepath=fullfile(folder,file);
save(savepath,"-struct",’S’)
But I keep getting this error:
Error using save
The argument to -STRUCT must be the name of a scalar structure variable.
I have checked the class of S and the fieldnames contained within it:
fields = fieldnames(S)
class(S)
fields =
6×1 cell array
{‘Xdata’ }
{‘Ydata’ }
{‘Colour’ }
{‘LineStyle’}
{‘LineWidth’}
{‘DName’ }
ans =
‘struct’
Thanks for any help Hi, Im trying to save plot data by using a structured arra
ax=app.UIAxes;
ax.Children;
h1 = findall(ax, ‘type’, ‘line’); % Line objects
nlines=numel(h1);
Assign the desired plot parameters to a struct "S"
for i=1:nlines
thisLine=h1(i);
S(i).Xdata=thisLine.XData; S(i).Ydata=thisLine.YData;
S(i).Colour=thisLine.Color;
S(i).LineStyle=thisLine.LineStyle;
S(i).LineWidth=thisLine.LineWidth;
S(i).DName=thisLine.DisplayName;
end
Save to a .MAT file
try
[file,folder]=uiputfile({‘*.mat’,’Matlab Files’},’Save Data’,app.startfolder);
catch
[file,folder]=uiputfile({‘*.mat’,’Matlab Files’},’Save Data’,’C:’);
end
app.startfolder=folder;
savepath=fullfile(folder,file);
save(savepath,"-struct",’S’)
But I keep getting this error:
Error using save
The argument to -STRUCT must be the name of a scalar structure variable.
I have checked the class of S and the fieldnames contained within it:
fields = fieldnames(S)
class(S)
fields =
6×1 cell array
{‘Xdata’ }
{‘Ydata’ }
{‘Colour’ }
{‘LineStyle’}
{‘LineWidth’}
{‘DName’ }
ans =
‘struct’
Thanks for any help struct, mat, save MATLAB Answers — New Questions
Teams Owners/Members from different Domains
Our team is made up of different people with different email addresses off of different domains. We have some members who we have added with different domains who we have been able to elevate from Guest to Owner/Member but some of the others we have not. I have checked the external settings in the admin panel and have access granted to all external domains. I have even tried specifically listing the domains but that also did not work. An example of the domains:
theamericanrealty.com (primary domain)
areuclasses.com (different domain but we are allowed to elevate to owner/member)
arpartners.us (different domain that will ONLY allow to be set as GUEST)
theamericanmortgagepartners.com (different domain but we are allowed to elevate to owner/member)
Any suggestions would be greatly appreciated.
I am using the online and desktop versions of teams and all of our domains and Microsoft accounts are handled through GoDaddy.
Our team is made up of different people with different email addresses off of different domains. We have some members who we have added with different domains who we have been able to elevate from Guest to Owner/Member but some of the others we have not. I have checked the external settings in the admin panel and have access granted to all external domains. I have even tried specifically listing the domains but that also did not work. An example of the domains: theamericanrealty.com (primary domain) areuclasses.com (different domain but we are allowed to elevate to owner/member)arpartners.us (different domain that will ONLY allow to be set as GUEST)theamericanmortgagepartners.com (different domain but we are allowed to elevate to owner/member) Any suggestions would be greatly appreciated. I am using the online and desktop versions of teams and all of our domains and Microsoft accounts are handled through GoDaddy. Read More
What do I need to hire in the MS Purview so that I also receive this confidentiality name Alex Revie
What do I need to hire in MS Purview to help this confidentiality name Alex Reviewit – Confidential: This content is proprietary information intended for internal users only. This content can be modified but cannot be copied and printed. Receive
What do I need to hire in MS Purview to help this confidentiality name Alex Reviewit – Confidential: This content is proprietary information intended for internal users only. This content can be modified but cannot be copied and printed. Receive Read More
SQLServer connection problem
Hi,
I made a program in c# .NET8.0 using EntityFrameworkCore to connect to an SQL Server. Everything work fines as long as I run the program from Visual Studio. Once compile and install on the computer (same computer I develop the program in VS) it won’t connect to the server.
I have added this code on a button to test the connection:
try
{
string? str = dbCtxt.Database.ProviderName;
bool cnx = dbCtxt.Database.CanConnect();
MessageBox.Show(“Provider: ” + str + “rnCan connect? ” + cnx, this.Title, MessageBoxButton.OK, MessageBoxImage.Error);
dbCtxt.Database.OpenConnection();
MessageBox.Show(“Connection opened”, this.Title, MessageBoxButton.OK, MessageBoxImage.Error);
dbCtxt.Database.CloseConnection();
}
catch (Microsoft.Data.SqlClient.SqlException ex)
{
MessageBox.Show($”Microsoft.Data.SqlClient.SqlException occurred: {ex.Message + “rnrn” + ex.StackTrace}”);
}
catch (DbUpdateException ex)
{
// Handle specific database update exception
MessageBox.Show($”DbUpdateException occurred: {ex.Message}”);
}
catch (DbException ex)
{
// Handle any other database exception
MessageBox.Show($”DbException occurred: {ex.Message}”);
}
catch (Exception ex)
{
// Catch any other exceptions
MessageBox.Show($”Exception occurred: {ex.Message + “rnrn” + ex.StackTrace}”);
tbError.Text = ex.StackTrace;
}
finally
{
//Here just to make sure it passes through this point…
MessageBox.Show(“Finally”, this.Title, MessageBoxButton.OK, MessageBoxImage.Error);
}
and I get this error message.
(Stack trace)
at Microsoft.Data.SqlClient.SqlConnection..ctor(String connectionString)
at Microsoft.EntityFrameworkCore.SqlServer.Storage.Internal.SqlServerConnection.CreateDbConnection()
at Microsoft.EntityFrameworkCore.Storage.RelationalConnection.get_DbConnection()
at Microsoft.EntityFrameworkCore.Storage.RelationalConnection.Open(Boolean errorsExpected)
at Microsoft.EntityFrameworkCore.RelationalDatabaseFacadeExtensions.<>c.<OpenConnection>b__22_0(DatabaseFacade database)
at Microsoft.EntityFrameworkCore.ExecutionStrategyExtensions.<>c__DisplayClass12_0`2.<Execute>b__0(DbContext _, TState s)
at Microsoft.EntityFrameworkCore.SqlServer.Storage.Internal.SqlServerExecutionStrategy.Execute[TState,TResult](TState state, Func`3 operation, Func`3 verifySucceeded)
at Microsoft.EntityFrameworkCore.ExecutionStrategyExtensions.Execute[TState,TResult](IExecutionStrategy strategy, TState state, Func`2 operation, Func`2 verifySucceeded)
at Microsoft.EntityFrameworkCore.RelationalDatabaseFacadeExtensions.OpenConnection(DatabaseFacade databaseFacade)
at ****.frmMainMenu.btnFicheEmpAnnuel_Click(Object sender, RoutedEventArgs e) in C:Users….frmMainMenu.xaml.cs:line 99
I have tried multiple things, like changing the TargetPlatform from AnyCPU to x64, changing the Target OS Version, installing/deinstalling NuGET Microsoft.Data.SQLClient 5.2.1 … nothing works.
Anyone got a similar problem and solve it?
Regards
Hi,I made a program in c# .NET8.0 using EntityFrameworkCore to connect to an SQL Server. Everything work fines as long as I run the program from Visual Studio. Once compile and install on the computer (same computer I develop the program in VS) it won’t connect to the server.I have added this code on a button to test the connection: try
{
string? str = dbCtxt.Database.ProviderName;
bool cnx = dbCtxt.Database.CanConnect();
MessageBox.Show(“Provider: ” + str + “rnCan connect? ” + cnx, this.Title, MessageBoxButton.OK, MessageBoxImage.Error);
dbCtxt.Database.OpenConnection();
MessageBox.Show(“Connection opened”, this.Title, MessageBoxButton.OK, MessageBoxImage.Error);
dbCtxt.Database.CloseConnection();
}
catch (Microsoft.Data.SqlClient.SqlException ex)
{
MessageBox.Show($”Microsoft.Data.SqlClient.SqlException occurred: {ex.Message + “rnrn” + ex.StackTrace}”);
}
catch (DbUpdateException ex)
{
// Handle specific database update exception
MessageBox.Show($”DbUpdateException occurred: {ex.Message}”);
}
catch (DbException ex)
{
// Handle any other database exception
MessageBox.Show($”DbException occurred: {ex.Message}”);
}
catch (Exception ex)
{
// Catch any other exceptions
MessageBox.Show($”Exception occurred: {ex.Message + “rnrn” + ex.StackTrace}”);
tbError.Text = ex.StackTrace;
}
finally
{
//Here just to make sure it passes through this point…
MessageBox.Show(“Finally”, this.Title, MessageBoxButton.OK, MessageBoxImage.Error);
} and I get this error message.(Stack trace)at Microsoft.Data.SqlClient.SqlConnection..ctor(String connectionString)at Microsoft.EntityFrameworkCore.SqlServer.Storage.Internal.SqlServerConnection.CreateDbConnection()at Microsoft.EntityFrameworkCore.Storage.RelationalConnection.get_DbConnection()at Microsoft.EntityFrameworkCore.Storage.RelationalConnection.Open(Boolean errorsExpected)at Microsoft.EntityFrameworkCore.RelationalDatabaseFacadeExtensions.<>c.<OpenConnection>b__22_0(DatabaseFacade database)at Microsoft.EntityFrameworkCore.ExecutionStrategyExtensions.<>c__DisplayClass12_0`2.<Execute>b__0(DbContext _, TState s)at Microsoft.EntityFrameworkCore.SqlServer.Storage.Internal.SqlServerExecutionStrategy.Execute[TState,TResult](TState state, Func`3 operation, Func`3 verifySucceeded)at Microsoft.EntityFrameworkCore.ExecutionStrategyExtensions.Execute[TState,TResult](IExecutionStrategy strategy, TState state, Func`2 operation, Func`2 verifySucceeded)at Microsoft.EntityFrameworkCore.RelationalDatabaseFacadeExtensions.OpenConnection(DatabaseFacade databaseFacade)at ****.frmMainMenu.btnFicheEmpAnnuel_Click(Object sender, RoutedEventArgs e) in C:Users….frmMainMenu.xaml.cs:line 99 I have tried multiple things, like changing the TargetPlatform from AnyCPU to x64, changing the Target OS Version, installing/deinstalling NuGET Microsoft.Data.SQLClient 5.2.1 … nothing works. Anyone got a similar problem and solve it?Regards Read More
What do I need to hire in MS Purview to make this confidentiality name Confidential View Only: This
What do I need to hire in MS Purview to make this confidentiality name Confidential View Only: This content is proprietary information intended for internal users only. This content cannot be modified. Receive
What do I need to hire in MS Purview to make this confidentiality name Confidential View Only: This content is proprietary information intended for internal users only. This content cannot be modified. Receive Read More
Two Taskbars resolution issue
I am getting two taskbars showing up on my monitor, but the screen edge stops before the edge of my screen, im also getting two mice cursors.
I am getting two taskbars showing up on my monitor, but the screen edge stops before the edge of my screen, im also getting two mice cursors. Read More
Soon no profile pictures in SPO User Profile Service anymore?
Anyone seen this yet?
We have Intranet solutions that use the LocalPeopleResults result source for search in combination with the classic user profile pictures hosted on https://[tenant]-my.sharepoint.com/User%20Photos.
Couldn’t find anything regarding this in the M365 Admin Center message feed, unfortunately.
Does anybody know how to handle this in the future?
Anyone seen this yet?We have Intranet solutions that use the LocalPeopleResults result source for search in combination with the classic user profile pictures hosted on https://[tenant]-my.sharepoint.com/User%20Photos.Couldn’t find anything regarding this in the M365 Admin Center message feed, unfortunately.Does anybody know how to handle this in the future? Read More
Copilot for Microsoft 365 – Restricting SharePoint Search
How can I restrict Copilot from using SharePoint search? Is there an option to disable?
How can I restrict Copilot from using SharePoint search? Is there an option to disable? Read More
request help adding an Excel condition
There are formulas in cells B, C, and D. I want the answer to be a blank when both B and C are blank. Currently the answer is #DIV/0!.
=IF(C7>0,D7/C7,D7/B7)
There are formulas in cells B, C, and D. I want the answer to be a blank when both B and C are blank. Currently the answer is #DIV/0!. =IF(C7>0,D7/C7,D7/B7) Read More
Help with best practices for how to protect formulas on table and still expand with new records?
I have several tables, one on each worksheet, that need to be able to expand whenever a user types in a new record (formulas/drop-downs copied to new records).
Apparently, Excel doesn’t allow protecting the worksheet while also allowing the table to expand as needed. Can anyone suggest the best way to protect the formulas in certain cells from being accidentally overwritten by users when they enter a new record? Again, the table must be able to expand. The only thing I can think of would be to use a set number of records on each table which already contain the cells needing protection, but that comes with its own issues. Any help is appreciated.
I’m using Excel 365. Developing the workbook in the desktop app and then posting to the Internet on a shared drive for users to access and enter data. I can’t use VBA or Macros for security reasons.
I have several tables, one on each worksheet, that need to be able to expand whenever a user types in a new record (formulas/drop-downs copied to new records). Apparently, Excel doesn’t allow protecting the worksheet while also allowing the table to expand as needed. Can anyone suggest the best way to protect the formulas in certain cells from being accidentally overwritten by users when they enter a new record? Again, the table must be able to expand. The only thing I can think of would be to use a set number of records on each table which already contain the cells needing protection, but that comes with its own issues. Any help is appreciated. I’m using Excel 365. Developing the workbook in the desktop app and then posting to the Internet on a shared drive for users to access and enter data. I can’t use VBA or Macros for security reasons. Read More
How to do a cross-multiplication by group in a table
Hi. I am wondering how to do a cross-multiplication (rule of three) by group in a table. More specifically I have an initial table in which I want to fill the NaNs by doing a cross-multiplication between c and d. For example the first NaN is (10*40) / 1 == 400. This need to be applied for unique combinations of a and b.
% Initial table
a = [1, 1, 1, 1, 1, 1, 2, 2]’;
b = [45,45,12, 17, 56, 56, 45, 45]’;
c = [1, 10, 3, 9, 2, 10, 1, 10]’;
d = [40, NaN, 1, 9, 20, NaN, 40, NaN]’;
t = table(a, b, c, d)
% Desired end result
e = [1, 1, 1, 1, 1, 1, 2, 2]’;
f = [45,45,12, 17, 56, 56, 45, 45]’;
g = [1, 10, 3, 9, 2, 10, 1, 10]’;
h = [40, 400, 1, 9, 20, 100, 40, 400]’;
result = table(e, f, g, h)Hi. I am wondering how to do a cross-multiplication (rule of three) by group in a table. More specifically I have an initial table in which I want to fill the NaNs by doing a cross-multiplication between c and d. For example the first NaN is (10*40) / 1 == 400. This need to be applied for unique combinations of a and b.
% Initial table
a = [1, 1, 1, 1, 1, 1, 2, 2]’;
b = [45,45,12, 17, 56, 56, 45, 45]’;
c = [1, 10, 3, 9, 2, 10, 1, 10]’;
d = [40, NaN, 1, 9, 20, NaN, 40, NaN]’;
t = table(a, b, c, d)
% Desired end result
e = [1, 1, 1, 1, 1, 1, 2, 2]’;
f = [45,45,12, 17, 56, 56, 45, 45]’;
g = [1, 10, 3, 9, 2, 10, 1, 10]’;
h = [40, 400, 1, 9, 20, 100, 40, 400]’;
result = table(e, f, g, h) Hi. I am wondering how to do a cross-multiplication (rule of three) by group in a table. More specifically I have an initial table in which I want to fill the NaNs by doing a cross-multiplication between c and d. For example the first NaN is (10*40) / 1 == 400. This need to be applied for unique combinations of a and b.
% Initial table
a = [1, 1, 1, 1, 1, 1, 2, 2]’;
b = [45,45,12, 17, 56, 56, 45, 45]’;
c = [1, 10, 3, 9, 2, 10, 1, 10]’;
d = [40, NaN, 1, 9, 20, NaN, 40, NaN]’;
t = table(a, b, c, d)
% Desired end result
e = [1, 1, 1, 1, 1, 1, 2, 2]’;
f = [45,45,12, 17, 56, 56, 45, 45]’;
g = [1, 10, 3, 9, 2, 10, 1, 10]’;
h = [40, 400, 1, 9, 20, 100, 40, 400]’;
result = table(e, f, g, h) arithmetic MATLAB Answers — New Questions
Passing form data that is defined in combobox defaultselecteditems
I have created a form that is connected to a Sharepoint list called: “Win”
The Sharepoint list holds a.o. a multiselect column called ‘Solution Category’
I have a multiselect combobox (cmbSolCat_1) that is part of this form.
– The combobox items list gets its data from an single column excel table called SolutionCat
– The headername of the table is called ‘Customer Solution’
The defaultselecteditems property of this combobox is defined as: ThisItem.’Solution Category’
– The datacard Update property is: ForAll(cmbSolCat_1.SelectedItems, {Value:’Customer Solution’})
All of the above works well if I select some of the items in the multiselect combobox.
If I would edit an existing entry, with multiple items selected, it would show me those items. If I now would submit my form with no changes, it will not pass the items that were listed from the defaultselected property. Instead, it will blank out all everything in that cell of the sharepoint list.
Appreciate your insight on how to pass on defaultselecteditems in a multiselect combobox.
I have created a form that is connected to a Sharepoint list called: “Win”The Sharepoint list holds a.o. a multiselect column called ‘Solution Category’ I have a multiselect combobox (cmbSolCat_1) that is part of this form.- The combobox items list gets its data from an single column excel table called SolutionCat- The headername of the table is called ‘Customer Solution’The defaultselecteditems property of this combobox is defined as: ThisItem.’Solution Category’- The datacard Update property is: ForAll(cmbSolCat_1.SelectedItems, {Value:’Customer Solution’}) All of the above works well if I select some of the items in the multiselect combobox. If I would edit an existing entry, with multiple items selected, it would show me those items. If I now would submit my form with no changes, it will not pass the items that were listed from the defaultselected property. Instead, it will blank out all everything in that cell of the sharepoint list. Appreciate your insight on how to pass on defaultselecteditems in a multiselect combobox. Read More
Shared Excel File for Individual Recording
Hi, I have a shared Excel file (Mileage Claim Form) stored in SharePoint. Is there a way for individual employees to complete the form on a monthly basis but it remain individual to them – as in no one else can see their claim?
Currently, we are having to download the file & save to our own Onedrive, complete then email it.
I was hoping there was a more simple step as it is being stored in SharePoint
Hi, I have a shared Excel file (Mileage Claim Form) stored in SharePoint. Is there a way for individual employees to complete the form on a monthly basis but it remain individual to them – as in no one else can see their claim?Currently, we are having to download the file & save to our own Onedrive, complete then email it.I was hoping there was a more simple step as it is being stored in SharePoint Read More
XML to CSV: how to remove CRLF from XML source field?
I’m new to Azure Data Factory. I made an Azure Pipeline with a Data Flow. I wanted to convert an XML file to a CSV file and I used this tutorial: https://www.youtube.com/watch?v=ltR5xof6wq8
In the XML source file there are embedded carriage returns in the <description> tag which appear in the resulting CSV file. This makes the output CSV file invalid since only one record should appear per line.
The XML file was created by copying the data from https://learn.microsoft.com/en-us/previous-versions/windows/desktop/ms762271(v=vs.85), pasting it into a plain XML file, and uploading the file to Azure storage.
How do I get rid of the CRLF in the Description field? I don’t even know where to start looking since I’m pretty new to Azure Data Factory. Maybe I’m asking the wrong question. In your world, would a valid XML file possibly have embedded CRLF in some of its fields? In my world we get all kinds of garbage data from the customer that they don’t know how to fix.
NOTE: I must use Azure Data Factory for this solution, I cannot use another Azure service or outside service. It is not feasible to manually edit the input file or output file as in production, the files could be quite large.
Thank you.
I’m new to Azure Data Factory. I made an Azure Pipeline with a Data Flow. I wanted to convert an XML file to a CSV file and I used this tutorial: https://www.youtube.com/watch?v=ltR5xof6wq8 In the XML source file there are embedded carriage returns in the <description> tag which appear in the resulting CSV file. This makes the output CSV file invalid since only one record should appear per line. The XML file was created by copying the data from https://learn.microsoft.com/en-us/previous-versions/windows/desktop/ms762271(v=vs.85), pasting it into a plain XML file, and uploading the file to Azure storage. How do I get rid of the CRLF in the Description field? I don’t even know where to start looking since I’m pretty new to Azure Data Factory. Maybe I’m asking the wrong question. In your world, would a valid XML file possibly have embedded CRLF in some of its fields? In my world we get all kinds of garbage data from the customer that they don’t know how to fix.NOTE: I must use Azure Data Factory for this solution, I cannot use another Azure service or outside service. It is not feasible to manually edit the input file or output file as in production, the files could be quite large. Thank you. Read More
Copilot for Microsoft 365 semantic index manipulation
Hey there!
I am curious about how Copilot M365 searches within organizations at the moment?
and How can we manipulate the semantic index at the Grounding stage or use tagging the documents to get the search results of our choices?
Regards
Hey there!I am curious about how Copilot M365 searches within organizations at the moment? and How can we manipulate the semantic index at the Grounding stage or use tagging the documents to get the search results of our choices?Regards Read More
Ghost bookings preventing from creating a real ones
Hello having issue with my bookings. Nobody can book a time with me even though I have nothing for several hours that day.
Unable to book
Several hours of free time in my calendar
In booking “calendar and availability” I can see some ghost “busy” bookings, any ideas how to get rid of them so clients can book a time with me?
Thank You
Hello having issue with my bookings. Nobody can book a time with me even though I have nothing for several hours that day. Unable to bookSeveral hours of free time in my calendarIn booking “calendar and availability” I can see some ghost “busy” bookings, any ideas how to get rid of them so clients can book a time with me?Thank You Read More
Excel workbook
I am looking to create a workbook with 5 tabs. I need 4 of the tabs to be accessible to specific people only and take the information they enter and update the master tab that will also be accessible to specific people only.
Any insight/help would be greatly appreciated
Thank you
I am looking to create a workbook with 5 tabs. I need 4 of the tabs to be accessible to specific people only and take the information they enter and update the master tab that will also be accessible to specific people only. Any insight/help would be greatly appreciated Thank you@AmyG57 Read More
Filter on Timestamp not working with DeviceFileEvents/DeviceNetworkEvents
Hi
I’m tryng to filter events in DeviceFileEvents from last week in a KQL query. But I’m experiencing strange behaviour.
When I add the time range condition, it doesn’t return any value.
Am I doing something wrong?
Do you have any ideia what the problem migth be?
Thanks in advance
NM
Hi I’m tryng to filter events in DeviceFileEvents from last week in a KQL query. But I’m experiencing strange behaviour.When I add the time range condition, it doesn’t return any value. Am I doing something wrong? Do you have any ideia what the problem migth be? Thanks in advanceNM Read More
