Category: Microsoft
Category Archives: Microsoft
Azure bot as skill to PVA
Wondering what to choose Azure bot or PVA
You might be wondering whether to create an Azure Bot or use Power Virtual Agents (PVA). Which one is best for your needs? What should you choose? The article below will help you make an informed decision.
https://techcommunity.microsoft.com/t5/iis-support-blog/pva-and-azure-bot/ba-p/4208047
Let’s say you decide to use Power Virtual Agents (PVA) instead of an Azure Bot. But what happens if you already have an Azure Bot? Migration? Yes, but that will take time.
So, can we leverage PVA features while the migration is happening in the background? Absolutely! This article will guide you on how to use PVA alongside your existing Azure Bot.
Step 1: Identify Your SDK V4 Bot and convert to skill
Ensure you have an SDK V4 bot ready and that is working as expected.
We are going to add the same bot selected here as a skill to your newly created PVA bot
Open Your Bot Project:
Open the project that contains the bot you want to convert into a skill.
Export as a Skill:
In the Bot Framework Composer, go to the Create page.
In the bot explorer, find your bot and select the more options (…) menu.
Choose Export as a skill from the menu.
Describe Your Skill:
On the Export your skill page, provide the necessary details such as the skill name, version, publisher name, and a description.
Select Dialogs and Triggers:
Choose the dialogs that will be accessible to consumer bots.
Select the triggers that can start a task. By default, new skill manifests include an event activity as the initial activity sent by a root bot to the skill.
Generate and Publish the Skill Manifest:
Composer will create a skill manifest that describes your skill.
Publish your bot to Azure along with the skill manifest.
Step 2: Update Bot Configuration
Add Allowed Callers: Update your bot’s appsettings.json file to include the PVA bot’s ID in the AllowedCallers section.
{
“MicrosoftAppId”: “<your bot’s app ID>”,
“MicrosoftAppPassword”: “<your bot’s app password>”,
“AllowedCallers”: [ “<PVA bot ID>” ]
}
Step 3: Create a Skill Manifest
Generate Manifest: Create a skill manifest file (manifest.json) for your bot. This file describes the actions your bot can perform and how it can be invoked.
JSON
{
“name”: “YourSkillName”,
“description”: “Description of your skill”,
“msaAppId”: “<your bot’s app ID>”,
“endpoint”: “https://<your bot’s endpoint>/api/messages”,
“actions”: [
{
“id”: “YourActionId”,
“definition”: {
“triggers”: [
{
“type”: “event”,
“name”: “YourEventName”
}
],
“inputs”: [],
“outputs”: []
}
}
]
}
Step 4: Verify your keys in Azure
Azure AD Registration: Ensure your bot is registered in Azure Intra ID. The bot’s application ID and password should match those in your appsettings.json.
Step 5: Create your PVA and Add the Skill to Power Virtual Agents
Create PVA
https://azure.microsoft.com/en-in/products/power-virtual-agents
Open PVA: Go to the Power Virtual Agents portal.
Manage Skills: Navigate to the “Manage Skills” section.
Add Skill: Click on “Add a skill” and provide the URL to your skill manifest file.
Validate and Save: PVA will validate the manifest. If everything is correct, save the skill.
Step 6: Test the Integration
Invoke Skill: Create a topic in PVA that triggers the skill. Test the integration to ensure that the skill is invoked correctly and responds as expected.
Additional Resources
Implement a Skill for Power Virtual Agents
Bot Framework Skills Documentation
Microsoft Tech Community – Latest Blogs –Read More
Azure Web App – Connect to Azure Managed Instance SQL DB
Hi there,
need ideas how to let a Azure Web App connect to a Azure SQL DB (managed by Azure Managed Instance).
Web App has public network access but no private endpoint:
SQL Managed Instance is added to Azure virtual network/subnet.
So, Web App is facing to the internet only. SQL Server is connected to the internal network only.
Web App cannot connect to sql instance.
I tried to create a private endpoint on the managed instance to get it work. But without success.
As I am not too deep into the networking part of Azure I hoped to get help how to approach this. I need to be able to connect the web app to the managed instance. Just creating a private endpoint on the Web App ressource shows a warning that this undermines security. So I am looking for a secure way how to achieve connection from Web App to SQL instance/database.
Thanks in advance.
Additional information:
The sql instance and databases are reachable from in Azure running virtual machines that have network adapters in the virtual network where the sql server is running. It’s only the web app that is not able to connect (most likely because of missing internal network connection).
Microsoft.Data.SqlClient.SqlException (0x80131904): A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: TCP Provider, error: 0 – An attempt was made to access a socket in a way forbidden by its access permissions.)
—> System.ComponentModel.Win32Exception (10013): An attempt was made to access a socket in a way forbidden by its access permissions.
Hi there,need ideas how to let a Azure Web App connect to a Azure SQL DB (managed by Azure Managed Instance). Web App has public network access but no private endpoint: SQL Managed Instance is added to Azure virtual network/subnet. So, Web App is facing to the internet only. SQL Server is connected to the internal network only. Web App cannot connect to sql instance. I tried to create a private endpoint on the managed instance to get it work. But without success. As I am not too deep into the networking part of Azure I hoped to get help how to approach this. I need to be able to connect the web app to the managed instance. Just creating a private endpoint on the Web App ressource shows a warning that this undermines security. So I am looking for a secure way how to achieve connection from Web App to SQL instance/database. Thanks in advance.Additional information:The sql instance and databases are reachable from in Azure running virtual machines that have network adapters in the virtual network where the sql server is running. It’s only the web app that is not able to connect (most likely because of missing internal network connection). Microsoft.Data.SqlClient.SqlException (0x80131904): A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: TCP Provider, error: 0 – An attempt was made to access a socket in a way forbidden by its access permissions.)
—> System.ComponentModel.Win32Exception (10013): An attempt was made to access a socket in a way forbidden by its access permissions. Read More
Canary 130.0.280x.0 regularly crashing
Since update to Canary 130.0.2800.0 the browser keeps crashing regularly after about 1 minute.
Same on Canary 130.0.2801.0, 130.0.2802.0, 130.0.2803.0…
Disabling extensions (especially uBlock) doesn’t change the behavior, Canary still crashes.
Only able to test on a Win 10 system at the moment, can anyone please confirm this happening on Win 11 too? Thanks
Since update to Canary 130.0.2800.0 the browser keeps crashing regularly after about 1 minute. Same on Canary 130.0.2801.0, 130.0.2802.0, 130.0.2803.0…Disabling extensions (especially uBlock) doesn’t change the behavior, Canary still crashes. Only able to test on a Win 10 system at the moment, can anyone please confirm this happening on Win 11 too? Thanks Read More
Change send from e-mail in a Form
Hi all,
I would like to ask for help with changing the e-mail adress that the recipients of a form see.
The goal here is to send out a form from my account but it needs to be visible to other people as send from “email address removed for privacy reasons”.
Thanks for the help
Hi all, I would like to ask for help with changing the e-mail adress that the recipients of a form see.The goal here is to send out a form from my account but it needs to be visible to other people as send from “email address removed for privacy reasons”.Thanks for the help Read More
Windows Explorer memory usage normal?
I have noticed in the recent days (it may be nothing) but Windows Explorer is using a fair bit of RAM. I noticed the usage will continue to grow when opened. I guess this is normal behaviour, the issues I am seeing is the usage does not seem to go back down. I have had it sitting at over 700MB usage. I can get this to go down manually by resetting the task but surely I shouldn’t need to do this? Again this may or may not be a lot, this is why I am here to ask this question. Is this normal behaviour?
Windows 11, chipset etc are all up to date.
CPU – 7800X3D
GPU – 4090
RAM – 64GB @ 6000mhz
Windows is installed on a 1TB M.2 SSD
Thanks for taking the time to read through.
I have noticed in the recent days (it may be nothing) but Windows Explorer is using a fair bit of RAM. I noticed the usage will continue to grow when opened. I guess this is normal behaviour, the issues I am seeing is the usage does not seem to go back down. I have had it sitting at over 700MB usage. I can get this to go down manually by resetting the task but surely I shouldn’t need to do this? Again this may or may not be a lot, this is why I am here to ask this question. Is this normal behaviour?Windows 11, chipset etc are all up to date.CPU – 7800X3DGPU – 4090RAM – 64GB @ 6000mhzWindows is installed on a 1TB M.2 SSDThanks for taking the time to read through. Read More
Create custom image template using script stored in storage account which is publicly disabled
Hi Team,
we are trying to create custom image template for avd. We are trying to use storage account to store the software and script which needs to be run. We are using storage account which is publicly disabled and using private endpoint for the same. We are passing SAS token enabled url to download the script which is valid. We are trying to create image template but during the creation itself it is failing with azure custom image template Not authorized to access the resource:?[REDACTED]. Please check the user assigned identity has the correct permission the UAI has read access on the subcription and the resource group. But when we enable stroage account to publicly accessible we are able to create the image template. We are trying to install the template with same vnet and subnet where we have enabled private endpoint still the image template is failing any help or suggestion will be appreciated. AIB role has following permission on subscription and resource group
Hi Team, we are trying to create custom image template for avd. We are trying to use storage account to store the software and script which needs to be run. We are using storage account which is publicly disabled and using private endpoint for the same. We are passing SAS token enabled url to download the script which is valid. We are trying to create image template but during the creation itself it is failing with azure custom image template Not authorized to access the resource:?[REDACTED]. Please check the user assigned identity has the correct permission the UAI has read access on the subcription and the resource group. But when we enable stroage account to publicly accessible we are able to create the image template. We are trying to install the template with same vnet and subnet where we have enabled private endpoint still the image template is failing any help or suggestion will be appreciated. AIB role has following permission on subscription and resource group”Microsoft.Authorization/*/read”, “Microsoft.Compute/images/write”, “Microsoft.Compute/images/read”, “Microsoft.Compute/images/delete”, “Microsoft.Compute/galleries/read”, “Microsoft.Compute/galleries/images/read”, “Microsoft.Compute/galleries/images/versions/read”, “Microsoft.Compute/galleries/images/versions/write”, “Microsoft.Storage/storageAccounts/blobServices/containers/read”, “Microsoft.Storage/storageAccounts/blobServices/containers/write”, “Microsoft.Storage/storageAccounts/blobServices/read”, “Microsoft.ContainerInstance/containerGroups/read”, “Microsoft.ContainerInstance/containerGroups/write”, “Microsoft.ContainerInstance/containerGroups/start/action”, “Microsoft.ManagedIdentity/userAssignedIdentities/*/read”, “Microsoft.ManagedIdentity/userAssignedIdentities/*/assign/action”, “Microsoft.Authorization/*/read”, “Microsoft.Resources/deployments/*”, “Microsoft.Resources/deploymentScripts/read”, “Microsoft.Resources/deploymentScripts/write”, “Microsoft.Resources/subscriptions/resourceGroups/read”, “Microsoft.VirtualMachineImages/imageTemplates/run/action”, “Microsoft.VirtualMachineImages/imageTemplates/read”, “Microsoft.Network/virtualNetworks/read”, “Microsoft.Network/virtualNetworks/subnets/join/action” Read More
How can I get Win11 to protect my battery properly (on Surface Latop v7)
Hello
How can I get Windows 11 (Home) to protect my battery properly?
i.e. Normally it should only charge to 80% when plugged in, and when it gets below 20% (30%?) give me a warning and then soon after put my latop into sleep mode.
AND allow me to override these settings when I am travelling.
SmartCharging does not appear to be enabled in the Surface App (which seems broadly useless).
e.g. Is the “Battery Limiter” app any good?
Note: I don’t want to pay for this. I want a free or freemium app. I don’t mind adverts.
Fwiw, I do find it utterly ridiculous that I can’t already do this – particularly as there is no easy way to replace the battery in my Microsoft Surface Laptop (v7 – 15in.)
Any thoughts?
HelloHow can I get Windows 11 (Home) to protect my battery properly?i.e. Normally it should only charge to 80% when plugged in, and when it gets below 20% (30%?) give me a warning and then soon after put my latop into sleep mode.AND allow me to override these settings when I am travelling.SmartCharging does not appear to be enabled in the Surface App (which seems broadly useless).e.g. Is the “Battery Limiter” app any good?Note: I don’t want to pay for this. I want a free or freemium app. I don’t mind adverts.Fwiw, I do find it utterly ridiculous that I can’t already do this – particularly as there is no easy way to replace the battery in my Microsoft Surface Laptop (v7 – 15in.)Any thoughts? Read More
Issue with appending to a table in Office Scripts
I have automated the updating of a table in Existing Excel file with data from a table in new file. Both files are Excel online files. The process amounts to:
1. Find the date/time of the oldest record (row) of the Update table
2. Delete all the records (rows) in the Existing table that are on or after the date from 1.
3. Read the Update data
4. Append Update data to the Existing table
Because I am dealing with large tables (Existing is ~650,000 rows, Update is 150,000 rows), the automation has to do steps 3 & 4 in a loop of 10,000 at a time.
The problem I am seeing is that every now and again, one of the append iterations seems to be adding the chunk of data twice. Here is the script for step 4:
function main(workbook: ExcelScript.Workbook, data: string[][] ) {
// get the first worksheet
const sheet = workbook.getWorksheets()[0];
const seatsTable = workbook.getTable(“AllSeatsData”);
// get reference to the seats table
const tableRange = seatsTable.getRange();
// Get the boundaries of the table’s range.
const lastColumnIndex = tableRange.getLastColumn().getColumnIndex();
const lastRowindex = tableRange.getLastRow().getRowIndex();
console.log(lastRowindex);
console.log(seatsTable.getRowCount());
console.log(data.length);
// Now add the rows of the update data to the end (-1) of the table
seatsTable.addRows(-1, data);
console.log(seatsTable.getRowCount());
}
Apart from finding that part the data is duplicated in the resulting table I am seeing the following console logs on these successive loops:
Iteration 10 of 15:
Iteration 11 of 15:
P.S. When this issue has occurred, it always seems to be the 10/11 iteration of the loop.
I have automated the updating of a table in Existing Excel file with data from a table in new file. Both files are Excel online files. The process amounts to:1. Find the date/time of the oldest record (row) of the Update table2. Delete all the records (rows) in the Existing table that are on or after the date from 1.3. Read the Update data 4. Append Update data to the Existing tableBecause I am dealing with large tables (Existing is ~650,000 rows, Update is 150,000 rows), the automation has to do steps 3 & 4 in a loop of 10,000 at a time. The problem I am seeing is that every now and again, one of the append iterations seems to be adding the chunk of data twice. Here is the script for step 4: function main(workbook: ExcelScript.Workbook, data: string[][] ) {
// get the first worksheet
const sheet = workbook.getWorksheets()[0];
const seatsTable = workbook.getTable(“AllSeatsData”);
// get reference to the seats table
const tableRange = seatsTable.getRange();
// Get the boundaries of the table’s range.
const lastColumnIndex = tableRange.getLastColumn().getColumnIndex();
const lastRowindex = tableRange.getLastRow().getRowIndex();
console.log(lastRowindex);
console.log(seatsTable.getRowCount());
console.log(data.length);
// Now add the rows of the update data to the end (-1) of the table
seatsTable.addRows(-1, data);
console.log(seatsTable.getRowCount());
} Apart from finding that part the data is duplicated in the resulting table I am seeing the following console logs on these successive loops:Iteration 10 of 15:”[2024-08-14T08:00:46.1800Z] 589402″,”[2024-08-14T08:00:46.2500Z] 589402″,”[2024-08-14T08:00:46.2660Z] 10000″,”[2024-08-14T08:01:11.2410Z] 599402″Iteration 11 of 15:”[2024-08-14T08:08:54.4050Z] 609402″,”[2024-08-14T08:08:54.4680Z] 609402″,”[2024-08-14T08:08:54.4680Z] 10000″,”[2024-08-14T08:09:17.8400Z] 619402″ Somehow between calling the script where the final table had 599402 rows and it being read again at the beginning of the next call (609402 rows), the table has become 10,000 rows bigger! I don’t know if this is a problem with the .addRows function or some issue with the reading and writing to SharePoint but the behaviour should be deterministic and it clearly isn’t! Any suggestions of what to look into would be much appreciated. P.S. When this issue has occurred, it always seems to be the 10/11 iteration of the loop. Read More
Validataion Errors Not Being Shown To The User
Last week we had a few customers report to us that they had booked a time without receiving a confirmation email. There is no record of their booking in the system or export data so it is not clear for us what is happening. We think that it is unusual for several people to claim the same thing when every time that we tested the bookings system we couldn’t see any problems. But if the customer believes that they have booked a time then where could the confusion be?
We have experimented a little bit to try and understand what the problem could be and we’ve discovered that if the user does not select a time for the service or fill in all the required fields then the Bookings program just appears to reload the page instead of showing the validation errors on the screen. This is clearly a bug because the program used to show messages that guide the user on how to fill in the form correctly. For example if only one time slot is available for a day then it isn’t totally clear that the customer needs to click on this time, but the validation error messages would normally highlight this kind of problem for the customer. But now when you click the “book” without selecting a time you would just see the same booking page again. The customer never sees any confirmation message so this might explain why the customers think that they have booked a time with us. But the worry for us now is that we cannot possibly know how many people this problem has affected but it is currently about 4% of the bookings. We also don’t know when the validation messages stopped working either.
We can’t see that anybody else has reported this kind of problem but we’ve tried it on two separate Bookings sites and both sites have the same user experience at the moment. The user won’t see any validation errors if they fill out the form incorrectly and because the page reloads without a confirmation message the customer might believe that their booking was successful.
As a temporary measure we are trying to highlight through our own website that the user will receive a confirmation email if they have booked their time correctly and that missing details like selecting the time or missing one of the fields would result in their booking not being registered.
There is also an error in the console saying that the page failed to load a resource which may or may not be connected to this problem.
Hope that this problem gets fixed soon!
Last week we had a few customers report to us that they had booked a time without receiving a confirmation email. There is no record of their booking in the system or export data so it is not clear for us what is happening. We think that it is unusual for several people to claim the same thing when every time that we tested the bookings system we couldn’t see any problems. But if the customer believes that they have booked a time then where could the confusion be?We have experimented a little bit to try and understand what the problem could be and we’ve discovered that if the user does not select a time for the service or fill in all the required fields then the Bookings program just appears to reload the page instead of showing the validation errors on the screen. This is clearly a bug because the program used to show messages that guide the user on how to fill in the form correctly. For example if only one time slot is available for a day then it isn’t totally clear that the customer needs to click on this time, but the validation error messages would normally highlight this kind of problem for the customer. But now when you click the “book” without selecting a time you would just see the same booking page again. The customer never sees any confirmation message so this might explain why the customers think that they have booked a time with us. But the worry for us now is that we cannot possibly know how many people this problem has affected but it is currently about 4% of the bookings. We also don’t know when the validation messages stopped working either.We can’t see that anybody else has reported this kind of problem but we’ve tried it on two separate Bookings sites and both sites have the same user experience at the moment. The user won’t see any validation errors if they fill out the form incorrectly and because the page reloads without a confirmation message the customer might believe that their booking was successful.As a temporary measure we are trying to highlight through our own website that the user will receive a confirmation email if they have booked their time correctly and that missing details like selecting the time or missing one of the fields would result in their booking not being registered.There is also an error in the console saying that the page failed to load a resource which may or may not be connected to this problem.Hope that this problem gets fixed soon! Read More
Secure APIM and Azure OpenAI with managed identity
<set-header name=”Authorization” exists-action=”override”>
<value>@(“Bearer ” + (string)context.Variables[“managed-id-access-token”])</value>
</set-header>
name: name
location: location
tags: union(tags, { ‘azd-service-name’: name })
sku: {
name: sku
capacity: (sku == ‘Consumption’) ? 0 : ((sku == ‘Developer’) ? 1 : skuCount)
}
properties: {
publisherEmail: publisherEmail
publisherName: publisherName
// Custom properties are not supported for Consumption SKU
customProperties: sku == ‘Consumption’ ? {} : {
‘Microsoft.WindowsAzure.ApiManagement.Gateway.Security.Ciphers.TLS_ECDHE_RSA_WITH_AES_256_CBC_SHA’: ‘false’
‘Microsoft.WindowsAzure.ApiManagement.Gateway.Security.Ciphers.TLS_ECDHE_RSA_WITH_AES_128_CBC_SHA’: ‘false’
‘Microsoft.WindowsAzure.ApiManagement.Gateway.Security.Ciphers.TLS_RSA_WITH_AES_128_GCM_SHA256’: ‘false’
‘Microsoft.WindowsAzure.ApiManagement.Gateway.Security.Ciphers.TLS_RSA_WITH_AES_256_CBC_SHA256’: ‘false’
‘Microsoft.WindowsAzure.ApiManagement.Gateway.Security.Ciphers.TLS_RSA_WITH_AES_128_CBC_SHA256’: ‘false’
‘Microsoft.WindowsAzure.ApiManagement.Gateway.Security.Ciphers.TLS_RSA_WITH_AES_256_CBC_SHA’: ‘false’
‘Microsoft.WindowsAzure.ApiManagement.Gateway.Security.Ciphers.TLS_RSA_WITH_AES_128_CBC_SHA’: ‘false’
‘Microsoft.WindowsAzure.ApiManagement.Gateway.Security.Ciphers.TripleDes168’: ‘false’
‘Microsoft.WindowsAzure.ApiManagement.Gateway.Security.Protocols.Tls10’: ‘false’
‘Microsoft.WindowsAzure.ApiManagement.Gateway.Security.Protocols.Tls11’: ‘false’
‘Microsoft.WindowsAzure.ApiManagement.Gateway.Security.Protocols.Ssl30’: ‘false’
‘Microsoft.WindowsAzure.ApiManagement.Gateway.Security.Backend.Protocols.Tls10’: ‘false’
‘Microsoft.WindowsAzure.ApiManagement.Gateway.Security.Backend.Protocols.Tls11’: ‘false’
‘Microsoft.WindowsAzure.ApiManagement.Gateway.Security.Backend.Protocols.Ssl30’: ‘false’
}
}
identity: {
type: ‘SystemAssigned’
}
}
name: ‘your-openai-resource-name’
location: ‘your-location’
sku: {
name: ‘S0’
}
kind: ‘OpenAI’
properties: {
// Add other necessary properties here
}
identity: {
type: ‘SystemAssigned’
}
properties: {
publicNetworkAccess: ‘Disabled’
networkAcls: {
defaultAction: ‘Deny’
}
disableLocalAuth: true
}
}
name: guid(openAI.id, ‘cognitive-services-openai-user-role’)
properties: {
roleDefinitionId: subscriptionResourceId(‘Microsoft.Authorization/roleDefinitions’, ‘c1c469a3-0a2d-4bba-b0e1-0eaf1d3d728b’) // Role ID for Cognitive Services OpenAI User
principalId: openAI.identity.principalId
principalType: ‘ServicePrincipal’
scope: openAI.id
}
}
name: guid(apimIdentity.id, resourceGroup().id, ‘cognitive-services-openai-user-role’)
properties: {
roleDefinitionId: subscriptionResourceId(‘Microsoft.Authorization/roleDefinitions’, ‘c1c469a3-0a2d-4bba-b0e1-0eaf1d3d728b’) // Role ID for Cognitive Services OpenAI User
principalId: apimIdentity.properties.principalId
principalType: ‘ServicePrincipal’
scope: resourceGroup().id
}
}
Subscriptions in Azure API Management are a way to control access to APIs. When you publish APIs through APIM, you can secure them using subscription keys. Here’s a quick overview:
Subscriptions: These are containers for a pair of subscription keys (primary and secondary). Developers need a valid subscription key to call the APIs.
Subscription IDs: Each subscription has a unique identifier called a Subscription ID.
How does Subscription relate to the APIM resource though?
Scope of Subscriptions: Subscriptions can be associated with different scopes within an APIM instance:
Product Scope: Subscriptions can be linked to a specific product, which is a collection of one or more APIs. Developers subscribe to the product to access all APIs within it.
API Scope: Subscriptions can also be associated with individual APIs, allowing more granular control over access.
parent: apimService
name: apiName
properties: {
displayName: apiName
apiType: ‘http’
path: apiSuffix
format: ‘openapi+json-link’
value: ‘https://raw.githubusercontent.com/Azure/azure-rest-api-specs/main/specification/cognitiveservices/data-plane/AzureOpenAI/inference/preview/2024-03-01-preview/inference.json’
subscriptionKeyParameterNames: {
header: ‘api-key’
}
}
resource apimDiagnostics ‘diagnostics@2023-05-01-preview’ = {
name: ‘applicationinsights’ // Use a supported diagnostic identifier
properties: {
loggerId: ‘/subscriptions/${subscriptionId}/resourceGroups/${resourceGroup().name}/providers/Microsoft.ApiManagement/service/${apimService.name}/loggers/${apimLogger.name}’
metrics: true
}
}
}
// Creating a product for the API. Products are used to group APIs and apply policies to them
resource product ‘Microsoft.ApiManagement/service/products@2020-06-01-preview’ = {
parent: apimService
name: productName
properties: {
displayName: productName
description: productDescription
state: ‘published’
subscriptionRequired: true
}
}
// Create PRODUCT-API association the API with the product
resource productApi1 ‘Microsoft.ApiManagement/service/products/apis@2020-06-01-preview’ = {
parent: product
name: api1.name
}
// Creating a user for the API Management service
resource user ‘Microsoft.ApiManagement/service/users@2020-06-01-preview’ = {
parent: apimService
name: ‘userName’
properties: {
firstName: ‘User’
lastName: ‘Name’
email: ‘user@example.com’
state: ‘active’
}
}
// Creating a subscription for the API Management service
// NOTE: the subscription is associated with the user and the product, AND the subscription ID is what will be used in the request to authenticate the calling client
resource subscription ‘Microsoft.ApiManagement/service/subscriptions@2020-06-01-preview’ = {
parent: apimService
name: ‘subscriptionAIProduct’
properties: {
displayName: ‘Subscribing to AI services’
state: ‘active’
ownerId: user.id
scope: product.id
}
}
“model”:”gpt-35-turbo”,”messages”:[
{
“role”:”system”,”content”:”You’re a helpful assistant”
},
{
“role”:”user”,”content”:prompt
}
]};
return fetch(URL_CHAT, {
method: “POST”,
headers: {
“api-key”: process.env.SUBSCRIPTION_KEY,
“Content-Type”: “application/json”
},
body: JSON.stringify(body)
})
Microsoft Tech Community – Latest Blogs –Read More
SFTP to sharepoint folder Flow
Hi,
Hi, Is it possible to run a flow that brings file from SFTP folder to sharepoint folder? I built the below one and it kept returnning issues related to connections Read More
Outbound audio drops midway through Teams calls
Hi all,
We have a user (director) here whose outbound audio drops approximately 5-10 minutes through Teams calls (both audio only and video). The incoming audio continues to work without fail. They use a Logitech C270 Webcam as their primary microphone as they won’t use a headset and would prefer not to use an external microphone in terms of desk space. We’ve replaced the webcam twice including different models, that would indicate to me it isn’t related to the webcam as being a hardware issue. We’ve also re-installed the Teams app and cleared the Teams cache (although I’m open to suggestions here if there is a more thorough way of doing this). I should note that the audio always works in short test calls on Teams and it is working in other applications such as Zoom, so I believe there is something unique to Teams happening. Thanks all for any suggestions you can offer.
Hi all,We have a user (director) here whose outbound audio drops approximately 5-10 minutes through Teams calls (both audio only and video). The incoming audio continues to work without fail. They use a Logitech C270 Webcam as their primary microphone as they won’t use a headset and would prefer not to use an external microphone in terms of desk space. We’ve replaced the webcam twice including different models, that would indicate to me it isn’t related to the webcam as being a hardware issue. We’ve also re-installed the Teams app and cleared the Teams cache (although I’m open to suggestions here if there is a more thorough way of doing this). I should note that the audio always works in short test calls on Teams and it is working in other applications such as Zoom, so I believe there is something unique to Teams happening. Thanks all for any suggestions you can offer. Read More
Can’t convert jpg to webp with the Photos app on Windows 11?
When it comes to basic image conversion, the Photos app is always my favorite. But it is not the case for jpg to webp conversion. When I open the jpg with Photos app, the save as menu does not include option for webp, only jpg, jpx, jpx, png, tiff and bmp available.
I am building a new website, and the uploaded images have to be in WebP format based on search engine recommendation. How can I bulk convert JPG to WebP on Windows 11 PC?
Thanks
When it comes to basic image conversion, the Photos app is always my favorite. But it is not the case for jpg to webp conversion. When I open the jpg with Photos app, the save as menu does not include option for webp, only jpg, jpx, jpx, png, tiff and bmp available. I am building a new website, and the uploaded images have to be in WebP format based on search engine recommendation. How can I bulk convert JPG to WebP on Windows 11 PC? Thanks Read More
Ошибка #Н/Д в функциях ИНДЕКС/ПОИСКПОЗ
Я просмотрел публикацию по этой теме (Как исправить ошибку #N/A в функциях INDEX/MATCH – Служба поддержки Microsoft), и сделал всё что там написано. Но, ошибка #Н/Д не исправилась.
Я просмотрел публикацию по этой теме (Как исправить ошибку #N/A в функциях INDEX/MATCH – Служба поддержки Microsoft), и сделал всё что там написано. Но, ошибка #Н/Д не исправилась. Read More
Same device with Onboarded and Not Onboarded status
Hi,
I’m creating a detection rule to search for servers which are not onboarded to Defender. What’s strange about this query is that I get the same device (same devicename but different deviceid) with both Onboarding status, which is “Onboarded” and “Can be onboarded”.
Anyone knows why? This way I get uncorrect results on my detection rule.
Thanks
Hi,I’m creating a detection rule to search for servers which are not onboarded to Defender. What’s strange about this query is that I get the same device (same devicename but different deviceid) with both Onboarding status, which is “Onboarded” and “Can be onboarded”.Anyone knows why? This way I get uncorrect results on my detection rule.Thanks Read More
RefinableString Property empty
Hi,
On our tenant I’ve configured the RefinableString00 (more than 2 days ago) with the crawled property OWS_Q_TEXT_MANUFACTURER. The RefinableString00 still returns null.
What steps we need to follow to see the results
Thanks
Hi, On our tenant I’ve configured the RefinableString00 (more than 2 days ago) with the crawled property OWS_Q_TEXT_MANUFACTURER. The RefinableString00 still returns null. What steps we need to follow to see the results Thanks Read More
Edit links on classic SharePoint site
Hello!
I’m hoping someone can help me with editing a very old classic SharePoint site please!
I want to edit the URL link within the menu along the top…but clicking Edit Links doesn’t let me edit the drop-down menu part (I need to edit the URL at link “B” located within “A”, within “S”? What am I missing?? All Edit Links lets me do is edit “S”. I am an Admin of the site.
Hello! I’m hoping someone can help me with editing a very old classic SharePoint site please! I want to edit the URL link within the menu along the top…but clicking Edit Links doesn’t let me edit the drop-down menu part (I need to edit the URL at link “B” located within “A”, within “S”? What am I missing?? All Edit Links lets me do is edit “S”. I am an Admin of the site. Read More
