Month: October 2024
EXCEL HELP FORMULA
The goal is to get the max price item from the OrderPriceTracker from vendor.
Please and thank you for helping me
Jeng Chi Order Guide 2024 – Copy.xlsm
The goal is to get the max price item from the OrderPriceTracker from vendor. Please and thank you for helping me Jeng Chi Order Guide 2024 – Copy.xlsm Read More
Excluding SharePoint Online sites from Retention Policy, for removal
I understand that when I have the Purview Retention Policy set to Never Delete, that I can’t fully delete any SharePoint Online sites. If I add the sites I want to remove to the Exclude list of the Policy, how long does it normally take for that change to propagate before I have permissions to be able to delete those excluded sites?
I understand that when I have the Purview Retention Policy set to Never Delete, that I can’t fully delete any SharePoint Online sites. If I add the sites I want to remove to the Exclude list of the Policy, how long does it normally take for that change to propagate before I have permissions to be able to delete those excluded sites? Read More
PowerAutomate flow to extract data using input from forms
I’m trying to create a flow that takes input from using Forms and uses that input (unique id) to pull data from an Excel sheet (stored in SharePoint) and provide other details corresponding to that ID and send it to the user via email. How do I implement this flow in Power Automate?
Also open to other solutions that could implement this without using Power Automate
I’m trying to create a flow that takes input from using Forms and uses that input (unique id) to pull data from an Excel sheet (stored in SharePoint) and provide other details corresponding to that ID and send it to the user via email. How do I implement this flow in Power Automate? Also open to other solutions that could implement this without using Power Automate Read More
Viewing Calendar on phone
How do I view my MS 365 Outlook calendar on my Samsung Galaxy S24 Plus phone
How do I view my MS 365 Outlook calendar on my Samsung Galaxy S24 Plus phone Read More
Incoming mail. Category “Important”
Outlook, Incoming mail. Category “Important”. How delete this category? When I clean it up, it deletes the original e-mail. It’s useless.
Outlook, Incoming mail. Category “Important”. How delete this category? When I clean it up, it deletes the original e-mail. It’s useless. Read More
Can’t deploy base models in AI Studio
When i try to deploy a based model in AI Studio or OpenAI Studio (new experience) it just says ‘no models to display’. Legacy OAI Studio works ok, but I need AI Studio. All my subs and resources same result.
Any one got insight on this one?
When i try to deploy a based model in AI Studio or OpenAI Studio (new experience) it just says ‘no models to display’. Legacy OAI Studio works ok, but I need AI Studio. All my subs and resources same result. Any one got insight on this one? Read More
News and Updates about Azure Portal
Hi everyone, good morning!
Where can I stay up-to-date with the latest news, especially layout changes and updates in the Azure portal?
Sometimes I notice the interface changes, and certain options disappear or move around. Is there an official channel, newsletter, or something similar that keeps us informed about updates or changes like this?
Hi everyone, good morning!Where can I stay up-to-date with the latest news, especially layout changes and updates in the Azure portal?Sometimes I notice the interface changes, and certain options disappear or move around. Is there an official channel, newsletter, or something similar that keeps us informed about updates or changes like this? Read More
Ms 365 Copilot cannot process documents
Hello
since few days, it’s impossible to prompt on a document attached anymore. Reason provided by the chat: your document seems to be protected. This happens to all documents even if free of any kind of protection. It’s a hard blocker.
have you encountered also such issue ?
Hellosince few days, it’s impossible to prompt on a document attached anymore. Reason provided by the chat: your document seems to be protected. This happens to all documents even if free of any kind of protection. It’s a hard blocker.have you encountered also such issue ? Read More
Error in prompting on documents
Hello
since few days, it’s impossible to prompt on a document attached anymore. Reason provided by the chat: your document seems to be protected. This happens to all documents even if free of any kind of protection. It’s a hard blocker.
have you encountered also such issue ?
Hellosince few days, it’s impossible to prompt on a document attached anymore. Reason provided by the chat: your document seems to be protected. This happens to all documents even if free of any kind of protection. It’s a hard blocker.have you encountered also such issue ? Read More
Teams Rooms Startup Screen
Several “New” NUC’s have booted to this screen instead of the standard with options for settings, account etc.
Any Ideas?
Several “New” NUC’s have booted to this screen instead of the standard with options for settings, account etc.Any Ideas? Read More
How i can reOrder the Channel Tabs using graph API inside our Teams apps
I am working on a Teams App >> which creates a new SharePoint modern Teams Site + new Channels + tabs inside the channels.
The final result will be as follow: –
Now I want to reorder the tabs inside the General channel, mainly by moving the Notes tab to be the last tab, here is the method i have: –
//ReOrder General Channel Tabs
public async reorderTabs(graph: any, teamGroupId: any, channelID: string, tabName: string) {
try {
//get URL for the tab
const tabsGraphEndPoint = graphConfig.teamsGraphEndpoint + “/” + teamGroupId + graphConfig.channelsGraphEndpoint + “/” + channelID + graphConfig.tabsGraphEndpoint;
const tabs = await this.getGraphData(tabsGraphEndPoint, graph)
// Find the “Notes” tab
const notesTab = tabs.value.find((tab: any) => tab.displayName === “Notes”);
if (notesTab)
{
// Update the orderHint to move the “Notes” tab to the end
const updateTabEndpoint = graphConfig.teamsGraphEndpoint + “/” + teamGroupId + graphConfig.channelsGraphEndpoint + “/” + channelID + graphConfig.tabsGraphEndpoint + “/”+ notesTab.id;
const lastOrderHint = tabs.value[tabs.value.length – 1].orderHint;
// Set the orderHint to something greater than the last tab’s orderHint
const newOrderHint = “6”;
await this.sendGraphPatchRequest(updateTabEndpoint, graph, {
sortOrderIndex: newOrderHint
});
return notesTab.displayName;
}
} catch (error) {
console.error(
constants.errorLogPrefix + “CommonService_getTabURL n”,
JSON.stringify(error)
);
throw error;
}
}
Here is the main method inside the .tsx file:-
// wrapper method to perform teams related operations
private async createTeamAndChannels(incidentId: any) {
try {
console.log(constants.infoLogPrefix + “M365 group creation starts”);
// call method to create Teams group
const groupInfo = await this.createTeamGroup(incidentId);
try {
console.log(constants.infoLogPrefix + “M365 group created”);
// create associated team with the group
const teamInfo = await this.createTeam(groupInfo);
if (teamInfo.status) {
//log trace
this.dataService.trackTrace(this.props.appInsights, “Incident Team created “, incidentId, this.props.userPrincipalName);
//Send invitations to the guest users
let returnInvitationObj: any;
if (this.state.toggleGuestUsers)
returnInvitationObj = this.sendInvitation(groupInfo.id, teamInfo.data.displayName, teamInfo.data.webUrl)
// create channels
await this.createChannels(teamInfo.data);
this.setState({ loaderMessage: this.props.localeStrings.createPlanloaderMessage });
//Get General channel id
const generalChannelId = await this.dataService.getChannelId(this.props.graph,
groupInfo.id, constants.General);
//Add TEOC app to the Incident Team General channel’s Active Dashboard Tab
await this.dataService.createActiveDashboardTab(this.props.graph, groupInfo.id,
generalChannelId, this.props.graphContextURL, this.props.appSettings);
//Create planner with the Group ID
const planID = await this.dataService.createPlannerPlan(groupInfo.id, incidentId, this.props.graph,
this.props.graphContextURL, this.props.tenantID, generalChannelId, false);
//added for GCCH tenant
if (this.props.graphBaseUrl !== constants.defaultGraphBaseURL) {
// wait for 5 seconds to ensure the SharePoint site is available via graph API
await this.timeout(5000);
}
// graph endpoint to get team site Id
const teamSiteURLGraphEndpoint = graphConfig.teamGroupsGraphEndpoint + “/” +
groupInfo.id + graphConfig.rootSiteGraphEndpoint;
// retrieve team site details
const teamSiteDetails = await this.dataService.getGraphData(teamSiteURLGraphEndpoint, this.props.graph);
//get the team site managed path
const teamSiteManagedPathURL = teamSiteDetails.webUrl.split(teamSiteDetails.siteCollection.hostname)[1];
console.log(constants.infoLogPrefix + “Site ManagedPath”, teamSiteManagedPathURL);
// create news channel and tab
const newsTabLink = await this.createNewsTab(groupInfo, teamSiteDetails.webUrl, teamSiteManagedPathURL,groupInfo.id);
// create assessment channel and tab
// await this.createAssessmentChannelAndTab(groupInfo.id, teamSiteDetails.webUrl, teamSiteManagedPathURL);
// call method to create assessment list
//await this.createAssessmentList(groupInfo.mailNickname, teamSiteDetails.id);
//Reorder Tabs
const tabname = await this.dataService.reorderTabs(this.props.graph,teamInfo.data.id,generalChannelId,”Notes”);
console.log(constants.infoLogPrefix + “Reorder General channel Tabs”);
//log trace
this.dataService.trackTrace(this.props.appInsights, “Assessment list created “, incidentId, this.props.userPrincipalName);
//change the M365 group visibility to Private for GCCH tenant
if (this.props.graphBaseUrl !== constants.defaultGraphBaseURL) {
this.graphEndpoint = graphConfig.teamGroupsGraphEndpoint + “/” + groupInfo.id;
await this.dataService.sendGraphPatchRequest(this.graphEndpoint, this.props.graph, { “visibility”: “Private” })
console.log(constants.infoLogPrefix + “Group setting changed to Private”);
}
//Update Team details, Plan ID, NewsTabLink in Incident Transation List
const updateItemObj = {
IncidentId: incidentId,
TeamWebURL: teamInfo.data.webUrl,
PlanID: planID,
NewsTabLink: newsTabLink
};
await this.updateIncidentItemInList(incidentId, updateItemObj);
console.log(constants.infoLogPrefix + “List item updated”);
let roles: any = this.state.roleAssignments;
roles.push({
role: constants.incidentCommanderRoleName,
userNamesString: this.state.incDetailsItem.incidentCommander.userName,
userDetailsObj: [this.state.incDetailsItem.incidentCommander]
});
//post incident message in General Channel
await this.postIncidentMessage(groupInfo.id);
// create the tags for incident commander and each selected roles
await this.createTagObject(teamInfo.data.id, roles);
//log trace
this.dataService.trackTrace(this.props.appInsights, “Tags are created “, incidentId, this.props.userPrincipalName);
Promise.allSettled([returnInvitationObj]).then((promiseObj: any) => {
this.setState({
showLoader: false,
formOpacity: 1
});
// Display success message if incident updated successfully
this.props.showMessageBar(this.props.localeStrings.incidentCreationSuccessMessage, constants.messageBarType.success);
// Display error message if guest invitations
if ((promiseObj[0]?.value !== undefined && !promiseObj[0].value?.isAllSucceeded))
this.props.showMessageBar(
((promiseObj[0]?.value !== undefined && !promiseObj[0]?.value?.isAllSucceeded) ? ” ” + promiseObj[0]?.value?.message + “. ” : “”),
constants.messageBarType.error);
this.props.onBackClick(constants.messageBarType.success);
});
}
else {
// delete the group if some error occured
await this.deleteTeamGroup(groupInfo.id);
// delete the item if error occured
await this.deleteIncident(incidentId);
this.setState({
showLoader: false,
formOpacity: 1
})
this.props.showMessageBar(this.props.localeStrings.genericErrorMessage + “, ” + this.props.localeStrings.errMsgForCreateIncident, constants.messageBarType.error);
}
}
catch (error) {
console.error(
constants.errorLogPrefix + “CreateIncident_createTeamAndChannels n”,
JSON.stringify(error)
);
// Log Exception
this.dataService.trackException(this.props.appInsights, error, constants.componentNames.IncidentDetailsComponent, ‘CreateIncident_createTeamAndChannels’, this.props.userPrincipalName);
// delete the group if some error occured
await this.deleteTeamGroup(groupInfo.id);
// delete the item if error occured
await this.deleteIncident(incidentId);
this.setState({
showLoader: false,
formOpacity: 1
})
this.props.showMessageBar(this.props.localeStrings.genericErrorMessage + “, ” + this.props.localeStrings.errMsgForCreateIncident, constants.messageBarType.error);
}
}
catch (error: any) {
console.error(
constants.errorLogPrefix + “CreateIncident_createTeamAndChannels n”,
JSON.stringify(error)
);
// Log Exception
this.dataService.trackException(this.props.appInsights, error, constants.componentNames.IncidentDetailsComponent, ‘CreateIncident_createTeamAndChannels’, this.props.userPrincipalName);
// delete the item if error occured
this.deleteIncident(incidentId);
this.setState({
showLoader: false,
formOpacity: 1
});
// Display error message if M365 group creation fails with access denied error
if (error?.statusCode === 403 && error?.code === constants.authorizationRequestDenied
&& error?.message === constants.groupCreationAccessDeniedErrorMessage) {
this.props.showMessageBar(this.props.localeStrings.genericErrorMessage + “, ” + this.props.localeStrings.m365GroupCreationFailedMessage, constants.messageBarType.error);
}
/* Display error message if M365 group creation fails with group already exists error
or any other error */
else {
this.props.showMessageBar(this.props.localeStrings.genericErrorMessage + “, ” + this.props.localeStrings.errMsgForCreateIncident, constants.messageBarType.error);
}
}
}
But after calling the above method during the site and channel creation the Notes will stay the 3rd tab. any advice?
I am working on a Teams App >> which creates a new SharePoint modern Teams Site + new Channels + tabs inside the channels.The final result will be as follow: – Now I want to reorder the tabs inside the General channel, mainly by moving the Notes tab to be the last tab, here is the method i have: – //ReOrder General Channel Tabs
public async reorderTabs(graph: any, teamGroupId: any, channelID: string, tabName: string) {
try {
//get URL for the tab
const tabsGraphEndPoint = graphConfig.teamsGraphEndpoint + “/” + teamGroupId + graphConfig.channelsGraphEndpoint + “/” + channelID + graphConfig.tabsGraphEndpoint;
const tabs = await this.getGraphData(tabsGraphEndPoint, graph)
// Find the “Notes” tab
const notesTab = tabs.value.find((tab: any) => tab.displayName === “Notes”);
if (notesTab)
{
// Update the orderHint to move the “Notes” tab to the end
const updateTabEndpoint = graphConfig.teamsGraphEndpoint + “/” + teamGroupId + graphConfig.channelsGraphEndpoint + “/” + channelID + graphConfig.tabsGraphEndpoint + “/”+ notesTab.id;
const lastOrderHint = tabs.value[tabs.value.length – 1].orderHint;
// Set the orderHint to something greater than the last tab’s orderHint
const newOrderHint = “6”;
await this.sendGraphPatchRequest(updateTabEndpoint, graph, {
sortOrderIndex: newOrderHint
});
return notesTab.displayName;
}
} catch (error) {
console.error(
constants.errorLogPrefix + “CommonService_getTabURL n”,
JSON.stringify(error)
);
throw error;
}
} Here is the main method inside the .tsx file:- // wrapper method to perform teams related operations
private async createTeamAndChannels(incidentId: any) {
try {
console.log(constants.infoLogPrefix + “M365 group creation starts”);
// call method to create Teams group
const groupInfo = await this.createTeamGroup(incidentId);
try {
console.log(constants.infoLogPrefix + “M365 group created”);
// create associated team with the group
const teamInfo = await this.createTeam(groupInfo);
if (teamInfo.status) {
//log trace
this.dataService.trackTrace(this.props.appInsights, “Incident Team created “, incidentId, this.props.userPrincipalName);
//Send invitations to the guest users
let returnInvitationObj: any;
if (this.state.toggleGuestUsers)
returnInvitationObj = this.sendInvitation(groupInfo.id, teamInfo.data.displayName, teamInfo.data.webUrl)
// create channels
await this.createChannels(teamInfo.data);
this.setState({ loaderMessage: this.props.localeStrings.createPlanloaderMessage });
//Get General channel id
const generalChannelId = await this.dataService.getChannelId(this.props.graph,
groupInfo.id, constants.General);
//Add TEOC app to the Incident Team General channel’s Active Dashboard Tab
await this.dataService.createActiveDashboardTab(this.props.graph, groupInfo.id,
generalChannelId, this.props.graphContextURL, this.props.appSettings);
//Create planner with the Group ID
const planID = await this.dataService.createPlannerPlan(groupInfo.id, incidentId, this.props.graph,
this.props.graphContextURL, this.props.tenantID, generalChannelId, false);
//added for GCCH tenant
if (this.props.graphBaseUrl !== constants.defaultGraphBaseURL) {
// wait for 5 seconds to ensure the SharePoint site is available via graph API
await this.timeout(5000);
}
// graph endpoint to get team site Id
const teamSiteURLGraphEndpoint = graphConfig.teamGroupsGraphEndpoint + “/” +
groupInfo.id + graphConfig.rootSiteGraphEndpoint;
// retrieve team site details
const teamSiteDetails = await this.dataService.getGraphData(teamSiteURLGraphEndpoint, this.props.graph);
//get the team site managed path
const teamSiteManagedPathURL = teamSiteDetails.webUrl.split(teamSiteDetails.siteCollection.hostname)[1];
console.log(constants.infoLogPrefix + “Site ManagedPath”, teamSiteManagedPathURL);
// create news channel and tab
const newsTabLink = await this.createNewsTab(groupInfo, teamSiteDetails.webUrl, teamSiteManagedPathURL,groupInfo.id);
// create assessment channel and tab
// await this.createAssessmentChannelAndTab(groupInfo.id, teamSiteDetails.webUrl, teamSiteManagedPathURL);
// call method to create assessment list
//await this.createAssessmentList(groupInfo.mailNickname, teamSiteDetails.id);
//Reorder Tabs
const tabname = await this.dataService.reorderTabs(this.props.graph,teamInfo.data.id,generalChannelId,”Notes”);
console.log(constants.infoLogPrefix + “Reorder General channel Tabs”);
//log trace
this.dataService.trackTrace(this.props.appInsights, “Assessment list created “, incidentId, this.props.userPrincipalName);
//change the M365 group visibility to Private for GCCH tenant
if (this.props.graphBaseUrl !== constants.defaultGraphBaseURL) {
this.graphEndpoint = graphConfig.teamGroupsGraphEndpoint + “/” + groupInfo.id;
await this.dataService.sendGraphPatchRequest(this.graphEndpoint, this.props.graph, { “visibility”: “Private” })
console.log(constants.infoLogPrefix + “Group setting changed to Private”);
}
//Update Team details, Plan ID, NewsTabLink in Incident Transation List
const updateItemObj = {
IncidentId: incidentId,
TeamWebURL: teamInfo.data.webUrl,
PlanID: planID,
NewsTabLink: newsTabLink
};
await this.updateIncidentItemInList(incidentId, updateItemObj);
console.log(constants.infoLogPrefix + “List item updated”);
let roles: any = this.state.roleAssignments;
roles.push({
role: constants.incidentCommanderRoleName,
userNamesString: this.state.incDetailsItem.incidentCommander.userName,
userDetailsObj: [this.state.incDetailsItem.incidentCommander]
});
//post incident message in General Channel
await this.postIncidentMessage(groupInfo.id);
// create the tags for incident commander and each selected roles
await this.createTagObject(teamInfo.data.id, roles);
//log trace
this.dataService.trackTrace(this.props.appInsights, “Tags are created “, incidentId, this.props.userPrincipalName);
Promise.allSettled([returnInvitationObj]).then((promiseObj: any) => {
this.setState({
showLoader: false,
formOpacity: 1
});
// Display success message if incident updated successfully
this.props.showMessageBar(this.props.localeStrings.incidentCreationSuccessMessage, constants.messageBarType.success);
// Display error message if guest invitations
if ((promiseObj[0]?.value !== undefined && !promiseObj[0].value?.isAllSucceeded))
this.props.showMessageBar(
((promiseObj[0]?.value !== undefined && !promiseObj[0]?.value?.isAllSucceeded) ? ” ” + promiseObj[0]?.value?.message + “. ” : “”),
constants.messageBarType.error);
this.props.onBackClick(constants.messageBarType.success);
});
}
else {
// delete the group if some error occured
await this.deleteTeamGroup(groupInfo.id);
// delete the item if error occured
await this.deleteIncident(incidentId);
this.setState({
showLoader: false,
formOpacity: 1
})
this.props.showMessageBar(this.props.localeStrings.genericErrorMessage + “, ” + this.props.localeStrings.errMsgForCreateIncident, constants.messageBarType.error);
}
}
catch (error) {
console.error(
constants.errorLogPrefix + “CreateIncident_createTeamAndChannels n”,
JSON.stringify(error)
);
// Log Exception
this.dataService.trackException(this.props.appInsights, error, constants.componentNames.IncidentDetailsComponent, ‘CreateIncident_createTeamAndChannels’, this.props.userPrincipalName);
// delete the group if some error occured
await this.deleteTeamGroup(groupInfo.id);
// delete the item if error occured
await this.deleteIncident(incidentId);
this.setState({
showLoader: false,
formOpacity: 1
})
this.props.showMessageBar(this.props.localeStrings.genericErrorMessage + “, ” + this.props.localeStrings.errMsgForCreateIncident, constants.messageBarType.error);
}
}
catch (error: any) {
console.error(
constants.errorLogPrefix + “CreateIncident_createTeamAndChannels n”,
JSON.stringify(error)
);
// Log Exception
this.dataService.trackException(this.props.appInsights, error, constants.componentNames.IncidentDetailsComponent, ‘CreateIncident_createTeamAndChannels’, this.props.userPrincipalName);
// delete the item if error occured
this.deleteIncident(incidentId);
this.setState({
showLoader: false,
formOpacity: 1
});
// Display error message if M365 group creation fails with access denied error
if (error?.statusCode === 403 && error?.code === constants.authorizationRequestDenied
&& error?.message === constants.groupCreationAccessDeniedErrorMessage) {
this.props.showMessageBar(this.props.localeStrings.genericErrorMessage + “, ” + this.props.localeStrings.m365GroupCreationFailedMessage, constants.messageBarType.error);
}
/* Display error message if M365 group creation fails with group already exists error
or any other error */
else {
this.props.showMessageBar(this.props.localeStrings.genericErrorMessage + “, ” + this.props.localeStrings.errMsgForCreateIncident, constants.messageBarType.error);
}
}
} But after calling the above method during the site and channel creation the Notes will stay the 3rd tab. any advice? Read More
If only MS would take more care of details…
Currently setting up the “deduplication-corruption repo with newest pre-release Server 2025 as L1 and L2 VMs”.
And then I see this:
It is still the problem a lot of “Client only, never needed or wanted on a server by default” stuff creeps into the Server UI.
Another example of today is this bad default setting:
Microsoft could do so much better if it would take more care of details, reduce the Marketing/Public-Relations (previously known as Propaganda Departement) budget and invest more in actual quality.
Please Dave Cutler, you have to rescue Windows – AGAIN, like you did when XP was released (i.e. when it was SP0, I remember how bad it was at first)…
Currently setting up the “deduplication-corruption repo with newest pre-release Server 2025 as L1 and L2 VMs”.And then I see this: It is still the problem a lot of “Client only, never needed or wanted on a server by default” stuff creeps into the Server UI. Another example of today is this bad default setting: Microsoft could do so much better if it would take more care of details, reduce the Marketing/Public-Relations (previously known as Propaganda Departement) budget and invest more in actual quality.Please Dave Cutler, you have to rescue Windows – AGAIN, like you did when XP was released (i.e. when it was SP0, I remember how bad it was at first)… Read More
Want to show specified text based on month in selected cell in excel
Hello everyone,
I’m stuck with the next problem:
I am creating something like resource list of parts in maintenance. My goal is to show text in a cell based on year quartals (jan, feb and mar are the first quartal, apr, may and jun second, etc).
I have parts with 9 years of lifetime.
I have first column with a names of parts, second column shows years of lifetime, third is showing quartal of the year when the part is manufactured, and fourth needs to show me date when the lifetime of the part ends (for example: part is manufacured “1Q/18” then the fourth column needs to show date of expiration of that part in next format “31.03.2027.”).
My first idea was to create an “IF” formula which will do this: if the first part of the cell is “1Q” then in next cell show date “31.03”. If the first part of the cell is “2Q” then show date “30.06”. I want the day and the month to depend on quartal of the year (first part of the cell) and year must sum da year of manufacturing “/18” (18 says that part is manufactured in 2018.) plus year of lifetime of part. In this specific case 2018(/18)+9 years (lifetime is 9 year) = 2027. So, if i enter in a cell “1Q/18” the next cell needs to show me “31.03.2027.”.
If anyone can help, i will be gratefull.
Thanks a lot.
Hello everyone, I’m stuck with the next problem:I am creating something like resource list of parts in maintenance. My goal is to show text in a cell based on year quartals (jan, feb and mar are the first quartal, apr, may and jun second, etc).I have parts with 9 years of lifetime.I have first column with a names of parts, second column shows years of lifetime, third is showing quartal of the year when the part is manufactured, and fourth needs to show me date when the lifetime of the part ends (for example: part is manufacured “1Q/18” then the fourth column needs to show date of expiration of that part in next format “31.03.2027.”). My first idea was to create an “IF” formula which will do this: if the first part of the cell is “1Q” then in next cell show date “31.03”. If the first part of the cell is “2Q” then show date “30.06”. I want the day and the month to depend on quartal of the year (first part of the cell) and year must sum da year of manufacturing “/18” (18 says that part is manufactured in 2018.) plus year of lifetime of part. In this specific case 2018(/18)+9 years (lifetime is 9 year) = 2027. So, if i enter in a cell “1Q/18” the next cell needs to show me “31.03.2027.”.If anyone can help, i will be gratefull. Thanks a lot.Manually written, without formulas Read More
List bullets redefining their own left-indents somehow (tables, multi-level lists)
There is some weird interaction with tables and muti-level lists that I run into intermittently.
It has happened twice tonight.
Essentially, I have a List Bullets styles 1-5 which indent in an orderly, style-conforming way when I press alt-shift-L/RArrow. I followed the tutorial that always gets linked to on forums like these for defining this.
These list bullets left-indent in increments of 0.25″. So List Bullet = 0″, List Bullet 2 = 0.25″, List Bullet 3 = 0.5″, etc.
When I am inserting and (un)indenting these inside tables, eventually I will notice that the indents aren’t looking right. I will check the styles and (in this instance), List Bullet 2 is suddenly 0.47″.
At no point have I deliberately altered a style definition. In fact, I have “mark formatting inconsistencies” turned on, and will periodically select anything that deviates from rigid style conformity and clear direct formatting at both the paragraph and character level. I am really trying to do Word right.
I can’t even begin to understand why these styles would redefine themselves, but I’m somewhat convinced it has something to do with tables. It seems that whenever I use anything that involves nesting of some kind within a table, my document becomes “haunted” and nondeterministic. I long ago found out to NEVER use style headings in tables, as that seems to be even worse at filling my document with poltergeists.
Why would my list bullet styles ever, ever redefine themselves like this?
I can handle some MS quirks if I can select everything and hit ctrl-q and ctrl-space to restore order. But I don’t know how to approach this.
There is some weird interaction with tables and muti-level lists that I run into intermittently. It has happened twice tonight. Essentially, I have a List Bullets styles 1-5 which indent in an orderly, style-conforming way when I press alt-shift-L/RArrow. I followed the tutorial that always gets linked to on forums like these for defining this. These list bullets left-indent in increments of 0.25″. So List Bullet = 0″, List Bullet 2 = 0.25″, List Bullet 3 = 0.5″, etc. When I am inserting and (un)indenting these inside tables, eventually I will notice that the indents aren’t looking right. I will check the styles and (in this instance), List Bullet 2 is suddenly 0.47″. At no point have I deliberately altered a style definition. In fact, I have “mark formatting inconsistencies” turned on, and will periodically select anything that deviates from rigid style conformity and clear direct formatting at both the paragraph and character level. I am really trying to do Word right. I can’t even begin to understand why these styles would redefine themselves, but I’m somewhat convinced it has something to do with tables. It seems that whenever I use anything that involves nesting of some kind within a table, my document becomes “haunted” and nondeterministic. I long ago found out to NEVER use style headings in tables, as that seems to be even worse at filling my document with poltergeists. Why would my list bullet styles ever, ever redefine themselves like this? I can handle some MS quirks if I can select everything and hit ctrl-q and ctrl-space to restore order. But I don’t know how to approach this. Read More
Unlock Your Future with Microsoft Student Opportunities
Ready to take your first steps toward a career in tech? As someone who transitioned from student life to a full-time job in tech, I am here to share how you can unlock incredible opportunities at Microsoft like internships, competitions, and more to kickstart your career in tech!
👋 My name is Kiana, and I joined Microsoft just over two years ago as a Product Manager in the Azure Edge + Platform space. Before that, I spent two years as a Software Engineer. As someone who was once in your shoes and is now a full-time employee, I am super passionate about helping students navigate the world of resume building and networking. Don’t hesitate to reach out – connect with me on LinkedIn. Microsoft offers a wide array of opportunities for students to grow and thrive, and I’m here to share some insights and tips to help you make the most of them!
1. ⚡Microsoft Imagine Cup⚡
Unlock your startup’s potential with the Imagine Cup – the premier global technology startup competition for student founders using AI technologies on the Microsoft Cloud. Compete for the grand prize and a mentorship session with Microsoft Chairman and CEO Satya Nadella. Gain access to networking opportunities, global recognition and expert coaching during the competition to accelerate your startup. Imagine Cup is more than a competition; it’s a transformative journey that helps student founders turn their innovative ideas into market-ready startups.
Eligibility:
Participants must be at least 18 years old as of October 1, 2024, and enrolled students at an accredited educational institution between October 1, 2024, and May 31, 2025.
U.S. export regulations prohibit the export of goods and services to Cuba, Iran, North Korea, Sudan, Syria, Russia, and the Region of Crimea. Therefore, residents of these countries/regions are not eligible to participate.
Mentors are not considered team members for the purpose of this competition.
Please see the rules and regulations for full eligibility criteria.
Benefits:
Access to AI Technology: Accelerate your growth and scale quickly with access to industry-leading AI services through Microsoft for Startups Founders Hub
Expert Technical Advice and Founder Guidance: Receive 1-on-1 mentorship and immediate guidance from Microsoft experts to solve business and technical challenges quickly
Prizes and Global Recognition: Win up to $100k USD and an exclusive mentoring session with Microsoft Chairman and CEO, Satya Nadella
Learn more here: https://imaginecup.microsoft.com/en-us?wt.mc_id=ic25_studenthub_website
2. ⚡Microsoft Student Innovator Series⚡
Explore and innovate with AI and the Microsoft Cloud through the Microsoft Student Innovator Series. This exciting program offers a range of events designed to help you take your next steps as a tech innovator. Deep dive sessions include Azure AI and Microsoft for Startups Founders Hub.
Eligibility: Anyone
Benefits:
Network with the community
Learn new concepts and topics within the tech industry
Learn more here: https://developer.microsoft.com/en-us/reactor/series/S-1386?wt.mc_id=StudentHub_S-1386_webpage_Student_Reactor
3. ⚡Microsoft for Startups Founders Hub
Microsoft for Startups Founders Hub helps startups radically accelerate innovation by providing access to industry-leading AI services, expert guidance, and the essential technology needed to build a future-proofed startup.
Eligibility:
To apply for Microsoft for Startups Founders Hub your startup must meet the following criteria:
Engaged in the development of a software-based product or service that is a core part of your current or intended business. The software must be owned and not licensed from another party.
Your startup received less than $10,000 in free Azure credits.
Your headquarters is in one of the countries covered by Azure.
Your startup hasn’t gone through a Series D or later funding round.
Your startup is privately held.
Your startup is a for-profit business.
Your startup isn’t an educational institution, government entity, personal blog, dev shop, consultancy, agency, bitcoin, or crypto mining company.
Benefits:
Cutting-edge AI tools: All startups get free access to leading AI models through Azure, including OpenAI GPT-4, Llama 2 from Meta, and more. Get up to $150,000 in Azure credits, plus $2,500 of OpenAI credits.
Free Azure credits: Up to $150,000 in Azure credits to conserve runway while you experiment, prototype, and build.
Access to real people: Unlimited 1:1 meetings with experts who can help solve immediate business challenges, plus provide technical guidance on the latest in AI.
Free software and development tools: 30+ additional free and discounted tools, tech, and services from Microsoft and our partners including M365, GitHub, LinkedIn, and more.
Learn more here: https://foundershub.startups.microsoft.com/signup
4. ⚡Microsoft Internships⚡
Microsoft internships offer the opportunity to work on meaningful projects and cutting-edge technology in all job families and solution areas. Open to current Bachelor’s, Master’s, MBA, and PhD students, the program is designed to provide valuable learning and growth experiences within a diverse and engaging culture.
Eligibility:
Students must be enrolled full-time in an applicable field and plan to return to university/college for at least one term following the internship period.
Benefits:
Competitive pay
Software Discounts
Free ORCA bus pass
Other discounts from Microsoft Prime (travel, restaurants, etc.)
Learn more here: https://careers.microsoft.com/v2/global/en/home.html
5. ⚡Azure for Students⚡
Azure for Students gives students free access to Microsoft Azure, allowing them to explore cloud computing and develop skills with various services and tools. There is no credit card required, making it easy to build and test applications. This program supports hands-on learning and helps students prepare for careers in tech while working on their projects. Note: Microsoft also offers a free tier to non-students. Read more here.
Eligibility:
Azure for Students is available only to students who meet the following requirements:
You must affirm that you attend an accredited, degree-granting, two- to four-year university educational institution where you’re a full-time student.
You must verify your academic status through your organization’s email address.
Benefits:
Free popular Azure services for up to 12 months
Over 55 other services that are always free to use
Accessible from anywhere with an internet connection
Flexible pricing models after the free trial is over
Provides real-world experience with cloud computing
Offers collaboration tools for teamwork and communication skills
Learn more here: https://azure.microsoft.com/en-us/free/students/
6. ⚡Microsoft Learn Student Ambassador⚡
The Microsoft Learn Student Ambassador program brings together students who are enthusiastic about technology and community engagement. Ambassadors receive access to exclusive resources, training, and events, allowing them to share their knowledge and skills with others. By participating, students can enhance their leadership abilities, expand their network, and make a positive impact in their communities while exploring Microsoft technologies. This program offers a valuable opportunity for personal and professional growth in a collaborative environment.
Eligibility:
Be age 16 or older at time of application
Be enrolled full-time in an accredited academic institution (e.g. College, University)
Be an individual person (not a corporate entity)
Not be a Microsoft employee or current contractor
Benefits:
Access to Microsoft 365.
Visual Studio Enterprise subscription
$150 monthly Azure credits
Ready-to-go presentation materials
Engagement with Microsoft employees, Microsoft MVPs, Cloud Advocates, and other students worldwide
Student Ambassadors milestone badges highlighting accomplishments
Student Ambassadors Swag
Learn more here: https://mvp.microsoft.com/studentambassadors
Microsoft Tech Community – Latest Blogs –Read More
Some extensions don’t work on Android Edge Canary when returning to the app
I am using Edge Canary and have installed several extensions through the developer options, but some of the extensions are not working when I resume from the background.
The extensions that don’t work seem to be automatically disabled internally, so I can disable them from the extension options and then re-enable them to use them again. (However, in the latest Canary build, if this problem occurs, the app crashes when I try to open the extension options.)
This issue occurs with uBlock Origin, Stylus, etc., and probably occurs with the Manifest V2 extension.
This issue occurs on multiple devices and occurs even after reinstalling, so it is not device-dependent.
I am using Edge Canary and have installed several extensions through the developer options, but some of the extensions are not working when I resume from the background.The extensions that don’t work seem to be automatically disabled internally, so I can disable them from the extension options and then re-enable them to use them again. (However, in the latest Canary build, if this problem occurs, the app crashes when I try to open the extension options.)This issue occurs with uBlock Origin, Stylus, etc., and probably occurs with the Manifest V2 extension.This issue occurs on multiple devices and occurs even after reinstalling, so it is not device-dependent. Read More
Has Microsoft Solved the nvlddmkm.sys BSOD Error Which May Be Related to the Update Download Failure
Hi Microsoft friends, Has Microsoft solved the nvlddmkm.sys which may be related to the Update.Download Failure Error 0x800f0841 which should update the build to the latest Windows 11 version? My temporary fix after a grueling days of lost productivity is to disable the Nvidia driver in Device Manager but of course this cause the resolution to be wrong coz’ the basic drivers lack the native screen resolution and graphical tasks are slow and games can’t be played.
What could the fix be for both?
Thank you in advance.
God bless the Microsoft Masterace.
Hi Microsoft friends, Has Microsoft solved the nvlddmkm.sys which may be related to the Update.Download Failure Error 0x800f0841 which should update the build to the latest Windows 11 version? My temporary fix after a grueling days of lost productivity is to disable the Nvidia driver in Device Manager but of course this cause the resolution to be wrong coz’ the basic drivers lack the native screen resolution and graphical tasks are slow and games can’t be played. What could the fix be for both? Thank you in advance. God bless the Microsoft Masterace. Read More
Nested if statement in the expression builder (dynamic editor)
Hello
I am trying to check activity steps failed and if so, get Target (activity) value, something like this below
@{
“FailedStepAt”: “@{if(not(empty(activity(‘lkp_tables_list’).erro.message)), activity(‘lkp_tables_list’)?.erro.target,
if(not(equals(activity(‘lkp_GetPipelineIDByName’).error.message, ”)), activity(‘lkp_GetPipelineIDByName’).error.target,
if(not(equals(activity(‘Export_table_to_NTADLS’).error.message, ”)), activity(‘Export_table_to_NTADLS’).error.target,
”)))}”,
“ErrorMessage”: “@{concat(activity(‘lkp_tables_list’)?.error?.message,
activity(‘lkp_GetPipelineIDByName’)?.error?.message,
activity(‘Export_table_to_NTADLS’)?.error?.message
}
But it doesn’t work . However, to check the target value if activity fails, used set variable to capture the target value but it supports with one condition something like .”
Or within set variable activity
Any help would be appreciated
Hello
I am trying to check activity steps failed and if so, get Target (activity) value, something like this below
@{
“FailedStepAt”: “@{if(not(empty(activity(‘lkp_tables_list’).erro.message)), activity(‘lkp_tables_list’)?.erro.target, if(not(equals(activity(‘lkp_GetPipelineIDByName’).error.message, ”)), activity(‘lkp_GetPipelineIDByName’).error.target,if(not(equals(activity(‘Export_table_to_NTADLS’).error.message, ”)), activity(‘Export_table_to_NTADLS’).error.target,”)))}”,”ErrorMessage”: “@{concat(activity(‘lkp_tables_list’)?.error?.message,activity(‘lkp_GetPipelineIDByName’)?.error?.message,activity(‘Export_table_to_NTADLS’)?.error?.message
}
But it doesn’t work . However, to check the target value if activity fails, used set variable to capture the target value but it supports with one condition something like .”
“@{if(not(empty(activity(‘lkp_GetPipelineIDByName’).error)), activity(‘lkp_GetPipelineIDByName’).error.target,
‘no err’)
}”
I want to achieve using nested if within dynamic edition
Or within set variable activity
Any help would be appreciated Read More
पेटीएम पर गलत पेमेंट हो जाए तो क्या करें?.
मैं गलत लेनदेन के लिए पेटीएम से रिफंड कैसे प्राप्त कर सकता हूँ?नंबर सहायता टीम (0629O-341+872} तक पहुंच सकते हैं और जितनी जल्दी हो सके अपनी शिकायत दर्ज कर सकते हैं।
मैं गलत लेनदेन के लिए पेटीएम से रिफंड कैसे प्राप्त कर सकता हूँ?नंबर सहायता टीम (0629O-341+872} तक पहुंच सकते हैं और जितनी जल्दी हो सके अपनी शिकायत दर्ज कर सकते हैं। Read More
क्या मैं फोनपे के खिलाफ शिकायत दर्ज कर सकता हूं?
फोनपे गलत ट्रांजेक्शन से पैसे कैसे वापस करें? नंबर सहायता टीम (0629O-348-l72} तक पहुंच सकते हैं और जितनी जल्दी हो सके अपनी शिकायत दर्ज कर सकते हैं।
फोनपे गलत ट्रांजेक्शन से पैसे कैसे वापस करें? नंबर सहायता टीम (0629O-348-l72} तक पहुंच सकते हैं और जितनी जल्दी हो सके अपनी शिकायत दर्ज कर सकते हैं। Read More