Category: Microsoft
Category Archives: Microsoft
Handling AVD Disconnected session
Hi Team,
We are using Azure VD, and we don’t have domain services (GP option not available). Is there any Intune Policy or any other policy that could logoff the AVD user session from the session host VM instead just disconnecting the session.
I am looking for some way to log out/off the user session once its state is disconnected or any way to populate option for session host to have ‘log out/log off from the session instead ‘disconnect’
Regards,
Hi Team, We are using Azure VD, and we don’t have domain services (GP option not available). Is there any Intune Policy or any other policy that could logoff the AVD user session from the session host VM instead just disconnecting the session. I am looking for some way to log out/off the user session once its state is disconnected or any way to populate option for session host to have ‘log out/log off from the session instead ‘disconnect’ Regards, Read More
Saved places and location alerts – Microsoft Support
Details Family Safety location features, like how to save a place to your family map and set location alerts. Location alerts are a premium feature.
Set up drive safety – Microsoft Support
An explanation of drive safety, a premium Family Safety feature. This includes where it’s available and how to enable it.
Leave family group or remove members – Microsoft Support
How to remove members from your family group when you’re on your PC, including adult and child accounts.
Microsoft Licenses Request
Are there any indirect providers who can assist me in providing Microsoft licenses to my customers? I am registered as a CSP Microsoft Partner and want to ensure a smooth process.
Thank you for your attention to this matter. I appreciate your prompt assistance.
Best regards,
Miftah Rizky
Are there any indirect providers who can assist me in providing Microsoft licenses to my customers? I am registered as a CSP Microsoft Partner and want to ensure a smooth process. Thank you for your attention to this matter. I appreciate your prompt assistance.Best regards,Miftah Rizky Read More
Categorization of a large, dynamic data set
I have a challenge which I can’t solve. Already tried multiple ways – makearray, byrow, etc. Nothing worked so far. Here is the challenge:
I have a large set of data (>20000 rows, dynamic). It holds a.o. segments and size of segment (a number). Let’s assume segment is in array A1# and size of segment is in array B1#. In a different table (~20 rows), all the unique segments are listed (named “Segments”). Next to this segment list, I have organized data for 3 categories (small/medium/large) for each segment. Each segment will have its own data for what is defined as small/medium/large. As such, I have 3 columns next to the segment name that holds number values for size thresholds.
In the large table, I now want to categorize each segment. Every segment (A1#) has a size (B1#) which corresponds to a category (small/medium/large) -> I.e. it needs a lookup in the category table.
I would want the formula to result in a spilled array – given the data is dynamic in nature.
Thanks for your ideas!
I have a challenge which I can’t solve. Already tried multiple ways – makearray, byrow, etc. Nothing worked so far. Here is the challenge:I have a large set of data (>20000 rows, dynamic). It holds a.o. segments and size of segment (a number). Let’s assume segment is in array A1# and size of segment is in array B1#. In a different table (~20 rows), all the unique segments are listed (named “Segments”). Next to this segment list, I have organized data for 3 categories (small/medium/large) for each segment. Each segment will have its own data for what is defined as small/medium/large. As such, I have 3 columns next to the segment name that holds number values for size thresholds.In the large table, I now want to categorize each segment. Every segment (A1#) has a size (B1#) which corresponds to a category (small/medium/large) -> I.e. it needs a lookup in the category table.I would want the formula to result in a spilled array – given the data is dynamic in nature.Thanks for your ideas! Read More
Clarification on Annual Cost and Maintenance for SQL Server with SA
Hi everyone,
I’m planning to purchase SQL Server with Software Assurance (SA). I noticed a mention of a cost of $15123, but it’s unclear whether this is a one-time payment or an annual fee. Could someone clarify the annual cost for this setup? Additionally, are there any maintenance costs that I should be aware of?
Thank you!
Hi everyone,I’m planning to purchase SQL Server with Software Assurance (SA). I noticed a mention of a cost of $15123, but it’s unclear whether this is a one-time payment or an annual fee. Could someone clarify the annual cost for this setup? Additionally, are there any maintenance costs that I should be aware of?Thank you! Read More
How can I fix Quick-Books Error UEXP
I’m encountering Quick-Books Error UEXP and need assistance in resolving it. What are the steps to troubleshoot and fix this error? Are there specific settings or updates I need to check?
I’m encountering Quick-Books Error UEXP and need assistance in resolving it. What are the steps to troubleshoot and fix this error? Are there specific settings or updates I need to check? Read More
How to build a social media assistant with Prompty and PromptFlow
How to build a social media assistant with Prompty and PromptFlow
Why Prompty.
Specification: Prompty is an asset class not tied to any language as it uses markdown format with yaml to specify your metadata. It unifies the prompt and its execution in a single package to quickly get started.
Tooling: using the Prompty extension, you can quickly get started in your coding environment and set up your configuration. It enables you to work with prompts at a high level with additional features such as metadata autocompletion, syntax highlighting, quick run and validation.
Runtime: Prompty additionally generates code for you in different frameworks e.g. LangChain, PromptFlow and Semantic Kernel. the asset class easily helps you convert to code simplifying your workflow as it is language agnostic.
Prerequisites and Authentication
To get started, you need to create a new Azure OpenAI resource on the Azure OpenAI Studio.
Once you create the resource, head over to Azure OpenAI Studio and create a gpt-35-turbo model deployment.
The first, and easiest way, to get started is by using environment variables. In your local environment, create a .env file, where you store your keys and endpoints. Your .env file, should be something like this:
AZURE_OPENAI_DEPLOYMENT_NAME = “”
AZURE_OPENAI_API_VERSION = “”
AZURE_OPENAI_API_VERSION = “”
AZURE_OPENAI_ENDPOINT =””
type: azure_openai
azure_deployment: ${env:AZURE_OPENAI_DEPLOYMENT_NAME}
api_version: ${env:AZURE_OPENAI_API_VERSION}
azure_endpoint: ${env:AZURE_OPENAI_ENDPOINT}
You can also, login to your Azure account using azd auth login –use-device-code, this will allow you to define your model configurations and update your settings.json files, allowing you to access your configurations without using environment variable.
Getting Started with Prompty
Install the Prompty extension
Right-click on the VSCode explorer and select “New Prompty.” This will create a new Prompty file in markdown format.
Configure your application metadata, in this case we will update as follows:
name: SociallyPrompt
description: An AI assistant designed to help you create engaging Twitter and LinkedIn posts
authors:
model:
azure_endpoint: azure_openai
azure_deployment: gpt-35-turbo
parameters:
max_tokens: 3000
temperature: 0.9
sample:
blog_title: LLM based development tools – PromptFlow vs LangChain vs Semantic Kernel
blog_link: https://techcommunity.microsoft.com/t5/educator-developer-blog/llm-based-development-tools-promptflow-vs-langchain-vs-semantic/ba-p/4149252
call_to_action: GitHub Sample Code at https://github.com/BethanyJep/Swahili-Tutor
post type: Twitter
Update your application instructions, use examples where necessary, for example, below is a sample instruction for our social media assistant:
You are an Social Media AI assistant who helps people create engaging content for Twitter. As the assistant,
you keep the tweets concise – remember that 280-character limit! Inject enthusiasm into your posts!
Use relevant hashtags to boost visibility for the posts. And have a call to action or even add some personal flair with appropriate emojis.
# Context
I am an AI assistant designed to help you create engaging Twitter and LinkedIn posts. I can help you create posts for a variety of topics, including technology, education, and more. I can also help you create posts for blog posts, articles, and other content you want to share on social media.
user:
{{post_type}} post for the blog post titled “{{blog_title}}” found at {{blog_link}} with the call to action “{{call_to_action}}”.
Once done click the run button to run your Prompty in the terminal
Extending functionality with Promptflow
Tracing your Flow
Resources
Our Social Media Assistant Prompty: BethanyJep/social-media-assistant-prompty (github.com)
Microsoft Build: Practical End-to-End AI Development using Prompty and AI Studio (microsoft.com)
Prompty samples: Collections | Microsoft Learn
Prompty documentations: prompty.ai
Microsoft Tech Community – Latest Blogs –Read More
Configuring ADF Pipeline to Fetch and Store Large Tables as Single JSON Files
I have 14 tables on a client server that need to be fetched using REST API calls. Each table contains between 71 and 800,000 rows, but the page size for fetching data is limited to 100 rows. The REST API does not provide a nextPage link; instead, it uses the parameter “startRow” to specify the starting row for each page. For example, setting startRow=101 fetches rows 101-200.
Our goal is to copy the tables from the REST API connector to ADLS storage as .json files and then transfer the data to a SQL Server. Each table should be stored as a single .json file in ADLS, despite being fetched in multiple pages. Thus, we need 14 .json files, one for each table, in the ADLS storage folder.
Could someone guide me on how to configure the copy data activity’s source and sink to achieve this? Any leads would be greatly appreciated.
#ADF #copyactivity #pagination
I have 14 tables on a client server that need to be fetched using REST API calls. Each table contains between 71 and 800,000 rows, but the page size for fetching data is limited to 100 rows. The REST API does not provide a nextPage link; instead, it uses the parameter “startRow” to specify the starting row for each page. For example, setting startRow=101 fetches rows 101-200.Our goal is to copy the tables from the REST API connector to ADLS storage as .json files and then transfer the data to a SQL Server. Each table should be stored as a single .json file in ADLS, despite being fetched in multiple pages. Thus, we need 14 .json files, one for each table, in the ADLS storage folder.Could someone guide me on how to configure the copy data activity’s source and sink to achieve this? Any leads would be greatly appreciated.#ADF #copyactivity #pagination Read More
Rounding a Date down if it doesn’t exist in Month
Hi,
I am trying to round any date in a series that doesn’t exist (e.g if 31st doesn’t exist in month, round down to 30, if it’s 31st in Feb, round down to 29, etc) in a month down.
Ex (Array 1):
2024-02-31
2024-04-31
2024-08-31
2024-09-31
Formula should output the following from Array 1 (e.g rounding down to closest date):
2024-02-29
2024-04-30
2024-08-31
2024-09-30
Any ideas on how this can be done? My thanks in advance.
Hi, I am trying to round any date in a series that doesn’t exist (e.g if 31st doesn’t exist in month, round down to 30, if it’s 31st in Feb, round down to 29, etc) in a month down. Ex (Array 1):2024-02-312024-04-312024-08-312024-09-31Formula should output the following from Array 1 (e.g rounding down to closest date):2024-02-292024-04-302024-08-312024-09-30Any ideas on how this can be done? My thanks in advance. Read More
Sync button on specific folder is gone.
Hi,
I received complaint from users that the sync button when selecting specific folder is gone. I’ve tried it on my end and confirmed that there are some changes in the UI of onedrive.
Is there something we can do to set it back where the sync button for specific folder is appearing?
I’m aware that there’s a sync button on the gear icon(settings).
Thank you.
Hi, I received complaint from users that the sync button when selecting specific folder is gone. I’ve tried it on my end and confirmed that there are some changes in the UI of onedrive. Is there something we can do to set it back where the sync button for specific folder is appearing? I’m aware that there’s a sync button on the gear icon(settings). Thank you. Read More
Copilot unable to change word document content?
I just purchased the first license for my organisation and am trialing it after reviewing the Microsoft promo material. The promo material had it writing copy, formating and inserting images and all sorts of stuff.
I purchased a license mainly because we burn a lot of time in my company doing something I would thought would be simple for Copilot, fixing document styles and formatting. We write a lot of documents for clients using their templates and this often means we’re merging content from our own internal records into client templates. So I was planning on using Copilot to fix styles after inserting content instead of a person spending hours making sure everything in perfect.
The very first document I try this on, I get the following message when I asked it to “Apply consistent styles and formatting to the entire document” (and this came up as pre-filled selection option after copying and pasting suggesting it’s capable of this):
“As Microsoft 365 Copilot, my role is to assist you within the chat interface by providing information, guidance, and support. I’m here to help you with tasks such as summarizing documents, generating content, and answering questions based on the information available to me. However, I don’t have the capability to directly edit or change documents. If you need assistance with formatting or editing your document, I can guide you through the steps or provide tips on how to achieve your desired outcome. Feel free to ask for any help you need with your document!”
What on earth?? Is this for real, it’s the whole reason that I forked out for this overpriced chatbot.
Please tell me i’ve done something wrong with the configuration?
I just purchased the first license for my organisation and am trialing it after reviewing the Microsoft promo material. The promo material had it writing copy, formating and inserting images and all sorts of stuff.I purchased a license mainly because we burn a lot of time in my company doing something I would thought would be simple for Copilot, fixing document styles and formatting. We write a lot of documents for clients using their templates and this often means we’re merging content from our own internal records into client templates. So I was planning on using Copilot to fix styles after inserting content instead of a person spending hours making sure everything in perfect.The very first document I try this on, I get the following message when I asked it to “Apply consistent styles and formatting to the entire document” (and this came up as pre-filled selection option after copying and pasting suggesting it’s capable of this): “As Microsoft 365 Copilot, my role is to assist you within the chat interface by providing information, guidance, and support. I’m here to help you with tasks such as summarizing documents, generating content, and answering questions based on the information available to me. However, I don’t have the capability to directly edit or change documents. If you need assistance with formatting or editing your document, I can guide you through the steps or provide tips on how to achieve your desired outcome. Feel free to ask for any help you need with your document!” What on earth?? Is this for real, it’s the whole reason that I forked out for this overpriced chatbot. Please tell me i’ve done something wrong with the configuration? Read More
Excel Formula References Changing When I Insert a Row
Hello,
I have multiple excel workbooks, where if I insert a row, it stuffs up my formula references (i.e. formulas start referencing the wrong cells) even though I haven’t changed the formula. The rows are not even referenced by the formula indirectly (i.e. it is not part of an array in a SUMPRODUCT).
This never used to happen, and has only started occurring in the past week or so.
Any help would be much appreciated.
Hello, I have multiple excel workbooks, where if I insert a row, it stuffs up my formula references (i.e. formulas start referencing the wrong cells) even though I haven’t changed the formula. The rows are not even referenced by the formula indirectly (i.e. it is not part of an array in a SUMPRODUCT). This never used to happen, and has only started occurring in the past week or so. Any help would be much appreciated. Read More
Update Cover Photo missing for storylines
Has anyone encountered a client environment where they cannot see the “Update Cover Photo” button when each individual visits their personal storyline (but community admins do see it for their respective communities)
See screenshot below. Is this setting controllable from somewhere in Viva Engage Admin area or are their impacts from settings chosen elsewhere in the M365 tenant that flow through to Viva Engage?
I’d like to know: 1. If anyone else has encountered this 2. If anyone knows what the fix is
Has anyone encountered a client environment where they cannot see the “Update Cover Photo” button when each individual visits their personal storyline (but community admins do see it for their respective communities) See screenshot below. Is this setting controllable from somewhere in Viva Engage Admin area or are their impacts from settings chosen elsewhere in the M365 tenant that flow through to Viva Engage? I’d like to know: 1. If anyone else has encountered this 2. If anyone knows what the fix is Read More
Microsoft Defender for Endpoint features
Hi,
I’d like to know if Microsoft Defender for Endpoint has the following capabilities?
Features:
Anti-malware
MITRE Ingenuity ATT&CK Evaluation
Ransomware Protection and Rollback
Behavior Monitoring and Machine Learning
Single management console
Incident response automation
Targeted attack detection
Enhanced Tamper Protection
Suspicious Behavior Detection
Advanced Deep Learning mechanism
Threat Hunting
Endpoint Isolation
Malicious Traffic Detection
Threat Protection:
Mitigate exploits in vulnerable applications
Application hijacking
Real-time scanning of internet resources
Real-time scanning of local files and network shares
Atomically submit malware samples
If you could share a documentation where I can see these features, I will truly appreciate it.
Thank you,
Vsp
Hi, I’d like to know if Microsoft Defender for Endpoint has the following capabilities? Features:Anti-malwareMITRE Ingenuity ATT&CK EvaluationRansomware Protection and RollbackBehavior Monitoring and Machine LearningSingle management consoleIncident response automationTargeted attack detectionEnhanced Tamper ProtectionSuspicious Behavior DetectionAdvanced Deep Learning mechanismThreat HuntingEndpoint IsolationMalicious Traffic Detection Threat Protection:Mitigate exploits in vulnerable applicationsApplication hijackingReal-time scanning of internet resourcesReal-time scanning of local files and network sharesAtomically submit malware samples If you could share a documentation where I can see these features, I will truly appreciate it. Thank you,Vsp Read More
Threat analytics reports from Microsoft 365 Defender
Did anyone else get bombarded by 30+ threat analytics report emails from Microsoft 365 Defender just last night? I’m seeing some as old as October 2023.
Did anyone else get bombarded by 30+ threat analytics report emails from Microsoft 365 Defender just last night? I’m seeing some as old as October 2023. Read More
Need to use SPO Service Online Powershell Module without credentials-based login for an Automation
I need to access the Sharepoint Admin Center via a Powershell Runbook through a Power Automate flow in order to perform hourly checks on Site Storage Usage in Sharepoint. I have a runbook that currently gets this data on a folder-basis with the PnP Module, but i’m unsure if this will work for this issue. My assumption is that i’ll need to use the SPO Service module, but it requires credentials-based login with administrative access. Is there a way to circumvent this?
I need to access the Sharepoint Admin Center via a Powershell Runbook through a Power Automate flow in order to perform hourly checks on Site Storage Usage in Sharepoint. I have a runbook that currently gets this data on a folder-basis with the PnP Module, but i’m unsure if this will work for this issue. My assumption is that i’ll need to use the SPO Service module, but it requires credentials-based login with administrative access. Is there a way to circumvent this? Read More
Unable to set up Webinar invite from a Group Team calendar
Hi all,
Hoping you can help. We have a Team site and calendar set up for our WIT (Women in Tech) in our organisation. We want to set up 3 webinars in July for people to register for but have noticed that the only option to set up a webinar has to come from the Calendar icon in Teams which automatically reverts to the personal calendar of the person sending the invite and not the WIT calendar as the sender.
This would look odd when recieving the registration from a person and not WIT. It also would make editing the invite hard as even the co-organisers are limited as they are not the person sending the invite so making co-organizers ability void then. Anyone have a solution so the invite sender can be the WIT calendar. I know it can be done for Teams meetings, but we want to have it as a webinar though. Thanks in advance for any help you can give on this query.
Hi all, Hoping you can help. We have a Team site and calendar set up for our WIT (Women in Tech) in our organisation. We want to set up 3 webinars in July for people to register for but have noticed that the only option to set up a webinar has to come from the Calendar icon in Teams which automatically reverts to the personal calendar of the person sending the invite and not the WIT calendar as the sender. This would look odd when recieving the registration from a person and not WIT. It also would make editing the invite hard as even the co-organisers are limited as they are not the person sending the invite so making co-organizers ability void then. Anyone have a solution so the invite sender can be the WIT calendar. I know it can be done for Teams meetings, but we want to have it as a webinar though. Thanks in advance for any help you can give on this query. Read More
Training Materials (Microsoft Learn courses) Missing for MB500
It seems like something removed the Microsoft Learn videos associated with the MB-500 exam: https://learn.microsoft.com/en-us/credentials/certifications/d365-finance-and-operations-apps-developer-associate/?practice-assessment-type=certification#certification-prepare-for-the-exam
The Learn courses are still visible through an internet archive, albeit have a year out of date, but I was wondering whether this removal was accidental or an indication that the training material has been deprecated and new Learn courses will be added.
It seems like something removed the Microsoft Learn videos associated with the MB-500 exam: https://learn.microsoft.com/en-us/credentials/certifications/d365-finance-and-operations-apps-developer-associate/?practice-assessment-type=certification#certification-prepare-for-the-exam The Learn courses are still visible through an internet archive, albeit have a year out of date, but I was wondering whether this removal was accidental or an indication that the training material has been deprecated and new Learn courses will be added. Read More