Hi,

We are looking to create a public (anonymous/unauthenticated) access to a document library. The library resides on a separate SharePoint site that will only contain the public documents.

When I share the document library using the anonymous link, I can access the document library without issue and then navigate around the available folders.

However, we want to be able to add URL parameters into the anonymous link so that upon someone clicking the link they are taken to a specific folder within the library. 

i.e. I want to be taken straight to the folder called ‘Test’ within the ‘PublicDocuments’ document library

ourtenant.sharepoint.com/:f:/s/publicsite/EqabcMvYN1tFq7oiQXAg2VoBnPDpAyk66HKeem9UBSco4g/PublicDocuments/Test

If I use the normal path it requires a login i.e. ourtenant.sharepoint.com/sites/publicsite/Shared%20Documents/PublicDocuments/test

Has anyone found a way of doing this?

​Hi, We are looking to create a public (anonymous/unauthenticated) access to a document library. The library resides on a separate SharePoint site that will only contain the public documents. When I share the document library using the anonymous link, I can access the document library without issue and then navigate around the available folders. However, we want to be able to add URL parameters into the anonymous link so that upon someone clicking the link they are taken to a specific folder within the library. i.e. I want to be taken straight to the folder called ‘Test’ within the ‘PublicDocuments’ document library ourtenant.sharepoint.com/:f:/s/publicsite/EqabcMvYN1tFq7oiQXAg2VoBnPDpAyk66HKeem9UBSco4g/PublicDocuments/Test  If I use the normal path it requires a login i.e. ourtenant.sharepoint.com/sites/publicsite/Shared%20Documents/PublicDocuments/test Has anyone found a way of doing this?   Read More

​

I would like to get partnership badge 

​I would like to get partnership badge   Read More

​

Hello

I’m wondering if there is a way of changing the colour of text in a whole row when one of the cells is a negative %.

I’ve tried various conditional formatting using the <0 but that didn’t work.

Be glad if someone could help.

Thanks

​HelloI’m wondering if there is a way of changing the colour of text in a whole row when one of the cells is a negative %.I’ve tried various conditional formatting using the <0 but that didn’t work.Be glad if someone could help.Thanks  Read More

​

Hi, I’ve seen several posts requesting a solution for this but none have been provided. One post recommended going to the ‘customer actions’ section but there isn’t one available. Can anyone tell me how to disable the ‘reschedule’ option in confirmation emails please? It seems Teams is imprinting the original staff member as the organiser on the rescheduled meeting, which means the only way they can be removed is by creating a new meeting.

​Hi, I’ve seen several posts requesting a solution for this but none have been provided. One post recommended going to the ‘customer actions’ section but there isn’t one available. Can anyone tell me how to disable the ‘reschedule’ option in confirmation emails please? It seems Teams is imprinting the original staff member as the organiser on the rescheduled meeting, which means the only way they can be removed is by creating a new meeting.  Read More

​

Hi

I’m new to the community… forgive me if I’m not precise.

I’m looking for the best way to write a SQL query for MS Access, capable of obtaining the grouping of the values ​​contained in the same field, but in different rows, and having the same key (not primary).

I have 3 rows with the same key (i.e. “1234”)each row has a precise text value in the “Field” field (Water, Earth and Air)

I would like to create a SQL query that results in a single row, with the concatenation of the contents of the “Field” fields.

1234Water1234Earth1234Air

I want a query result like this

1234Water, Earth, Air

also taking into account the fact that there can be NULL values.

Can you help me?

Thanks in advance

​HiI’m new to the community… forgive me if I’m not precise.I’m looking for the best way to write a SQL query for MS Access, capable of obtaining the grouping of the values ​​contained in the same field, but in different rows, and having the same key (not primary).I have 3 rows with the same key (i.e. “1234”)each row has a precise text value in the “Field” field (Water, Earth and Air)I would like to create a SQL query that results in a single row, with the concatenation of the contents of the “Field” fields.1234Water1234Earth1234AirI want a query result like this1234Water, Earth, Airalso taking into account the fact that there can be NULL values.Can you help me?Thanks in advance  Read More

​

I would like to show the dates of a subform. When line 5 is completed, I need those dates, if not, the dates of line 4 should be taken, if not, the dates of line 3 and so on till line 0. Can someone tell me how to do?

Thanks

​I would like to show the dates of a subform. When line 5 is completed, I need those dates, if not, the dates of line 4 should be taken, if not, the dates of line 3 and so on till line 0. Can someone tell me how to do?Thanks  Read More

​

Hi

I have a “mesh interactable setup” manipulable object with constraints on rotation and movement. I can move object only  up and down and I can’t rotate. the object in the rigidbody component has the kinamatic property active. Until a few days ago it worked perfectly. inside mesh I raised and lowered the object and it stayed exactly where I left it iwthout momentum. Exactly what i wanted. Today it no longer works. I can no longer move the object. It is selected. It is hovered but i cannot move.
In unity editor I have mesh toolkit 5.2402.240 and from the editor in play mode it is still working, but inside a custom mesh event it no longer works. Has anything changed about the physics of manipulable objects?

Thank you

​HiI have a “mesh interactable setup” manipulable object with constraints on rotation and movement. I can move object only  up and down and I can’t rotate. the object in the rigidbody component has the kinamatic property active. Until a few days ago it worked perfectly. inside mesh I raised and lowered the object and it stayed exactly where I left it iwthout momentum. Exactly what i wanted. Today it no longer works. I can no longer move the object. It is selected. It is hovered but i cannot move.In unity editor I have mesh toolkit 5.2402.240 and from the editor in play mode it is still working, but inside a custom mesh event it no longer works. Has anything changed about the physics of manipulable objects? Thank you  Read More

​

{“code”:”DeploymentFailed”,”target”:”/subscriptions/…/resourceGroups/Earth-Webshop/providers/Microsoft.Resources/deployments/AzFuncs”,”message”:”At least one resource deployment operation failed. Please list deployment operations for details. Please see https://aka.ms/arm-deployment-operations for usage details.”,”details”:[{“target”:”/subscriptions/…/resourceGroups/Earth-Webshop/providers/Microsoft.Web/sites/saphir-webshop-order”,”message”:”There was a conflict. The remote name could not be resolved: ‘mtvpprlfzkau2azfunctions.file.core.windows.net'”}]}

Here is my bicep file!

@description(‘The name of the function app that you wish to create.’)
param appName string = ‘saphir-webshop-order’

@description(‘Storage Account type’)
@allowed([
‘Standard_LRS’
‘Standard_GRS’
‘Standard_RAGRS’
])
param storageAccountType string = ‘Standard_LRS’

@description(‘Location for all resources.’)
param location string = resourceGroup().location

@description(‘Location for Application Insights’)
param appInsightsLocation string

@description(‘The language worker runtime to load in the function app.’)
@allowed([
‘node’
‘dotnet’
‘java’
])
param runtime string = ‘dotnet’

var functionAppName = appName
var hostingPlanName = appName
var applicationInsightsName = appName
var storageAccountName = ‘${uniqueString(resourceGroup().id)}azfunctions’
var functionWorkerRuntime = runtime

resource storageAccount ‘Microsoft.Storage/storageAccounts@2022-05-01’ = {
name: ‘earthwebshopstorage’
location: location
sku: {
name: storageAccountType
}
kind: ‘Storage’
properties: {
supportsHttpsTrafficOnly: true
defaultToOAuthAuthentication: true
}
}

resource hostingPlan ‘Microsoft.Web/serverfarms@2021-03-01’ = {
name: hostingPlanName
location: location
sku: {
name: ‘Y1’
tier: ‘Dynamic’
}
properties: {}
}

resource functionApp ‘Microsoft.Web/sites@2023-12-01’ = {
name: appName
location: ‘West Europe’
kind: ‘functionapp’
identity: {
type: ‘SystemAssigned’
}
properties: {
serverFarmId: hostingPlan.id
siteConfig: {
appSettings: [
{
name: ‘FUNCTIONS_EXTENSION_VERSION’
value: ‘~4’
}
{
name: ‘WEBSITE_NODE_DEFAULT_VERSION’
value: ‘~14’
}
{
name: ‘APPINSIGHTS_INSTRUMENTATIONKEY’
value: applicationInsights.properties.InstrumentationKey
}
{
name: ‘FUNCTIONS_WORKER_RUNTIME’
value: functionWorkerRuntime
}

]
ftpsState: ‘FtpsOnly’
minTlsVersion: ‘1.2’

}
httpsOnly: true
}
}

resource applicationInsights ‘Microsoft.Insights/components@2020-02-02’ = {
name: applicationInsightsName
location: appInsightsLocation
kind: ‘web’
properties: {
Application_Type: ‘web’
Request_Source: ‘rest’
}
}

​  {“code”:”DeploymentFailed”,”target”:”/subscriptions/…/resourceGroups/Earth-Webshop/providers/Microsoft.Resources/deployments/AzFuncs”,”message”:”At least one resource deployment operation failed. Please list deployment operations for details. Please see https://aka.ms/arm-deployment-operations for usage details.”,”details”:[{“target”:”/subscriptions/…/resourceGroups/Earth-Webshop/providers/Microsoft.Web/sites/saphir-webshop-order”,”message”:”There was a conflict. The remote name could not be resolved: ‘mtvpprlfzkau2azfunctions.file.core.windows.net'”}]}Here is my bicep file! @description(‘The name of the function app that you wish to create.’)
param appName string = ‘saphir-webshop-order’

@description(‘Storage Account type’)
@allowed([
‘Standard_LRS’
‘Standard_GRS’
‘Standard_RAGRS’
])
param storageAccountType string = ‘Standard_LRS’

@description(‘Location for all resources.’)
param location string = resourceGroup().location

@description(‘Location for Application Insights’)
param appInsightsLocation string

@description(‘The language worker runtime to load in the function app.’)
@allowed([
‘node’
‘dotnet’
‘java’
])
param runtime string = ‘dotnet’

var functionAppName = appName
var hostingPlanName = appName
var applicationInsightsName = appName
var storageAccountName = ‘${uniqueString(resourceGroup().id)}azfunctions’
var functionWorkerRuntime = runtime

resource storageAccount ‘Microsoft.Storage/storageAccounts@2022-05-01’ = {
name: ‘earthwebshopstorage’
location: location
sku: {
name: storageAccountType
}
kind: ‘Storage’
properties: {
supportsHttpsTrafficOnly: true
defaultToOAuthAuthentication: true
}
}

resource hostingPlan ‘Microsoft.Web/serverfarms@2021-03-01’ = {
name: hostingPlanName
location: location
sku: {
name: ‘Y1’
tier: ‘Dynamic’
}
properties: {}
}

resource functionApp ‘Microsoft.Web/sites@2023-12-01’ = {
name: appName
location: ‘West Europe’
kind: ‘functionapp’
identity: {
type: ‘SystemAssigned’
}
properties: {
serverFarmId: hostingPlan.id
siteConfig: {
appSettings: [
{
name: ‘FUNCTIONS_EXTENSION_VERSION’
value: ‘~4’
}
{
name: ‘WEBSITE_NODE_DEFAULT_VERSION’
value: ‘~14’
}
{
name: ‘APPINSIGHTS_INSTRUMENTATIONKEY’
value: applicationInsights.properties.InstrumentationKey
}
{
name: ‘FUNCTIONS_WORKER_RUNTIME’
value: functionWorkerRuntime
}

]
ftpsState: ‘FtpsOnly’
minTlsVersion: ‘1.2’

}
httpsOnly: true
}
}

resource applicationInsights ‘Microsoft.Insights/components@2020-02-02’ = {
name: applicationInsightsName
location: appInsightsLocation
kind: ‘web’
properties: {
Application_Type: ‘web’
Request_Source: ‘rest’
}
}   Read More

​

Hello,

can someone please send me the MCT material for the SC-900 training?

Especially the PPTs?

This is my first request for this, so sorry, if I made a mistake!

Thank you

Arnd

​Hello, can someone please send me the MCT material for the SC-900 training?Especially the PPTs? This is my first request for this, so sorry, if I made a mistake! Thank youArnd  Read More

​

Hello Team, I am getting below error whenever I am trying to update my windows server 2022.

I tried to patch it manually but getting below error. I tried all possible fix that I can try.

Searching for all applicable updates…
An error occurred:
Exception from HRESULT: 0x80240438
(Press ENTER to continue):

​Hello Team, I am getting below error whenever I am trying to update my windows server 2022.I tried to patch it manually but getting below error. I tried all possible fix that I can try. Searching for all applicable updates…An error occurred:Exception from HRESULT: 0x80240438(Press ENTER to continue):  Read More

​