Category: Microsoft
Category Archives: Microsoft
Outlook Web apps not showing up
I am on the outlook website and the apps are not showing up when I go to the add apps page.
My add-ins have also disapeared that I have been using for months. I have tried reinstalling but nothing happens.
It seems to be on just this account.
I am on the outlook website and the apps are not showing up when I go to the add apps page.My add-ins have also disapeared that I have been using for months. I have tried reinstalling but nothing happens. It seems to be on just this account. Read More
Removing the MS Sign-On from Startup: A Step-by-Step Guide
I am currently the sole user of this computer, and I accidentally entered an email address which now prompts me for a password every time the system starts up. How can I disable this login requirement so that I only need to press Enter or the space bar to access my computer?
Thank you for your assistance in resolving this issue.
I am currently the sole user of this computer, and I accidentally entered an email address which now prompts me for a password every time the system starts up. How can I disable this login requirement so that I only need to press Enter or the space bar to access my computer? Thank you for your assistance in resolving this issue. Read More
Followup sheet – Macro
Hello everyone,
After days of failing, I have come here to ask for your help gurus please!!
I am working on a VBA project in Excel that involves three main tabs:
Mailing: This tab contains a table with client names and emails. I have a button that allows sending emails to all clients listed in the table. This part is working perfectly!!!.
Followup: In this tab, I want to retrieve the 100 most recent emails from my inbox and fill them into a table. The goal is to read these emails and compare them with the emails sent from the “Mailing” tab to check if I have received responses from my clients.
Inbox: This tab serves as a database where the 100 most recent emails are stored. This is working as well!!
What I need:
WORKING – Retrieve the 100 most recent emails: I need help writing a VBA code that retrieves the 100 most recent emails from my Outlook inbox and fills the “Inbox Emails” tab.NOT WORKING – Compare and update status: After filling the “Inbox Emails” tab, I need the VBA to read each of the 100 emails and compare them with the emails sent listed in the “Mailing” tab. If there is a response from a client, the status should be updated to “New Answer”. If there is no response, the status should be “Waiting”.
I appreciate any help in advance and am available to clarify any questions. Please reach to me in any platform!
Hello everyone,After days of failing, I have come here to ask for your help gurus please!! I am working on a VBA project in Excel that involves three main tabs:Mailing: This tab contains a table with client names and emails. I have a button that allows sending emails to all clients listed in the table. This part is working perfectly!!!.Followup: In this tab, I want to retrieve the 100 most recent emails from my inbox and fill them into a table. The goal is to read these emails and compare them with the emails sent from the “Mailing” tab to check if I have received responses from my clients.Inbox: This tab serves as a database where the 100 most recent emails are stored. This is working as well!!What I need:WORKING – Retrieve the 100 most recent emails: I need help writing a VBA code that retrieves the 100 most recent emails from my Outlook inbox and fills the “Inbox Emails” tab.NOT WORKING – Compare and update status: After filling the “Inbox Emails” tab, I need the VBA to read each of the 100 emails and compare them with the emails sent listed in the “Mailing” tab. If there is a response from a client, the status should be updated to “New Answer”. If there is no response, the status should be “Waiting”.I appreciate any help in advance and am available to clarify any questions. Please reach to me in any platform! Read More
Adding a clarification question in Forms if a minimum score is returned
Hi we are in the process of moving some of our documents into forms. In one of them users are asked to score their abilities for a task between 1 and 10.
I would like to be able to ask a clarification if a responder answers 8, 9 or 10 to each response .
Is this possible? I cannot see in Branching how to determine what answer is given in order to a follow up question is required.
Hi we are in the process of moving some of our documents into forms. In one of them users are asked to score their abilities for a task between 1 and 10. I would like to be able to ask a clarification if a responder answers 8, 9 or 10 to each response . Is this possible? I cannot see in Branching how to determine what answer is given in order to a follow up question is required. Read More
MDE API to trigger custom detection rule run
Hi All,
We are deploying MDE custom detections to a new site via pipeline and some scripts using the API.
But since we are deploying and enabling the rules in groups, their last/next run are all the same in the group (especially for the ones with 12hrs/24hrs periods)
For now, only way I could find for changing the running start time is running the rule manually.
Is there a better way/API endpoint to run/change the periodic run time of the rules? If yes, with a script I can better disperse the rule periodic run times throughout the day.
Thanks in advance
Emin
Hi All, We are deploying MDE custom detections to a new site via pipeline and some scripts using the API. But since we are deploying and enabling the rules in groups, their last/next run are all the same in the group (especially for the ones with 12hrs/24hrs periods)For now, only way I could find for changing the running start time is running the rule manually. Is there a better way/API endpoint to run/change the periodic run time of the rules? If yes, with a script I can better disperse the rule periodic run times throughout the day. Thanks in advanceEmin Read More
Polls disappear when admitting external users to meeting
We are having trouble lately with polls within Teams webinars. As soon as the first external participant joins, the polls disappear. We put on many training webinars a month and rely on polling for interaction. Has anyone found a fix for this? Is it a known issue?
I found the below thread but it has more questions than answers:
We are having trouble lately with polls within Teams webinars. As soon as the first external participant joins, the polls disappear. We put on many training webinars a month and rely on polling for interaction. Has anyone found a fix for this? Is it a known issue?I found the below thread but it has more questions than answers:https://answers.microsoft.com/en-us/msteams/forum/all/teams-poll-option-getting-disappeared-during-the/d642ce2f-f772-4f41-8d69-f0835d2dd0d5https://answers.microsoft.com/en-us/msteams/forum/all/polls-disappearing-in-teams-live-webinar-as-soon/fea4f5c5-42ef-4fc2-9d96-0c3b1774b96a Read More
Fixing a Windows Boot Problem on a PC
Recently, my Samsung Galaxy Pro 360 underwent a significant software update. Following this update, my PC experienced a problematic boot sequence. Upon restarting, Windows would only partially load, displaying a limited taskbar and failing to proceed further. Despite the mouse functionality, the system would ultimately freeze, requiring a forced shutdown. This frustrating cycle persisted, with intermittent instances of Windows failing to load entirely and displaying the dreaded blue screen error message.
Before this update, my PC operated without any complications. To address the boot problem, I ran troubleshooting commands such as DISM and SFC /scannow, but to no avail. Seeking assistance from Samsung Support, I inquired about re-flashing the BIOS, only to be informed that it was not possible. This contrasted with my past experiences with Asus products, where I had successfully performed BIOS flashings independently. The support team’s proposed solution was to either reinstall Windows or consider purchasing a new laptop at a discounted rate.
In response to this conundrum, I have opted to acquire a new drive and will attempt to resolve the boot issue by implementing this hardware change. The underlying cause of this perplexing boot problem remains elusive, prompting further investigation into potential factors contributing to this ordeal.
Recently, my Samsung Galaxy Pro 360 underwent a significant software update. Following this update, my PC experienced a problematic boot sequence. Upon restarting, Windows would only partially load, displaying a limited taskbar and failing to proceed further. Despite the mouse functionality, the system would ultimately freeze, requiring a forced shutdown. This frustrating cycle persisted, with intermittent instances of Windows failing to load entirely and displaying the dreaded blue screen error message. Before this update, my PC operated without any complications. To address the boot problem, I ran troubleshooting commands such as DISM and SFC /scannow, but to no avail. Seeking assistance from Samsung Support, I inquired about re-flashing the BIOS, only to be informed that it was not possible. This contrasted with my past experiences with Asus products, where I had successfully performed BIOS flashings independently. The support team’s proposed solution was to either reinstall Windows or consider purchasing a new laptop at a discounted rate. In response to this conundrum, I have opted to acquire a new drive and will attempt to resolve the boot issue by implementing this hardware change. The underlying cause of this perplexing boot problem remains elusive, prompting further investigation into potential factors contributing to this ordeal. Read More
Troubleshooting: My Brand New Computer Won’t Start Up
I recently acquired a new computer without an operating system. Although I have two functional drives that successfully boot on my current Windows 10 and Windows 11 system, when I installed each drive separately in the new computer, they both failed to boot properly. The Windows loading screen appears, but then the process stalls.
I attempted creating a bootable USB using Windows, and also tried using an ISO file, but neither method worked. The BIOS recognizes all the drives and the USB drive.
Before attempting another boot, I also installed a graphics card. Would removing the graphics card make a difference in booting up successfully? Any assistance on this matter would be greatly appreciated. Thank you.
I recently acquired a new computer without an operating system. Although I have two functional drives that successfully boot on my current Windows 10 and Windows 11 system, when I installed each drive separately in the new computer, they both failed to boot properly. The Windows loading screen appears, but then the process stalls. I attempted creating a bootable USB using Windows, and also tried using an ISO file, but neither method worked. The BIOS recognizes all the drives and the USB drive. Before attempting another boot, I also installed a graphics card. Would removing the graphics card make a difference in booting up successfully? Any assistance on this matter would be greatly appreciated. Thank you. Read More
Video upload issue on teams chat
Teams has video upload bug on few last releases, please fix it
Unable to upload recording
Teams has video upload bug on few last releases, please fix itUnable to upload recording Read More
Ready, Set, AI: What our People Science research tells us about AI Readiness
On July 18, the Viva People Science team held the fourth webinar in its AI Empowerment series. During this webinar, I was joined by Carolyn Kalafut (Principal People Scientist at Microsoft Viva), Megan Benzing (Viva People Science Researcher) and Craig Ramsay (Viva People Science Researcher) who have been leading a research study into what it means to be ready for AI transformation as an organization.
We talked about the key insights that emerged from the research including:
AI and the employee experience being complementary to one another, and how a positive employee experience can help to drive successful AI transformation
How leaders and individual contributors are experiencing change differently, and the blind spots that leaders need to be aware of when planning an AI rollout strategy
How High Performing Organizations are taking a much more people-centric approach to change compared to typical organizations
The need to balance the excitement and hopes that employees have about AI with their concerns around data security, over-reliance on AI and job loss
The presenters wrapped up the session with some key principles for AI transformation based on their learnings from the research study. These included recognizing the scope of AI transformation and its impact, taking an agile approach and encouraging experimentation in teams, and taking a human approach to the change by leading with empathy and addressing concerns.
We invite you to watch the recording from this session, and those from our previous events in this series below. Discover more, engage with the content, and let’s embark on this journey together.
AI Empowerment: Introducing our Viva People-Science series for HR
AI Empowerment: Preparing your organization for AI with learnings from Microsoft
Microsoft Tech Community – Latest Blogs –Read More
Looking for a solution to automate inventory management of product accessories.
Hello Excel Community!
I’m looking for some sort of formula to be able to create an additional sheet within my current Excel Book to best track the inventory of the accessories we need to sell our items. This is the current set up of our doc, with a master list that I do not currently have access to, but a coworker does, that manages all of the Data Validation for columns C-H. Each drop down has a variety of values we use regularly to manage our intake and so we can find each item if/when our Access Database crashes multiple times a day.
Effectively, I’m looking for some way to track the quantities of the bags in column D in a separate sheet, as well as the potential for 1-2 more columns for hoods and/or batteries. This will free us up a substantial amount of time instead of having to count bags each week.
I’ve tried a few other solutions I’ve found on here with minimal luck. If I have to rebuild the entire thing from scratch to make something work, I definitely am up to doing that if it’s not possible with the current setup we run.
Thank you in advance for any help!
Hello Excel Community! I’m looking for some sort of formula to be able to create an additional sheet within my current Excel Book to best track the inventory of the accessories we need to sell our items. This is the current set up of our doc, with a master list that I do not currently have access to, but a coworker does, that manages all of the Data Validation for columns C-H. Each drop down has a variety of values we use regularly to manage our intake and so we can find each item if/when our Access Database crashes multiple times a day. Effectively, I’m looking for some way to track the quantities of the bags in column D in a separate sheet, as well as the potential for 1-2 more columns for hoods and/or batteries. This will free us up a substantial amount of time instead of having to count bags each week.I’ve tried a few other solutions I’ve found on here with minimal luck. If I have to rebuild the entire thing from scratch to make something work, I definitely am up to doing that if it’s not possible with the current setup we run. Thank you in advance for any help! Read More
New Outlook closes shortly after start
I’m trying to use the new outlook, but as soon as I open the application it closes and if I try to reopen it doesn’t work.
I’m trying to use the new outlook, but as soon as I open the application it closes and if I try to reopen it doesn’t work. Read More
Search in Viva Connections rapidly slowed down
Hi,
first of all, I’m not sure if I’m in the right place, so if not, i really apalogise if this does not belong here.
Our company helped one of our customers do deploy Viva Connections.
It mostly worked fine, but then one issue appeard. They have two cards there – Search for users and Search through intranet. What happened is that when anyone tries to search for anything, it takes between 20 and 30 seconds to load. It is supposed, and it was, load within 5 seconds or so.
I haven’t find what could cause the issue since it looks like that’s the only appear of this kind of an issue.
Have anyone seen anything like this?
Thank you
Hi,first of all, I’m not sure if I’m in the right place, so if not, i really apalogise if this does not belong here.Our company helped one of our customers do deploy Viva Connections. It mostly worked fine, but then one issue appeard. They have two cards there – Search for users and Search through intranet. What happened is that when anyone tries to search for anything, it takes between 20 and 30 seconds to load. It is supposed, and it was, load within 5 seconds or so.I haven’t find what could cause the issue since it looks like that’s the only appear of this kind of an issue.Have anyone seen anything like this? Thank you Read More
Remove page title from command bar
The title of the page started to appear in the Command Bar on our SharePoint communication sites a few days ago.
How can we remove this?
It looks bad for several reasons:
long titles get truncated due to lack of spaceit duplicates the browser tabit duplicates the main page heading which is just below
It’s not just editors who are seeing this: all users can see it.
The title of the page started to appear in the Command Bar on our SharePoint communication sites a few days ago. How can we remove this? It looks bad for several reasons:long titles get truncated due to lack of spaceit duplicates the browser tabit duplicates the main page heading which is just below It’s not just editors who are seeing this: all users can see it. Read More
Unable to reach app, please try again later
when I’m trying to add Survey app to MS Teams, I got this error ” unable to reach app. Please try again “, so how can fix it ?
when I’m trying to add Survey app to MS Teams, I got this error ” unable to reach app. Please try again “, so how can fix it ? Read More
Graph API InternalServerError with FanoutDownstreamContradiction when running SharePoint query
Hi,
I am running a search query against our SharePoint environment over a large amount of sites using the Graph API. For this we use the ‘search/query’ endpoint. The request is done using delegated permissions. Currently, when we run a query, most of the times it goes well, but sometimes gives an error with a statuscode 500 like this:
{‘error’: {‘code’: ‘InternalServerError’, ‘message’: ‘The call failed, please try again.’, ‘target’: ”, ‘details’: [{‘code’: ‘InternalServerError’, ‘message’: ‘The call failed, please try again.’, ‘target’: ”, ‘details’: [{‘code’: ‘InternalServerError’, ‘message’: ‘The call failed, please try again.’, ‘target’: ”, ‘details’: [{‘code’: ‘InternalServerError’, ‘message’: ‘The call failed, please try again.’, ‘target’: ”, ‘details’: [{‘code’: ‘InternalServerError’, ‘message’: ‘The call failed, please try again.’, ‘target’: ”, ‘details’: [{‘code’: ‘InternalServerError’, ‘message’: ‘The call failed, please try again.’, ‘target’: ”, ‘details’: [{‘code’: ‘FanoutDownstreamContradiction’, ‘message’: ‘The call failed, please try again.’, ‘target’: ”, ‘details’: [{‘code’: ‘TwoStepFanout_FirstStepFailed’, ‘message’: ‘The call failed, please try again.’, ‘target’: ”, ‘serviceName’: ‘Xap’, ‘moduleName’: ‘SubstrateSearch.FanoutV2.Plugins.TenantSearch.TenantSearchMultiDimensionFanoutPluginV3’, ‘contactTeam’: ‘3sdri’, ‘httpCode’: 500}, {‘code’: ‘FanoutDownstreamContradiction’, ‘message’: ‘The call failed, please try again.’, ‘target’: ”, ‘serviceName’: ‘FanoutService’, ‘moduleName’: ‘Fanout’, ‘contactTeam’: ‘3STenantSearchDevs’, ‘httpCode’: 500}], ‘serviceName’: ‘FanoutService’, ‘moduleName’: ‘Fanout’, ‘contactTeam’: ‘3STenantSearchDevs’, ‘httpCode’: 500}], ‘moduleName’: ‘SubstrateMultiDimensionFanoutSearchWorkflowBaseV2’, ‘httpCode’: 500}], ‘moduleName’: ‘G21AscWorkflow’, ‘httpCode’: 500}], ‘moduleName’: ‘TenantFileSearchFederationWorkflow_ASC’, ‘httpCode’: 500}], ‘moduleName’: ‘TenantFileSearchFederationWorkflow’, ‘httpCode’: 500}], ‘warnings’: [{‘code’: ‘InternalServerError’, ‘message’: ‘The call failed, please try again.’, ‘target’: ”, ‘details’: [{‘code’: ‘InternalServerError’, ‘message’: ‘The call failed, please try again.’, ‘target’: ”, ‘details’: [{‘code’: ‘InternalServerError’, ‘message’: ‘The call failed, please try again.’, ‘target’: ”, ‘details’: [{‘code’: ‘ProviderSearchRequestNull’, ‘message’: ‘The call failed, please try again.’, ‘target’: ”, ‘serviceName’: ‘Xap’, ‘moduleName’: ‘TopicEngineQueryRequestBuilderPlugin’, ‘contactTeam’: ‘3sdri’, ‘httpCode’: 500}], ‘moduleName’: ‘HttpWorkflow’, ‘httpCode’: 500}, {‘code’: ‘InternalServerError’, ‘message’: ‘The call failed, please try again.’, ‘target’: ”, ‘details’: [{‘code’: ‘EmptyResponses’, ‘message’: ‘The call failed, please try again.’, ‘target’: ”, ‘serviceName’: ‘TopicEngine’, ‘moduleName’: ‘TopicEngineQueryResponseValidatorPlugin’, ‘contactTeam’: ‘3sdri’, ‘httpCode’: 500}], ‘moduleName’: ‘HttpWorkflow’, ‘httpCode’: 500}], ‘moduleName’: ‘HttpWorkflow’, ‘httpCode’: 500}], ‘moduleName’: ‘TopicEngineWorkflowWithTriggering’, ‘httpCode’: 500}], ‘moduleName’: ‘FederationWorkflow’, ‘httpCode’: 500}], ‘moduleName’: ‘TopLevelWorkflowBase’, ‘httpCode’: 500}, ‘Instrumentation’: {‘TraceId’: ‘36560a36-0a8a-4fda-7619-320942eab818’}}
This problem has only started to occur recently, whereas before we have never had an issue with the queries. It seems to be most common when a lot of documents are being found across many sites for a a search query. The search query itself looks like this:
(FileName:*annual report* OR Title:*annual report*) filetype:pdf LastModifiedTimeForRetention=Yesterday
And thus errors depending on the amount of documents that are being found. It is totally unclear from the error what the problem is, and I’m wondering if anyone has seen this problem and if there is a possible solution for it…
Hi, I am running a search query against our SharePoint environment over a large amount of sites using the Graph API. For this we use the ‘search/query’ endpoint. The request is done using delegated permissions. Currently, when we run a query, most of the times it goes well, but sometimes gives an error with a statuscode 500 like this: {‘error’: {‘code’: ‘InternalServerError’, ‘message’: ‘The call failed, please try again.’, ‘target’: ”, ‘details’: [{‘code’: ‘InternalServerError’, ‘message’: ‘The call failed, please try again.’, ‘target’: ”, ‘details’: [{‘code’: ‘InternalServerError’, ‘message’: ‘The call failed, please try again.’, ‘target’: ”, ‘details’: [{‘code’: ‘InternalServerError’, ‘message’: ‘The call failed, please try again.’, ‘target’: ”, ‘details’: [{‘code’: ‘InternalServerError’, ‘message’: ‘The call failed, please try again.’, ‘target’: ”, ‘details’: [{‘code’: ‘InternalServerError’, ‘message’: ‘The call failed, please try again.’, ‘target’: ”, ‘details’: [{‘code’: ‘FanoutDownstreamContradiction’, ‘message’: ‘The call failed, please try again.’, ‘target’: ”, ‘details’: [{‘code’: ‘TwoStepFanout_FirstStepFailed’, ‘message’: ‘The call failed, please try again.’, ‘target’: ”, ‘serviceName’: ‘Xap’, ‘moduleName’: ‘SubstrateSearch.FanoutV2.Plugins.TenantSearch.TenantSearchMultiDimensionFanoutPluginV3’, ‘contactTeam’: ‘3sdri’, ‘httpCode’: 500}, {‘code’: ‘FanoutDownstreamContradiction’, ‘message’: ‘The call failed, please try again.’, ‘target’: ”, ‘serviceName’: ‘FanoutService’, ‘moduleName’: ‘Fanout’, ‘contactTeam’: ‘3STenantSearchDevs’, ‘httpCode’: 500}], ‘serviceName’: ‘FanoutService’, ‘moduleName’: ‘Fanout’, ‘contactTeam’: ‘3STenantSearchDevs’, ‘httpCode’: 500}], ‘moduleName’: ‘SubstrateMultiDimensionFanoutSearchWorkflowBaseV2’, ‘httpCode’: 500}], ‘moduleName’: ‘G21AscWorkflow’, ‘httpCode’: 500}], ‘moduleName’: ‘TenantFileSearchFederationWorkflow_ASC’, ‘httpCode’: 500}], ‘moduleName’: ‘TenantFileSearchFederationWorkflow’, ‘httpCode’: 500}], ‘warnings’: [{‘code’: ‘InternalServerError’, ‘message’: ‘The call failed, please try again.’, ‘target’: ”, ‘details’: [{‘code’: ‘InternalServerError’, ‘message’: ‘The call failed, please try again.’, ‘target’: ”, ‘details’: [{‘code’: ‘InternalServerError’, ‘message’: ‘The call failed, please try again.’, ‘target’: ”, ‘details’: [{‘code’: ‘ProviderSearchRequestNull’, ‘message’: ‘The call failed, please try again.’, ‘target’: ”, ‘serviceName’: ‘Xap’, ‘moduleName’: ‘TopicEngineQueryRequestBuilderPlugin’, ‘contactTeam’: ‘3sdri’, ‘httpCode’: 500}], ‘moduleName’: ‘HttpWorkflow’, ‘httpCode’: 500}, {‘code’: ‘InternalServerError’, ‘message’: ‘The call failed, please try again.’, ‘target’: ”, ‘details’: [{‘code’: ‘EmptyResponses’, ‘message’: ‘The call failed, please try again.’, ‘target’: ”, ‘serviceName’: ‘TopicEngine’, ‘moduleName’: ‘TopicEngineQueryResponseValidatorPlugin’, ‘contactTeam’: ‘3sdri’, ‘httpCode’: 500}], ‘moduleName’: ‘HttpWorkflow’, ‘httpCode’: 500}], ‘moduleName’: ‘HttpWorkflow’, ‘httpCode’: 500}], ‘moduleName’: ‘TopicEngineWorkflowWithTriggering’, ‘httpCode’: 500}], ‘moduleName’: ‘FederationWorkflow’, ‘httpCode’: 500}], ‘moduleName’: ‘TopLevelWorkflowBase’, ‘httpCode’: 500}, ‘Instrumentation’: {‘TraceId’: ‘36560a36-0a8a-4fda-7619-320942eab818’}} This problem has only started to occur recently, whereas before we have never had an issue with the queries. It seems to be most common when a lot of documents are being found across many sites for a a search query. The search query itself looks like this:(FileName:*annual report* OR Title:*annual report*) filetype:pdf LastModifiedTimeForRetention=Yesterday
And thus errors depending on the amount of documents that are being found. It is totally unclear from the error what the problem is, and I’m wondering if anyone has seen this problem and if there is a possible solution for it… Read More
Conflicting Tasks
I am trying to cancel a Teams Meeting.
When I right click on the meeting and choose ‘Cancel Meeting’ I am getting a Microsoft Outlook alert stating “One or more items in the folder you synchronized do not match. To resolve the conflicts, open the items, and then try this operation again”
I don’t know what this message means, why I am getting the message, and I don’t know how to open the items.
Help please
I am trying to cancel a Teams Meeting. When I right click on the meeting and choose ‘Cancel Meeting’ I am getting a Microsoft Outlook alert stating “One or more items in the folder you synchronized do not match. To resolve the conflicts, open the items, and then try this operation again”I don’t know what this message means, why I am getting the message, and I don’t know how to open the items. Help please Read More
Newletter template with existing news and flexible layout
Hi.
The Newsletter template presents on SharePointOnline does not allow to include existing news on it.
Instead I would like to have a newletter template where I can insert texts and news, the news are already present on my site.
Furthermore, I must be able to organize the layout by distributing text and news as I wish.
Is there such a template?
Thank you.
Hi.The Newsletter template presents on SharePointOnline does not allow to include existing news on it. Instead I would like to have a newletter template where I can insert texts and news, the news are already present on my site.Furthermore, I must be able to organize the layout by distributing text and news as I wish.Is there such a template?Thank you. Read More
Exploring the Advanced RAG (Retrieval Augmented Generation) Service
In the ever-evolving landscape of AI, LLM + RAG (Retrieval Augmented Generation) is a typical use scenario. Retrieving accurate related chunked data from complicated docs and then improving LLM response quality becomes challenge. There is no a silver bullet RAG can address all requirements so far. Developers need to verify different advanced RAG techs to find out which is a proper one for their scenarios considering accuracy, response speed, costs, etc. In order to solve this, with Azure Intelligent Document, Azure OpenAI, LlamaIndex, LangChain, Gradio…, I developed this AdvancedRAG service. This service is encapsulated in a Docker container, offers a streamlined way to experiment with different indexing techniques, evaluate their accuracy, and optimize performance for various RAG use cases. Whether you’re building a quick MVP, a proof of concept, or simply exploring different indexing strategies, this service provides a versatile playground.
Introduction
The Advanced RAG AI Service ( https://github.com/freistli/AdvancedRAG ) enables developers to quickly verify different RAG indexing techniques, assessing both accuracy and performance. From index generation to output verification through chat mode and proofreading mode, this service offers comprehensive support. It can run locally in a Docker container or be deployed to Azure Container Apps, providing flexibility for various deployment scenarios.
Key Features
Knowledge Graph Indexing
Recursive Retriever Query
Tree Mode Summarization
Semantic Hybrid Search + Sub Query Engine with Azure OpenAI
Microsoft GraphRAG (Local Search + Global Search)
Quick Start Guide
To get started with the Advanced RAG service, follow these steps:
Cloning the Repository
git clone https://github.com/freistli/AdvancedRAG.git
Setting Up Environment Variables
Rename .env_4_SC.sample to .env_4_SC and input the necessary environment variables. Note that an Azure OpenAI resource and an Azure Document Intelligence resource are required. Azure AI Search is optional unless you plan to build or use an Azure AI Search index.
Building and Running the Docker Image
Build the Docker image:
docker build -t docaidemo .
Run the image locally:
docker run -p 8000:8000 docaidemo
Access the service at http://localhost:8000.
Running on Azure Container App
Publish your Docker image to Azure Container Registry or Docker Hub.
Create an Azure Container App, select the published Docker image, and deploy the revision pod without any extra commands.
Set environment variables in the Azure Container App if you didn’t include .env_4_SC in the image.
Building an Index
Click the “Index Build” tab.
Upload a file to the file section. (PDF format is recommended for complex content.)
Click “Submit” and wait for the index building to complete. Status updates will appear in real-time on the right pane.
Once you see the completion message, you can download the index for local use.
2024-06-13T10:04:54.120027: Index is persisted in /tmp/index_cache/yourfilename
/tmp/index_cache/yourfilename can be used as your Index name.
Setup Your Own Index in the Docker Image
“rules” Index Name is predefined for Knowledge Graph Index of Japanese proofread demo in this solution. Developers can use their own indexes in other folders for the docker:
To make it work:
Move to the folder which contains the AdvancedRAG dockerfile
Create a folder to keep the index, for example, index123
Extract the index zip file you get from the step 6 in the “Build Index” section, save index files you downloaded into ./index123
Build the docker image again.
After this, you can use index123 as index name in the Chat mode.
Using the Advanced RAG Service
Calling the Service through REST API
Endpoint: https://{BASEURL}/proofreadaddin/run/predict
Method: POST
Header: Content-Type: application/json
Sample Data:
{
“data”: [
“今回は半導体製造装置セクターの最近の動きを分析します。” , <—- Proofread Content
“False” <— Streaming
]
}
Endpoint: https://{BASEURL}/advchatbot/run/chat
Method: POST
Header: Content-Type: application/json
Sample Data:
{
“data”: [
“When did the Author convince his farther”, <—– Prompt
“”, <— History Object, don’t change it
“Azure AI Search”, <—— Index Type
“azuresearch_0”, <——- Index Name or Folder
“You are a friendly AI Assistant” <—– System Message
]
}
Consuming the Service in Office Add-In
For the Proofread Addin use case, refer to: Proofread Addin.
Chat Mode
Click “Chat Mode.”
Choose the index type.
Enter the index path or Azure AI Search Index name in the “Index Name” text field.
Interact with the document using various system messages if needed.
Proofread Mode
Proofread mode is tailored for non-English languages and requires a Knowledge Graph Index. Steps to generate this index are the same as for other indices.
Viewing the Knowledge Graph Index
Click the “View Knowledge Graph Index” tab.
Enter your Knowledge Graph Index name and click “Submit.”
After a short wait, click “Download Knowledge Graph View” to see the result.
Conclusion
The Advanced RAG Service is a convenient solution for developers looking to explore and optimize retrieval augmented generation techniques. By providing a flexible, Docker-based environment, it enables rapid experimentation and deployment, making it easier to find the best indexing strategies for specific use cases, and provide REST API Endpoints. Whether you’re working locally or deploying to the cloud, this service streamlines the process of developing and testing advanced AI solutions.
Microsoft Tech Community – Latest Blogs –Read More
How to rethink and revolutionize agreement processes with Docusign and Microsoft integrations
In this guest blog post, Erika Sperekas, Sr. Partner Marketing Manager at Docusign, examines the consequences of patchwork agreement workflows and explains how system integrations can streamline processes and create better experiences for businesses.
No matter which line of business you work in, you will probably have to deal with agreements at some point. Agreements are everywhere throughout an organization: sales contracts, offer letters, account openings, invoices, and a lot more. They contain details about dollars that change hands, products and services that are delivered, and relationships your business has with important parties.
However, the process most teams use to manage agreements is broken. Organizations have long struggled to deal with the negative effects of patchwork agreement workflows. By combining disjointed tools and applications not meant to manage documents, teams end up requiring employees to manually transfer information from one system to another. That lack of a centrally connected platform hinders productivity, creates bottlenecks, fragments information, and restricts access. Contracts still get done, but there’s a lot more time and pain than there has to be.
These disconnected processes frustrate employees, slow down business, introduce unnecessary risk, and erode value. They also isolate critical data points and prevent the free flow of information across important pieces of the technology stack. In total, Deloitte and Docusign calculate that outdated agreement processes cost businesses nearly $2 trillion in global economic value every year.
To solve that problem, teams need a better way to create, commit to, and manage agreements. They need to connect the systems and processes used to manage agreements to the systems and processes that run the business. The ideal solution is a well-integrated tool that is accessible to all parties in the agreement workflow. It should be full of tools built specifically to manage agreements digitally, reliably, and securely.
Integrate critical technologies to simplify common workflows
In the last decade, investments in customer relationship management, enterprise resource planning, and human capital management technologies have proven valuable in improving the efficiency of data-driven processes, like quote-to-cash and hire-to-retire. Somehow, the agreements that document those activities have remained largely untouched.
Today, the average company uses 976 applications across the organization, but only 28% of those applications are integrated. That means teams spend way too much time doing disconnected work or toggling back and forth between systems. System integrations are necessary to digitize processes across your organization and create better experiences for employees, customers, and partners.
Docusign and Microsoft are industry leaders and natural integration partners when it comes to connecting agreement systems to common workflow systems. By connecting Docusign data to data within Microsoft 365, Dynamics 365, and Power Platform applications, we’ve created a simple way for customers to transform their agreement process. An integrated system will offer more opportunities to automate common agreement steps and expand agreement collaboration to include people on more devices, in more locations, and using a broader range of applications.
“Through our partnership with Microsoft, we are revolutionizing the way organizations do business,” said Janine Grasso, Docusign GVP Partner Development & Alliances. “Docusign’s integrations with Copilot for Microsoft 365 and Copilot for Sales harness the power of AI to drive intelligent automation and innovation, leveraging Power Platform plug-ins and Microsoft Copilot Studio. Meeting people where they work, these integrations empower organizations to accelerate revenue, reduce risk, and create better experiences from the agreements that run their business. Together, we’re not just streamlining processes; we’re redefining what’s possible in the digital era.”
With Docusign’s suite of Microsoft integrations, customers can support the lifecycle of any agreement process without requiring employees to copy and paste data or manually transfer a document from one tool to another. That means faster, simpler workflows for employee onboarding paperwork, sales order forms, legally binding contracts, procurement RFPs, internal forms, and more.
Microsoft customers leveraging Docusign will see an instant increase in the speed of their agreements. Today, 76% of successful Docusign eSignature transactions are completed in less than 24 hours and 41% of them are completed within 15 minutes!
Integrating Docusign with Microsoft also offers a more robust and productive experience for Copilot for Microsoft 365 users. That connection makes it easier than ever for business users across HR, procurement, legal, finance, and more to instantly access information from other corporate and third-party data sources. As your team makes plans to analyze and integrate more data as part of a forward-looking AI strategy, that network of connected data sources will be even more important.
“Our partner Docusign delivers comprehensive solutions that use AI to streamline agreement workflows and enhance collaboration within the Microsoft products people use every day,” said Yvonne Muench, Sr. Director of Marketplace & ISV Journey, Microsoft. “We’re excited that Docusign offers these solutions via Azure Marketplace, simplifying the complex landscape of business tools and empowering our mutual customers to achieve their goals more effectively.”
Making the most of existing investments
Microsoft customers can access the Docusign integrations today on AppSource or purchase Docusign in the Azure Marketplace. It’s the easiest way to leverage their existing Microsoft Azure Consumption Commitment (MACC) to purchase Docusign and access our robust suite of integrations.
With the ability to buy directly from Azure Marketplace, you can ensure a simplified procurement and invoicing experience without new vendor onboarding—allowing you to realize the value of our joint integrations quickly!
Microsoft Tech Community – Latest Blogs –Read More