Category: Microsoft
Category Archives: Microsoft
Need Help with Date Formatting for SharePoint Event List
Hello everyone,
I have a requirement where I need to save data to a SharePoint event list using a modal form and display the data as cards on a webpage. However, I’m encountering an issue with date formatting. The dates are not displaying correctly.
I have tried several approaches, including:
Saving the date in UTC format and converting it to local time when displaying.Using ISO format for date storage and display.
Despite these efforts, the dates are still not showing correctly. Has anyone faced a similar issue or have suggestions on how to resolve this?
Thank you in advance for your help!
Hello everyone, I have a requirement where I need to save data to a SharePoint event list using a modal form and display the data as cards on a webpage. However, I’m encountering an issue with date formatting. The dates are not displaying correctly. I have tried several approaches, including: Saving the date in UTC format and converting it to local time when displaying.Using ISO format for date storage and display.Despite these efforts, the dates are still not showing correctly. Has anyone faced a similar issue or have suggestions on how to resolve this? Thank you in advance for your help! $().SPServices( { operation: “UpdateListItems”, async: false, webURL: webURL, batchCmd: “New”, listName: “Events”, valuepairs: [ [“Title”, Title], [“EventDate”, EventDate], [“EndDate”, EndDate], [“Location”, Location], [“Category”, Category], [“Description”, Description] ], completefunc: function(xData, Status) { EventId = $(xData.responseXML).SPFilterNode(“z:row”).attr(“ows_ID”); if(EventId > 0){ GetEventData(); } } }); Read More
How to download Excel Formula worksheet
I have needed Microsoft Excel Formula for personal guidance
I have needed Microsoft Excel Formula for personal guidance Read More
How to delay sending of ALL emails ?
Ok, this shouldn’t have to be asked, but I can find no way in MS Office Pro Outlook 2021 to set a delay time in minutes to hold sent messages in the outbox before sending. How to do this?
Thanks.
Ok, this shouldn’t have to be asked, but I can find no way in MS Office Pro Outlook 2021 to set a delay time in minutes to hold sent messages in the outbox before sending. How to do this? Thanks. Read More
When is Network Profile Issue for Domain Controllers going to be at least acknowledged?
Since the insider builds from 25398 to the latest 26227 all have the same bug where the domain controller on the builds will show the network category as Public instead of DomainAuthenticated and the only way to fix it is to disable and re-enable the NIC after each reboot.
There has been a few bug reports submitted in the feedback hub and in this community many months ago. It would be at least be nice to be acknowledged.
Since the insider builds from 25398 to the latest 26227 all have the same bug where the domain controller on the builds will show the network category as Public instead of DomainAuthenticated and the only way to fix it is to disable and re-enable the NIC after each reboot. There has been a few bug reports submitted in the feedback hub and in this community many months ago. It would be at least be nice to be acknowledged. Read More
Extend Copilot for Sales with custom data and insights from your own apps
Optimize the sales process by integrating internal and external data with Copilot for Sales. Create enriched email summaries, customized meeting prep documents, and actionable meeting recaps to improve customer interactions. Copilot uses AI to generate insights and suggest actions based on comprehensive data, ensuring sales teams have all the necessary information at their fingertips. Create custom AI experiences using Copilot Studio with zero code. By adding Copilot extensions, users can connect to external data sources and build tailored AI skills.
Eric Boocock, Copilot for Sales Principal Program Manager, shares how Copilot for Sales works and how to build Copilot extensions to connect with other systems for personalized experiences.
Strengthen and inform the sales process.
Bring in data from connected services that provide critical customer intelligence. Check out Copilot for Sales.
Generate personalized meeting prep docs and meeting recaps.
Save time using Copilot for Sales.
Connect data from external systems.
See how to create Copilot extensions with zero code from Copilot Studio using Copilot Actions.
Watch the video here:
QUICK LINKS:
00:00 — Copilot for Sales
00:36 — Baseline experiences
02:13 — Bring in external data
03:26 — Use Copilot to respond to emails
03:54 — Meeting prep and meeting recap
04:52 — Security and Responsible AI
06:27 — Copilot extensions
09:09 — Publish Copilot extensions
09:40 — Wrap up
Link References
Check out https://aka.ms/CopilotforSalesExtensibility
Stay updated on monthly releases at https://aka.ms/CopilotforSalesUpdates
Unfamiliar with Microsoft Mechanics?
As Microsoft’s official video series for IT, you can watch and share valuable content and demos of current and upcoming tech from the people who build it at Microsoft.
Subscribe to our YouTube: https://www.youtube.com/c/MicrosoftMechanicsSeries
Talk with other IT Pros, join us on the Microsoft Tech Community: https://techcommunity.microsoft.com/t5/microsoft-mechanics-blog/bg-p/MicrosoftMechanicsBlog
Watch or listen from anywhere, subscribe to our podcast: https://microsoftmechanics.libsyn.com/podcast
Keep getting this insider knowledge, join us on social:
Follow us on Twitter: https://twitter.com/MSFTMechanics
Share knowledge on LinkedIn: https://www.linkedin.com/company/microsoft-mechanics/
Enjoy us on Instagram: https://www.instagram.com/msftmechanics/
Loosen up with us on TikTok: https://www.tiktok.com/@msftmechanics
Video Transcript:
-What if you could go beyond the insights available in your CRM and collaboration tools to easily bring in data from connected services that provide critical customer intelligence to strengthen and inform the sales process.
-Today, we’ll look at how this is possible using generative AI with Copilot for Sales, grounded with information from both your internal and external systems. And the zero-code way to light the experience up with Copilot Studio to connect to your data with extensions and build custom AI skills using Copilot actions.
-Let’s start with your baseline experience using Copilot for Sales, which if you haven’t looked at it in a while, enriches your Copilot for Microsoft 365 experience. For example, email summaries are enriched with data from your CRM. There are suggested CRM updates found in the email to ensure no action is missed and CRM data is current and simple to update from the context of Outlook.
-Then, to close the loop, suggested email response prompts are geared towards closing a deal that draw on all the context of the email and data from your CRM. Meeting prep documents are more customized with content generated using information from CRM records, along with details from referenced upcoming meetings in Microsoft 365.
-The brief is formatted to include who the participants are, the opportunity summary, recent meeting insights, email thread summaries, related records from the CRM, and any open customer service cases that the team should be aware of going into our upcoming call. Additionally, Copilot for Sales shares the meeting prep in Teams as team members join meetings.
-And meeting recaps are made more relatable and actionable with the rich AI capabilities of Copilot for Microsoft 365, used to summarize the meeting and Copilot for Sales, bringing in sales-specific actions like follow-up tasks to create in CRM, as well as a record of questions asked, conversational KPIs, and keywords mentioned. In these examples, we ground your generative AI experience with information from your CRM and Microsoft 365. Next, let me show you how your experience is enriched further by bringing in data from external connected systems and tailored custom skills.
-As I open an email from a prospective customer, Alberto, in addition to what we just saw, we’ve created an extension, Contoso Customer Intelligence, which surfaces additional details about the customer, including other people at Contoso he’s worked with in the past, as well as product pages he’s favorited while signed into our company website. And in a moment, I’ll show you how we enabled this in Copilot Studio.
-Within the Copilot for Sales sidecar, the custom extension Contoso Customer Intelligence displays expanded company insights and suggested actions to update opportunity details and schedule a meeting. Given the prior work history with Alberto’s company, Fourth Coffee, I can use the Copilot chat experience within Outlook to then prompt for past opportunities and agreements with Fourth Coffee. And I can find the details about Fourth Coffee’s previous purchases with us.
-These results also include information from our Contoso Customer Intelligence connected app. With all this context, I can respond to Alberto’s email mentioning those additional details. I’ve used Copilot to start an email here, along with an invitation to a meeting to discuss the espresso machines that he’s interested in. I’ve also been able to proactively include a 5% discount opportunity if Alberto completes his purchase this month.
-So, as I’ve shown, generative AI can now gain context from available information across my CRM, Microsoft 365, and Connected Systems, to inform and improve my customer interactions. And there’s even more that Copilot for Sales can do to help me save time with additional insights. With Copilot in Word, I can generate personalized meeting prep documents connected to my CRM and external applications through Copilot for Sales. In my case, I’ll use Copilot with a forward slash, to reference an upcoming sales meeting called Follow-Up: Fourth Coffee.
-This generated document includes details about the meeting, participant information, topics for the discussion, and even account-specific information extracted from CRM and our connected external app, as well as open tasks all within seconds. Also, moving ahead to the day of the meeting, I can use the integrated meeting recap to take care of follow-up actions.
-Here, the after-call summary captures notes including integrated follow-up tasks with our Copilot extension. That’s one example of a connected and integrated Copilot for Sales experience. Now, since this is Mechanics, let me explain how the different surfaces were connected, enabling Copilot to securely access the information it needed to inform responses.
-The Copilot for Sales system is comprised of large language models, along with the Microsoft Graph, with user-level activities and data, and Microsoft 365 app experiences, and it connects to your sales data in CRM systems from either Salesforce or Dynamics 365, as well as connected external systems using Copilot extensions. With the right grounding data, including external data that’s accessible, here’s how responses are then generated. Beginning with the prompt, Copilot utilizes Retrieval Augmented Generation to orchestrate information search from the Microsoft Graph, CRM system, and connected external systems.
-Copilot for Sales also incorporates AI-generated skills to guide it through multi-step tasks like proposal creation, where it gathers data from diverse sources using its orchestrator and predefined logic. The gathered information is then presented to the language model, temporarily enriching its knowledge to generate an informed response. Note that the contextual information provided to the LLM remains separate and is never used in its training.
-And, of course, Copilot for Sales follows Microsoft’s documented practices for responsible AI. All services are designed to meet regulations required in your country, region, and industry, in the same way that other Microsoft Cloud services do. When you use Copilot for Sales, it includes integrated scenarios with Microsoft 365 and your CRM out of the box.
-That said, to connect to data from external systems, you’ll use Copilot extensions. Let me first show you how you’d create one with zero code from Copilot Studio, using Copilot actions to build a custom AI experience using your external data. Now, remember the email summary we showed you before? I’m going to show you how we extended that experience. For that, I need to head over to Copilot Studio to hook into our customer intelligence application. To get to Copilot Studio, you can navigate to copilotstudio.microsoft.com.
-Next, I’ll expand the left menu and move to Copilot for Sales. I’ll add an action. From there, I’ll select my connector, which is a Copilot extension type for my customer intelligence application. I’ll paste in the action name and description. In this case, the extension exposes related marketing data as well as public data, including news and events associated to key customers. This description is important because Copilot for Sales will use it to figure out when to invoke this action.
-Next, I’ll choose from the connector’s available actions to pull the right insights from our email summary with get engagement insights. I can add an action name, then a description for what it does. Again, this description is important because it is used by the AI as the instructions for what to do.
-Here, we are saying to look into our Contoso Customer Intelligence data set for insights related to an email in Outlook. To save some time, I’ll skip a few of the options and optional steps here. I can repeat this process if I want to add additional actions. You can then optionally add conversation starters, which are suggested prompts, but in this case, to save a little time, I’ll skip this.
-From here, I can test it out to make sure everything is working as expected. I’ll enter a test prompt, and make sure it responds as expected, and even dig into more details about the logic and information connected with our extension. Everything looks good. And optionally, I can also test this out in microsoft365.com or Outlook. Now, I can finalize and publish it. You can do that from the add connector action experience in the manage tab in Copilot Studio.
-I’ll continue in the wizard, and to save time, I’ve added the icon images and background color already, as well as who has permissions to use it. So I just need to hit skip and publish, and everything is published in Copilot for Sales. And there’s one more thing to do to get it working in Copilot for Microsoft 365. From the new actions tab, I’ll hit publish, and then I’ll choose Copilot for Microsoft 365. And from there, I can publish it so that it’s available in both Copilot experiences.
-And by the way, if you’re an ISV or partner building Copilot actions, the same process applies. Plus, you can get your solutions certified using the Microsoft Partner Center, and make them discoverable by organizations in the Microsoft 365 admin center. So that was a quick tour of how Copilot for Sales can optimize the sales process using generative AI, the mechanics of how it works, and how to build Copilot extensions to connect with other systems for even more personalized experiences.
-For more information, check out aka.ms/CopilotforSalesExtensibility. And to stay up to date on monthly releases, check out aka.ms/CopilotforSalesUpdates. Keep watching Microsoft Mechanics for all the latest AI updates, and thanks for watching.
Microsoft Tech Community – Latest Blogs –Read More
Email Notification for failed Scheduled Pipleline runs on azure devops for Specific Env CD BUild
Hello All,
I have a pipeline running to do a certain task and when the pipeline fails I get an email stating the build failed. However, I’m also scheduling this pipeline to run at 1am every day only for XX Env CD build in this case even if the build fails I don’t get any notification email at all.
I need to set up extra alert to get notified to my email if my schuduled build fails at Env Level.
referd this but here I can do any Custome to have aaddition filter for My Env:https://learn.microsoft.com/en-us/azure/devops/organizations/notifications/manage-your-personal-notifications?view=azure-devops
Thank you.
Hello All, I have a pipeline running to do a certain task and when the pipeline fails I get an email stating the build failed. However, I’m also scheduling this pipeline to run at 1am every day only for XX Env CD build in this case even if the build fails I don’t get any notification email at all.I need to set up extra alert to get notified to my email if my schuduled build fails at Env Level. referd this but here I can do any Custome to have aaddition filter for My Env:https://learn.microsoft.com/en-us/azure/devops/organizations/notifications/manage-your-personal-notifications?view=azure-devops Thank you. Read More
Getting Error : 400 Bad Request and invalidRequest While creating OneDrive Documents versions Graph
Here going to create versions (version history) of a document using this type of curl
POST /v1.0/drives/{drive-id}/items/{item-id}/versions
Content-Type: application/json
{
“content”: {
“@odata.type”: “#microsoft.graph.fileContent”,
“sourceUrl”: “data:text/plain;base64,SGVsbG8gV29ybGQhCg==”
}
}
but in the response I am getting following error:
{
“error”: {
“code”: “invalidRequest”,
“message”: “Invalid request”,
“innerError”: {
“date”: “2024-05-29T20:10:45”,
“request-id”: “c1899a5f-e6d6-445d-b563-efb03268175c”,
“client-request-id”: “c1899a5f-e6d6-445d-b563-efb03268175c”
}
}
}
What am I doing wrong? Is there any other Microsoft Graph API or method for creating documents versions.
In the response I expect ‘Created’ or 201 code, that means a new version of file or document added in version history. Please help me to resolve this error. Thanks in Advance !
Here going to create versions (version history) of a document using this type of curlPOST /v1.0/drives/{drive-id}/items/{item-id}/versions
Content-Type: application/json
{
“content”: {
“@odata.type”: “#microsoft.graph.fileContent”,
“sourceUrl”: “data:text/plain;base64,SGVsbG8gV29ybGQhCg==”
}
}but in the response I am getting following error:{
“error”: {
“code”: “invalidRequest”,
“message”: “Invalid request”,
“innerError”: {
“date”: “2024-05-29T20:10:45”,
“request-id”: “c1899a5f-e6d6-445d-b563-efb03268175c”,
“client-request-id”: “c1899a5f-e6d6-445d-b563-efb03268175c”
}
}
}What am I doing wrong? Is there any other Microsoft Graph API or method for creating documents versions.In the response I expect ‘Created’ or 201 code, that means a new version of file or document added in version history. Please help me to resolve this error. Thanks in Advance ! Read More
Going to be out of touch for a while
My Wife is very sick and just got her out of the hospital so going to be very busy taking care of her needs until I can get her back up on her feet. Keep up the great Job and God Bless you All!
My Wife is very sick and just got her out of the hospital so going to be very busy taking care of her needs until I can get her back up on her feet. Keep up the great Job and God Bless you All! Read More
Deleting and or Consolidating Date info for Pivot Tables
Folks,
I am a little new to excel’s data processing features. I’ve done all the basic stuff for years, but I am diving in deeper. I am having trouble with correlating data streams from multiple sources that have specific time stamps. I need to utilize the date and hour times with the associated data, but I can’t figure out how to correlate this between multiple data streams. I am having trouble trying to associate the time values between different data streams. I am sure there is a way to do this. Each data stream has a unique time stamp with DATE HH:MM:SS. I need to match up the dates and hours on the different streams. I want to plot multiple data streams on one graph or interactive pivot table. I can’t figure out how to get excel to ignore minutes and seconds between readings and incorporate it together. I really just want one hourly reading instead of the 6 reading every ten-ish minutes.
For Example. I have this record. My other records are a few seconds or minutes off. Some data missing for hours or days. I cannot figure out how to correlate this sort of data together. Any advice would be appreciated.
TimeLevel Sensor 1 [ft]Temperature Sensor 2 [°F]2024-05-08T09:05:58.800-07:00 2024-05-08T13:09:23.000-07:000322024-05-08T13:24:03.000-07:0012.532.92024-05-08T13:34:02.000-07:0011.8 2024-05-08T13:44:02.000-07:0011.2 2024-05-08T13:54:02.000-07:0010.5 2024-05-08T14:04:01.000-07:0010.5 2024-05-08T14:14:01.000-07:0010.2 2024-05-08T14:24:01.000-07:0010.2 2024-05-08T14:34:01.000-07:009.8 2024-05-08T14:35:16.000-07:009.8 2024-05-08T14:45:57.000-07:009.8 2024-05-08T14:55:56.000-07:009.8 2024-05-08T15:05:56.000-07:009.5 2024-05-08T15:15:57.000-07:009.5 2024-05-08T15:25:56.000-07:009.5 2024-05-08T15:35:56.000-07:009.5 2024-05-08T15:45:56.000-07:009.5 2024-05-08T15:55:55.000-07:009.5 2024-05-08T16:05:55.000-07:009.2 2024-05-08T16:15:55.000-07:009.5 2024-05-08T16:25:54.000-07:009.2 2024-05-08T16:35:54.000-07:0017.1 2024-05-08T16:45:53.000-07:008.9 2024-05-08T16:55:53.000-07:009.2 2024-05-08T17:05:54.000-07:009.2 2024-05-08T17:15:53.000-07:009.5 2024-05-08T17:25:53.000-07:009.5 2024-05-08T17:35:53.000-07:009.5 2024-05-08T17:45:52.000-07:009.5 2024-05-08T17:55:52.000-07:009.5 2024-05-08T18:05:52.000-07:009.5 2024-05-08T18:15:51.000-07:009.5 2024-05-08T18:25:51.000-07:009.5 2024-05-08T18:35:51.000-07:009.5 2024-05-08T18:45:50.000-07:009.5 2024-05-08T18:55:50.000-07:009.5 2024-05-08T19:05:51.000-07:009.5 2024-05-08T19:15:50.000-07:009.5 2024-05-08T19:25:50.000-07:009.5 2024-05-08T19:35:51.000-07:009.2 2024-05-08T19:45:49.000-07:009.5 2024-05-08T19:56:50.000-07:009.2 2024-05-08T20:06:49.000-07:009.2 2024-05-08T20:16:48.000-07:009.2 2024-05-08T20:26:48.000-07:009.2 2024-05-08T20:36:48.000-07:009.2 2024-05-08T20:46:48.000-07:009.2 2024-05-08T20:56:47.000-07:009.2 2024-05-08T21:06:49.000-07:009.2 2024-05-08T21:16:50.000-07:009.2 2024-05-08T21:26:47.000-07:009.2 2024-05-08T21:36:47.000-07:009.2 2024-05-08T21:46:47.000-07:009.2 2024-05-08T21:56:46.000-07:009.2 2024-05-08T22:06:46.000-07:009.2 2024-05-08T22:16:46.000-07:008.9 2024-05-08T22:26:45.000-07:008.9 2024-05-08T22:36:45.000-07:009.2 2024-05-08T22:46:45.000-07:008.9 2024-05-08T22:56:44.000-07:009.2 2024-05-08T23:06:45.000-07:008.9 2024-05-08T23:16:45.000-07:008.9 2024-05-08T23:26:45.000-07:008.9 2024-05-08T23:36:44.000-07:008.9 2024-05-08T23:46:44.000-07:008.9 2024-05-08T23:56:44.000-07:008.9 2024-05-09T00:06:43.000-07:008.9 2024-05-09T00:16:43.000-07:008.9 2024-05-09T00:26:43.000-07:008.9 2024-05-09T00:36:42.000-07:008.9 2024-05-09T00:46:42.000-07:008.9 2024-05-09T00:56:42.000-07:008.9 2024-05-09T01:06:42.000-07:008.9 2024-05-09T01:16:42.000-07:008.9 2024-05-09T01:26:42.000-07:008.9 2024-05-09T01:36:40.000-07:008.9 2024-05-09T01:46:39.000-07:008.9 2024-05-09T01:56:39.000-07:008.5 2024-05-09T02:06:41.000-07:008.5
I am struggling with getting this in a format that I can associate with other similar data.
Please let me know if you have any tips.
Thank You,
Ben
Folks, I am a little new to excel’s data processing features. I’ve done all the basic stuff for years, but I am diving in deeper. I am having trouble with correlating data streams from multiple sources that have specific time stamps. I need to utilize the date and hour times with the associated data, but I can’t figure out how to correlate this between multiple data streams. I am having trouble trying to associate the time values between different data streams. I am sure there is a way to do this. Each data stream has a unique time stamp with DATE HH:MM:SS. I need to match up the dates and hours on the different streams. I want to plot multiple data streams on one graph or interactive pivot table. I can’t figure out how to get excel to ignore minutes and seconds between readings and incorporate it together. I really just want one hourly reading instead of the 6 reading every ten-ish minutes. For Example. I have this record. My other records are a few seconds or minutes off. Some data missing for hours or days. I cannot figure out how to correlate this sort of data together. Any advice would be appreciated. TimeLevel Sensor 1 [ft]Temperature Sensor 2 [°F]2024-05-08T09:05:58.800-07:00 2024-05-08T13:09:23.000-07:000322024-05-08T13:24:03.000-07:0012.532.92024-05-08T13:34:02.000-07:0011.8 2024-05-08T13:44:02.000-07:0011.2 2024-05-08T13:54:02.000-07:0010.5 2024-05-08T14:04:01.000-07:0010.5 2024-05-08T14:14:01.000-07:0010.2 2024-05-08T14:24:01.000-07:0010.2 2024-05-08T14:34:01.000-07:009.8 2024-05-08T14:35:16.000-07:009.8 2024-05-08T14:45:57.000-07:009.8 2024-05-08T14:55:56.000-07:009.8 2024-05-08T15:05:56.000-07:009.5 2024-05-08T15:15:57.000-07:009.5 2024-05-08T15:25:56.000-07:009.5 2024-05-08T15:35:56.000-07:009.5 2024-05-08T15:45:56.000-07:009.5 2024-05-08T15:55:55.000-07:009.5 2024-05-08T16:05:55.000-07:009.2 2024-05-08T16:15:55.000-07:009.5 2024-05-08T16:25:54.000-07:009.2 2024-05-08T16:35:54.000-07:0017.1 2024-05-08T16:45:53.000-07:008.9 2024-05-08T16:55:53.000-07:009.2 2024-05-08T17:05:54.000-07:009.2 2024-05-08T17:15:53.000-07:009.5 2024-05-08T17:25:53.000-07:009.5 2024-05-08T17:35:53.000-07:009.5 2024-05-08T17:45:52.000-07:009.5 2024-05-08T17:55:52.000-07:009.5 2024-05-08T18:05:52.000-07:009.5 2024-05-08T18:15:51.000-07:009.5 2024-05-08T18:25:51.000-07:009.5 2024-05-08T18:35:51.000-07:009.5 2024-05-08T18:45:50.000-07:009.5 2024-05-08T18:55:50.000-07:009.5 2024-05-08T19:05:51.000-07:009.5 2024-05-08T19:15:50.000-07:009.5 2024-05-08T19:25:50.000-07:009.5 2024-05-08T19:35:51.000-07:009.2 2024-05-08T19:45:49.000-07:009.5 2024-05-08T19:56:50.000-07:009.2 2024-05-08T20:06:49.000-07:009.2 2024-05-08T20:16:48.000-07:009.2 2024-05-08T20:26:48.000-07:009.2 2024-05-08T20:36:48.000-07:009.2 2024-05-08T20:46:48.000-07:009.2 2024-05-08T20:56:47.000-07:009.2 2024-05-08T21:06:49.000-07:009.2 2024-05-08T21:16:50.000-07:009.2 2024-05-08T21:26:47.000-07:009.2 2024-05-08T21:36:47.000-07:009.2 2024-05-08T21:46:47.000-07:009.2 2024-05-08T21:56:46.000-07:009.2 2024-05-08T22:06:46.000-07:009.2 2024-05-08T22:16:46.000-07:008.9 2024-05-08T22:26:45.000-07:008.9 2024-05-08T22:36:45.000-07:009.2 2024-05-08T22:46:45.000-07:008.9 2024-05-08T22:56:44.000-07:009.2 2024-05-08T23:06:45.000-07:008.9 2024-05-08T23:16:45.000-07:008.9 2024-05-08T23:26:45.000-07:008.9 2024-05-08T23:36:44.000-07:008.9 2024-05-08T23:46:44.000-07:008.9 2024-05-08T23:56:44.000-07:008.9 2024-05-09T00:06:43.000-07:008.9 2024-05-09T00:16:43.000-07:008.9 2024-05-09T00:26:43.000-07:008.9 2024-05-09T00:36:42.000-07:008.9 2024-05-09T00:46:42.000-07:008.9 2024-05-09T00:56:42.000-07:008.9 2024-05-09T01:06:42.000-07:008.9 2024-05-09T01:16:42.000-07:008.9 2024-05-09T01:26:42.000-07:008.9 2024-05-09T01:36:40.000-07:008.9 2024-05-09T01:46:39.000-07:008.9 2024-05-09T01:56:39.000-07:008.5 2024-05-09T02:06:41.000-07:008.5 I am struggling with getting this in a format that I can associate with other similar data. Please let me know if you have any tips. Thank You,Ben Read More
Use Word Template Content in Print to Size 10 Envelope
I have been trying to configure content to print on lower/center of a
size 10 envelope.
The envelopes are loaded in the manual feeder tray as shown below.
I am using Power Automate to collect data from an Excel
document and placing it in the below Word Template
document, where there are several mail merge fields
(see below).
I am using Power Automate to place each address into a
Word file. I am PA to convert the Word file to PDF. I then
use PA to merge each Word files into a single PDF file
(see below).
I have yet to be able to figure out how to set the printer
setting to sitution the content from the merged PDF file
so that is prints onto the size 10 envelope in the lower/center.
What am I missing?
I have been trying to configure content to print on lower/center of asize 10 envelope.The envelopes are loaded in the manual feeder tray as shown below.I am using Power Automate to collect data from an Exceldocument and placing it in the below Word Templatedocument, where there are several mail merge fields(see below).I am using Power Automate to place each address into aWord file. I am PA to convert the Word file to PDF. I thenuse PA to merge each Word files into a single PDF file(see below). I have yet to be able to figure out how to set the printersetting to sitution the content from the merged PDF fileso that is prints onto the size 10 envelope in the lower/center.What am I missing? Read More
Attack Simulation Training in Chinese showing as garbled character
Hi All,
We recently moved to a new mail security gateway and initiated an attack simulation training from Microsoft. The scenario include 2 recipient; one from exchange online(EXO) and the other is exchange 2019 mailbox(OP).
OP mail flow will go through mail security gateway before delivering to enduser while EXO go through EOP. Thing is using same payload and simulation, email to OP user always show as garbled and the link inside will contain a space which break the link. Meanwhile email to EXO works just fine.
I believe it has something to do with the encoding, does anyone come around this issue before?
Thanks Y’all
Hi All, We recently moved to a new mail security gateway and initiated an attack simulation training from Microsoft. The scenario include 2 recipient; one from exchange online(EXO) and the other is exchange 2019 mailbox(OP). OP mail flow will go through mail security gateway before delivering to enduser while EXO go through EOP. Thing is using same payload and simulation, email to OP user always show as garbled and the link inside will contain a space which break the link. Meanwhile email to EXO works just fine. I believe it has something to do with the encoding, does anyone come around this issue before? Thanks Y’all Read More
Dev Channel update to 127.0.2610.3 is live.
Hello Insiders! We released 127.0.2610.3 to the Dev channel! This includes numerous fixes. For more details on the changes, check out the highlights below.
Introducing Copilot+ PCs – The Official Microsoft Blog
Microsoft Edge for Business: Secure, productive, optimized for AI – YouTube
Added Features:
Implemented a feature to include an icon accompanied by a tooltip to clarify why certain settings are inaccessible.
Improved Reliability:
Fixed a browser crash on android.
Resolved an issue when clicking the ‘Organize tabs’ button under tabs action menu caused browser to crash.
Fixed an issue causing the browser to crash upon clicking the ‘Switch’ button while awaiting the URL to load.
Resolved a bug that led to the browser crashing when closed while captions were running.
Resolved a bug that led to the browser crashing when duplicating the last tab in the tab strip through the tab group menu.
Changed Behavior:
Resolved a problem where the tooltip for the tab group header was appearing over the hover menu.
Resolved an issue that caused the extension’s updated details to display incorrectly on the detail page.
Resolved an issue when dragging a tab group containing the active tab and dropping it onto another group resulted in multiple tabs being added to the group.
Fixed an issue that resulted in insufficient spacing between tabs and other buttons.
Fixed an issue where the mouse gesture would close the entire tab instead of just the split-screen tab.
Fixed an issue where the New Tab Button at the bottom of the vertical tabs view was not aligned correctly with the other items.
Mac: Resolved an issue that resulted in the ‘alt’ attribute being incorrectly shown on macOS.
iOS: Fixed an issue that caused a disruption in the full-page user interface, where a gap appeared between the QR code and chat content on iOS.
Android:
Resolved a problem that caused the toolbar to vanish when altering the display mode on android.
Fixed an issue where selecting ‘Delete browsing data’ would navigate back to the previous page.
See an issue that you think might be a bug? Remember to send that directly through the in-app feedback by heading to the … menu > Help and feedback > Send feedback and include diagnostics so the team can investigate.
Thanks again for sending us feedback and helping us improve our Insider builds.
~Gouri
Hello Insiders! We released 127.0.2610.3 to the Dev channel! This includes numerous fixes. For more details on the changes, check out the highlights below.
Introducing Copilot+ PCs – The Official Microsoft Blog
Microsoft Edge for Business: Secure, productive, optimized for AI – YouTube
Added Features:
Implemented a feature to include an icon accompanied by a tooltip to clarify why certain settings are inaccessible.
Improved Reliability:
Fixed a browser crash on android.
Resolved an issue when clicking the ‘Organize tabs’ button under tabs action menu caused browser to crash.
Fixed an issue causing the browser to crash upon clicking the ‘Switch’ button while awaiting the URL to load.
Resolved a bug that led to the browser crashing when closed while captions were running.
Resolved a bug that led to the browser crashing when duplicating the last tab in the tab strip through the tab group menu.
Changed Behavior:
Resolved a problem where the tooltip for the tab group header was appearing over the hover menu.
Resolved an issue that caused the extension’s updated details to display incorrectly on the detail page.
Resolved an issue when dragging a tab group containing the active tab and dropping it onto another group resulted in multiple tabs being added to the group.
Fixed an issue that resulted in insufficient spacing between tabs and other buttons.
Fixed an issue where the mouse gesture would close the entire tab instead of just the split-screen tab.
Fixed an issue where the New Tab Button at the bottom of the vertical tabs view was not aligned correctly with the other items.
Mac: Resolved an issue that resulted in the ‘alt’ attribute being incorrectly shown on macOS.
iOS: Fixed an issue that caused a disruption in the full-page user interface, where a gap appeared between the QR code and chat content on iOS.
Android:
Resolved a problem that caused the toolbar to vanish when altering the display mode on android.
Fixed an issue where selecting ‘Delete browsing data’ would navigate back to the previous page.
See an issue that you think might be a bug? Remember to send that directly through the in-app feedback by heading to the … menu > Help and feedback > Send feedback and include diagnostics so the team can investigate.
Thanks again for sending us feedback and helping us improve our Insider builds.
~Gouri Read More
Teams Adoption Collateral
Hi all!
I know I’ve seen some good Teams Adoption resources in the Champions community before but I can’t locate them. I have a colleague whose company is transitioning to Teams (from Zoom) and is looking for any helpful resources we can share. Appreciate your help!
Hi all! I know I’ve seen some good Teams Adoption resources in the Champions community before but I can’t locate them. I have a colleague whose company is transitioning to Teams (from Zoom) and is looking for any helpful resources we can share. Appreciate your help! Read More
Excel conditional formatting
Hi all!
Im having a tough time figuring this one out. I usually use conditional formatting to find unique entries between two columns, however I now need them to be date specific. I want it to flag if it is unique per day.
I am reconciling between what we have on the books and what our statement says and there are some common charges that I don’t want being considered duplicate unless there was a charge for that on the same date as our records indicate.
thoughts?
Hi all!Im having a tough time figuring this one out. I usually use conditional formatting to find unique entries between two columns, however I now need them to be date specific. I want it to flag if it is unique per day. I am reconciling between what we have on the books and what our statement says and there are some common charges that I don’t want being considered duplicate unless there was a charge for that on the same date as our records indicate. thoughts? Read More
Windows server 2025 public preview 26100 versus preview build 26227
I was under the impression that a public preview was almost as good as an RTM. Now I am seeing a new preview build that supersedes the public preview? I am on the public preview. Will it automatically update to these new preview builds?
I was under the impression that a public preview was almost as good as an RTM. Now I am seeing a new preview build that supersedes the public preview? I am on the public preview. Will it automatically update to these new preview builds? Read More
Azure AI Search Database Selection: Optimizing Performance and Scalability for Your Business
In today’s data-driven world, selecting the right database for your specific use case is crucial for optimizing performance, ensuring scalability, and maintaining security. Azure AI Search, combined with Azure OpenAI and the Retrieval Augmented Generation (RAG) pattern, provides a powerful framework for building advanced generative AI applications. These solutions are tailored to meet diverse needs across different industries. In this blog, we’ll explore the use cases for various databases available through Azure AI Search and highlight their applications in real-world scenarios across different verticals such as nonprofits, healthcare, financial services, retail, automotive, and more.
Decision-Making Flowchart
To assist in selecting the most suitable database for your specific needs, refer to the Database Selection Flowchart below. This guide helps determine the optimal database solution provided by Azure AI Search based on your unique use case requirements, particularly in the context of RAG applications supported by Azure OpenAI.
Decision Points
To effectively manage diverse data types and meet varying organizational needs, Azure AI Search provides a range of database solutions. Each database type is tailored to specific use cases, ensuring optimal performance, scalability, and security. The decision points below will guide you in selecting the most suitable database for your needs based on your data structure, access patterns, and application requirements.
Simple, Scalable Storage for Unstructured Data
Azure Storage Accounts: Ideal for cost-effective storage of unstructured data. Nonprofits and conservation organizations, for instance, often deal with vast amounts of documents and media files that need scalable and economical storage solutions. Azure Storage Accounts provide a reliable way to store and access these files, supporting the efficient management of data without breaking the budget.
Relational Database with Built-in Intelligence, Scalability, and Security
Azure SQL Database: A fully managed relational database with built-in intelligence, scalability, and security features. This is particularly useful for financial services that require robust security and compliance, as well as healthcare organizations managing patient records and clinical data. Azure SQL Database ensures that data is stored securely and can be scaled according to the organization’s needs, offering automated backups, threat detection, and other advanced features to maintain data integrity and security.
Highly Structured and Fixed Schema with Strong Transactional Consistency
PostgreSQL: Suitable for applications requiring strong transactional consistency and data integrity, such as financial applications, healthcare records, and any other use case where data accuracy and reliability are paramount. PostgreSQL is known for its robust transactional support, ensuring that data modifications are handled reliably and consistently, which is crucial for applications that need to maintain strict data accuracy.
Flexible Schema and Handle Large Volumes, High Availability, Global Distribution
Cosmos DB: Best for real-time analytics, IoT, and e-commerce applications needing rapid data access and global distribution. Retail and automotive industries can benefit from Cosmos DB for managing inventory, tracking products, and processing large volumes of data from connected devices. Cosmos DB supports multiple data models, offers low-latency access to data, and ensures high availability, making it an excellent choice for applications requiring flexible and scalable data management.
Complex Queries with Data Relationships
Cosmos DB for MongoDB vCore: Perfect for content management systems and document databases requiring complex queries and dynamic schemas. Organizations in sectors like publishing, media, and content management can leverage this to handle complex relationships between different data types. Cosmos DB for MongoDB vCore provides the ability to perform sophisticated queries on data, supporting applications that need to manage and retrieve interrelated data efficiently.
High-Speed Data Access
Redis: Optimal for caching, session storage, and real-time analytics needing quick data retrieval and processing. Retailers can use Redis to manage customer sessions and provide real-time recommendations, while automotive companies can leverage it for real-time vehicle data processing. Redis is designed for high-performance data access, making it ideal for applications where speed is critical, such as real-time data analytics and dynamic user experiences.
This refined approach ensures that each database type is matched with its ideal use case, highlighting the strengths and capabilities that make Azure AI Search a powerful tool for diverse industry needs.
Additional Features
Vector Search Integration: Enhances search relevance using embeddings for advanced AI applications (learn more about vector search).
Hybrid Search: Combines keyword and vector search for comprehensive results.
Integration with Azure Services: Leverage Azure Blob Storage, Azure SQL, and Cosmos DB for better data processing and indexing.
Security and Compliance: Ensure adherence to data protection standards.
Real-World Use Cases by Industry
To illustrate the practical applications and benefits of Azure AI Search across different sectors, let’s explore specific use cases in various industries. By leveraging the diverse database solutions provided by Azure AI Search and Azure OpenAI, organizations can enhance their data management strategies, ensuring optimal performance, scalability, and security.
Nonprofits
Nonprofits, such as foundations and conservation organizations, often manage vast amounts of unstructured data, including documents, images, videos, and Geographic Information Systems (GIS) data. Azure Storage Accounts provide a scalable and cost-effective solution for storing this diverse data securely. These organizations can use Cosmos DB for global data distribution, ensuring critical information is accessible to stakeholders worldwide, enhancing collaboration and operational efficiency.
For managing GIS data, Azure SQL Database can handle spatial data, perform complex geospatial queries, and integrate with various mapping tools, enabling nonprofits to make data-driven decisions for environmental conservation or urban planning. Additionally, Azure AI Search can be utilized to index and search across all this data, providing powerful search capabilities that help users quickly find the information they need, whether it’s text, images, or GIS data. This capability can significantly improve data accessibility and utilization in various nonprofit projects and initiatives.
Healthcare
Healthcare applications require robust databases to handle structured data with high transactional consistency and integrity. Azure SQL Database and PostgreSQL are ideal for managing patient records, clinical data, and ensuring compliance with stringent health regulations. Azure AI Search enhances the organization and retrieval of this critical data, allowing healthcare providers to quickly access and analyze patient information, thus improving patient care and operational efficiency. AI-powered search capabilities can help in identifying patterns, supporting diagnostics, and personalizing patient care.
Financial Services
In the financial sector, data accuracy and reliability are paramount. PostgreSQL is often chosen for its strong transactional consistency and data integrity, making it suitable for managing sensitive financial data and transactions. Azure SQL Database offers robust security features, ensuring compliance with financial regulations and protecting against data breaches. Financial institutions can leverage Azure AI Search to process transactions efficiently, support complex financial models, and provide real-time data analytics, enhancing decision-making and operational performance.
Retail
Retailers leverage Cosmos DB to manage large volumes of data, ensuring high availability and global distribution. This flexibility allows for efficient inventory management, real-time analytics, and personalized customer experiences. Azure AI Search capabilities enable retailers to quickly retrieve relevant data, improving the shopping experience by offering personalized product suggestions based on customer behavior and preferences. Redis is used to manage customer sessions and provide real-time recommendations, ensuring a seamless and engaging shopping experience.
Automotive
The automotive industry benefits from Cosmos DB’s ability to handle large volumes of IoT data from connected vehicles. Real-time data processing is crucial for vehicle telematics, predictive maintenance, and autonomous driving technologies. Automotive companies can use Cosmos DB to store and analyze data from sensors in vehicles, enabling real-time diagnostics and proactive maintenance alerts. Azure AI Search enhances these capabilities by enabling quick retrieval and analysis of vast amounts of data. Redis can be used for real-time data caching and quick retrieval, supporting applications that require immediate access to vehicle data, such as navigation systems and driver assistance features.
Conclusion
Azure AI Search, combined with Azure OpenAI and the RAG pattern, offers a comprehensive suite of database solutions tailored to meet the diverse needs of various industries. By leveraging the Database Selection Flowchart and understanding the specific use cases of each database, organizations can optimize their data management strategies to achieve better performance, scalability, and security. With additional features like vector search integration (learn more about vector search), hybrid search, and seamless integration with Azure services, Azure AI Search stands out as a powerful tool for modern data-driven applications. Whether you’re in healthcare, financial services, retail, automotive, or a nonprofit organization, Azure AI Search has the right database solution to support your data needs and drive your digital transformation forward.
For more information about Azure AI Search and its latest features, visit the Microsoft Learn and Microsoft Tech Community.
If you have any questions or need further assistance in selecting the right database for your use case, feel free to reach out to us. We’re here to help you make the best decision for your data needs.
Microsoft Tech Community – Latest Blogs –Read More
Copilot cannot access OneDrive for Business files
I asked Copilot to look for files related to a client project. The files are saved to my OneDrive for Business account, which is part of my Office 365 E3 subscription.
Copilot returned the following error:
To give me access to your OneDrive folders, you would typically share the folder with my email address or provide a shareable link that I can access. However, as Microsoft 365 Copilot, I don’t have the capability to access personal OneDrive folders or files directly. My functionality is limited to providing assistance based on the information available to me through the search results and the capabilities I have within this chat.
If you need help with organizing or finding information within your OneDrive, I can guide you on how to use the search and organization features of OneDrive. Let me know how I can assist you further!
Additional Information:
In my 365 Admin Panel, Copilot has been given all permissions.Copilot now seems to be able to search my emails, so that’s an improvement.
This is extremely frustrating.
How do I set up my account so that Copilot can access everything across my 365 ecosystem?
I asked Copilot to look for files related to a client project. The files are saved to my OneDrive for Business account, which is part of my Office 365 E3 subscription. Copilot returned the following error:To give me access to your OneDrive folders, you would typically share the folder with my email address or provide a shareable link that I can access. However, as Microsoft 365 Copilot, I don’t have the capability to access personal OneDrive folders or files directly. My functionality is limited to providing assistance based on the information available to me through the search results and the capabilities I have within this chat.If you need help with organizing or finding information within your OneDrive, I can guide you on how to use the search and organization features of OneDrive. Let me know how I can assist you further! Additional Information:In my 365 Admin Panel, Copilot has been given all permissions.Copilot now seems to be able to search my emails, so that’s an improvement.This is extremely frustrating. How do I set up my account so that Copilot can access everything across my 365 ecosystem? Read More
Could you help with deleting a resource in the Storage Account ?
Hello,
Could you please help me on how to delete a resource in my Storage Account? I tried to delete the selecting resource in the Storage Account but it keeps saying that I have a resource block.
I don’t know how to unlock the resource in order to delete it. Could you help?
Below is the selected resource that I tried to delete.
Hello, Could you please help me on how to delete a resource in my Storage Account? I tried to delete the selecting resource in the Storage Account but it keeps saying that I have a resource block.I don’t know how to unlock the resource in order to delete it. Could you help?Below is the selected resource that I tried to delete. Read More
Formula
I have a drop down menu in a spreadsheet for frequency. I’m trying to calculate for the 3rd Wednesday of the month bc that’s when I receive a certain income. How would I go about this?!
I have a drop down menu in a spreadsheet for frequency. I’m trying to calculate for the 3rd Wednesday of the month bc that’s when I receive a certain income. How would I go about this?! Read More