Tag Archives: microsoft
Help with email sorting flow + sharepoint list
I have a flow on power automate which is connected to a sharepoint list. When a new email arrives in our share mailbox, a new item in the sharepoint list is created with the title of the email and at this point the status of the item is draft and we change it manually in the list right now. Basically what I am llooking for is advice on how to achieve : when i move an email from Inbox into A-done, i want the flow to automatically change the status of the item to “Done”. By the way the statuses are a list of choices. What i was thinking of doing was comparing the titles of email in inbox to the titles in the sharepoint list, because if I have moved the email out of the inbox the title will not be found anymore, but not sure how to go about this in a way where I can loop through correctly. If the title of item in sharepoint list doesnt match anything found in the inbox i want the status to be changed to done. Can you advise me please? Please see all screenshots for context/what I have so far
I have a flow on power automate which is connected to a sharepoint list. When a new email arrives in our share mailbox, a new item in the sharepoint list is created with the title of the email and at this point the status of the item is draft and we change it manually in the list right now. Basically what I am llooking for is advice on how to achieve : when i move an email from Inbox into A-done, i want the flow to automatically change the status of the item to “Done”. By the way the statuses are a list of choices. What i was thinking of doing was comparing the titles of email in inbox to the titles in the sharepoint list, because if I have moved the email out of the inbox the title will not be found anymore, but not sure how to go about this in a way where I can loop through correctly. If the title of item in sharepoint list doesnt match anything found in the inbox i want the status to be changed to done. Can you advise me please? Please see all screenshots for context/what I have so far Read More
Site Something went wrong
Hello Team,
I recently upgraded a SharePoint 2013 site collection to SharePoint 2016. The database mounted successfully, and the site collection URL and permissions appear intact. However, when attempting to browse the site, users encounter a “Something went wrong” error both inside and outside the server.
The error occurs after entering login credentials. My research suggests that the issue may be due to a missing or problematic web part. Unfortunately, I’m unaware of the custom parts used in the site or who built it.
Could anyone please assist in resolving this issue, particularly in identifying and fixing the problematic web part?
Thank you for your support.
Pradeep
Hello Team,I recently upgraded a SharePoint 2013 site collection to SharePoint 2016. The database mounted successfully, and the site collection URL and permissions appear intact. However, when attempting to browse the site, users encounter a “Something went wrong” error both inside and outside the server.The error occurs after entering login credentials. My research suggests that the issue may be due to a missing or problematic web part. Unfortunately, I’m unaware of the custom parts used in the site or who built it.Could anyone please assist in resolving this issue, particularly in identifying and fixing the problematic web part?Thank you for your support.Pradeep Read More
How to enable single sign on using Azure active Directory for RDS Webclient
Hi
We have setup a RDS Farm and we have configured Webclient, we want to have a MFA using Azure Active directory , how to setup the same
HiWe have setup a RDS Farm and we have configured Webclient, we want to have a MFA using Azure Active directory , how to setup the same Read More
Can I listen to music on Spotify on airplane mode?
Hi everyone,
I often find myself in situations where I’m without an internet connection, like when I’m on a plane. I love listening to Spotify on my phone and Windows 11 PC, but I’m not sure how to do it in airplane mode. I don’t have Spotify Premium, but I’ve heard there might be workarounds or other tools that could help.
Does anyone have any advice on how I can listen to music on Spotify on airplane mode? Any input could be greatly appreciated.
Hi everyone, I often find myself in situations where I’m without an internet connection, like when I’m on a plane. I love listening to Spotify on my phone and Windows 11 PC, but I’m not sure how to do it in airplane mode. I don’t have Spotify Premium, but I’ve heard there might be workarounds or other tools that could help. Does anyone have any advice on how I can listen to music on Spotify on airplane mode? Any input could be greatly appreciated. Read More
##[error]PowerShell exited with code ‘1’
When I run Newman in the pipeline if there is failure, it stop the rest of the pipeline.
##[error]PowerShell exited with code ‘1’.
When I run Newman in the pipeline if there is failure, it stop the rest of the pipeline. ##[error]PowerShell exited with code ‘1’.Finishing: Run newman I need to continue the pipeline. – task: PowerShell@2 displayName: Run newman inputs: targetType: ‘inline’ script: ‘newman run $(System.DefaultWorkingDirectory)/test/postman_collection.json -r htmlextra –reporters cli,htmlextra,junit –reporter-junit-export $(System.DefaultWorkingDirectory)/test/Results/junitReport.xml –reporter-htmlextra-export $(System.DefaultWorkingDirectory)/test/report/TestReport.html’ errorActionPreference: ‘continue’ condition: succeededOrFailed() Can anyone help me on this? This runs perfectly when there is no assertion failure. Read More
Makro excel lock cell
Hi, I would like to add an option to excel to display the date and time after adding data to the cell next to it. Everything works fine through macros. The only problem is that when I protect sheet access to the date and time cells, macros do not work.
Is it possible to close editing date and time cells and at the same time make macros in them work?
Private Sub Worksheet_Change(ByVal Target As Excel.Range)
If Target.Column = 4 Then
ThisRow = Target.Row
Range(“e” & ThisRow).Value = Date
Range(“f” & ThisRow).Value = Format(Time, “Long Time”)
ElseIf Target.Column = 7 Then
ThisRow = Target.Row
Range(“h” & ThisRow).Value = Date
Range(“i” & ThisRow).Value = Format(Time, “Long Time”)
End If
End Sub
Hi, I would like to add an option to excel to display the date and time after adding data to the cell next to it. Everything works fine through macros. The only problem is that when I protect sheet access to the date and time cells, macros do not work.Is it possible to close editing date and time cells and at the same time make macros in them work? Private Sub Worksheet_Change(ByVal Target As Excel.Range)If Target.Column = 4 ThenThisRow = Target.RowRange(“e” & ThisRow).Value = DateRange(“f” & ThisRow).Value = Format(Time, “Long Time”)ElseIf Target.Column = 7 ThenThisRow = Target.RowRange(“h” & ThisRow).Value = DateRange(“i” & ThisRow).Value = Format(Time, “Long Time”)End IfEnd Sub Read More
Partner verification is totally broken & not fit for purpose.
The entire system is an utter shambles. Just look at the number of posts form partners worldwide who have been partners for years yet now can no longer get verified.
I too have been a partner for over 20 years and I’ve been trying since October last year to get these issues fixed. Wasn’t an issue until I signed up to the CSP program. I truly wish I hadn’t bothered. I have been round and round and round. I have submitted every document under the sun. Articles of Incorporation, Certificate of Incorporation, Letter on headed paper, DUNS certificate, Bank Statements. I just constantly get back that “the documents do not match the information you entered for your account”
I raise support tickets, I email, they don’t read them properly, they just send a standard response back. You reply to the response email and then get an email back saying “Deleted Not Read” so they are clearly ignoring anyone’s responses to their meaningless emails. The portal doesn’t work properly, it displays conflicting information. The Fix Now buttons don’t work. I get an email stating my CSP is verified but my MPN ID isn’t. Then I check on the portal and it says both are unverified. So how can they send an email saying its verified and then the portal says it isn’t? I email and ask, they respond with “the documents do not match the information you entered for your account”
I ask them on email please be clear about what they want changing, they respond with “the documents do not match the information you entered for your account”
They are like particularly dim robots. They haven’t a clue, and they don’t care. This is what happens when you outsource.
Microsoft are happy to take your money but it seems they no longer want to have their small business partners. Why don’t they just own up and say rather than getting rid of us all by wearing us down by this method? If they cared they would engage properly and have someone from the Team involved in this forum rather than poor Jill who is not part of the verification team and has to field all these postings.
I am utterly tired of the whole thing and seriously just considering ditching the entire partner program. Who needs the constant stress and mental anguish!
The entire system is an utter shambles. Just look at the number of posts form partners worldwide who have been partners for years yet now can no longer get verified.I too have been a partner for over 20 years and I’ve been trying since October last year to get these issues fixed. Wasn’t an issue until I signed up to the CSP program. I truly wish I hadn’t bothered. I have been round and round and round. I have submitted every document under the sun. Articles of Incorporation, Certificate of Incorporation, Letter on headed paper, DUNS certificate, Bank Statements. I just constantly get back that “the documents do not match the information you entered for your account”I raise support tickets, I email, they don’t read them properly, they just send a standard response back. You reply to the response email and then get an email back saying “Deleted Not Read” so they are clearly ignoring anyone’s responses to their meaningless emails. The portal doesn’t work properly, it displays conflicting information. The Fix Now buttons don’t work. I get an email stating my CSP is verified but my MPN ID isn’t. Then I check on the portal and it says both are unverified. So how can they send an email saying its verified and then the portal says it isn’t? I email and ask, they respond with “the documents do not match the information you entered for your account”I ask them on email please be clear about what they want changing, they respond with “the documents do not match the information you entered for your account”They are like particularly dim robots. They haven’t a clue, and they don’t care. This is what happens when you outsource.Microsoft are happy to take your money but it seems they no longer want to have their small business partners. Why don’t they just own up and say rather than getting rid of us all by wearing us down by this method? If they cared they would engage properly and have someone from the Team involved in this forum rather than poor Jill who is not part of the verification team and has to field all these postings.I am utterly tired of the whole thing and seriously just considering ditching the entire partner program. Who needs the constant stress and mental anguish! Read More
Windows 11 lacks the ability to display File Explorer side by side
I’ve been searching for a solution to this question without success. In previous versions of Windows, it was simple to arrange two or more open File Explorer windows side by side with options for stacking or cascading them. You could achieve this by right-clicking the Taskbar (refer to the image below – apologies for the poor quality).
Is there a way to achieve this in Windows 11?
I’ve been searching for a solution to this question without success. In previous versions of Windows, it was simple to arrange two or more open File Explorer windows side by side with options for stacking or cascading them. You could achieve this by right-clicking the Taskbar (refer to the image below – apologies for the poor quality). Is there a way to achieve this in Windows 11? Read More
“Send page as email” doesn´t always work
Hello everyone,
I have started to use the function “Send page as e-mail” when I send out news/information within our organization. However, this function is not always available, and I have not been able to figure out why. It does not seem to depend on the length of the text. Can anyone help me figure this mystery out? Thank you in advance!
Hello everyone, I have started to use the function “Send page as e-mail” when I send out news/information within our organization. However, this function is not always available, and I have not been able to figure out why. It does not seem to depend on the length of the text. Can anyone help me figure this mystery out? Thank you in advance! Read More
How to add lineage on tableau Dashboard
Hi All
could you please help to know How to add lineage on tableau dashboard as lineage is missing after scanning tableau data sources,
Hi All could you please help to know How to add lineage on tableau dashboard as lineage is missing after scanning tableau data sources, Read More
Configure View of a List that User sees only his data
Hello
I have a big list.
The goal is to send the link of the list to users and let them view only their data.
Regards
JFM_12
Hello I have a big list.The goal is to send the link of the list to users and let them view only their data.RegardsJFM_12 Read More
Read Only Access to Project Schedule for another PM
Hi There!
One of our project has some dependancies with another team’s project. The other team’s Project Manager requires read-only access to Project Schedule check the project activity % complete and who is working on which activity.
How can you provide the Read Only access to other PM? We use Project Online to manage the Portfolio.
Thanks in advance.
Shri
Hi There!One of our project has some dependancies with another team’s project. The other team’s Project Manager requires read-only access to Project Schedule check the project activity % complete and who is working on which activity. How can you provide the Read Only access to other PM? We use Project Online to manage the Portfolio. Thanks in advance.Shri Read More
Edge Management Service: ‘Customization Settings’ tab / Enterprise secure AI settings confusing
In Edge Management Service when you create a new Configuration Profile, the ‘Customization Settings’ tab is available. On the ‘Enterprise Secure AI’ page of this tab, all settings are blue/checked giving the impression that these settings are enabled and active. But they are not.
For a new Configuration Profile the related settings are not available/present in the Policies tab. This gives the impression that (from the ‘Enterprise Secure AI’ perspective) the settings are enabled but in reality they are not because the policies are not present in the Policies tab. This is confusing.
This behavior-by-design could be changed, suggestion:
Check box = Grey/unchecked: Not configured = setting not in Policies tab (Edge defaults apply)Check box = Blue/unchecked: Configured = setting in Policies tab = ‘disabled’Check box = Blue/checked: Configured = setting in Policies tab = ‘enabled’
A consideration to take by the Development team for Edge Management Service.
All comments welcome 😉
In Edge Management Service when you create a new Configuration Profile, the ‘Customization Settings’ tab is available. On the ‘Enterprise Secure AI’ page of this tab, all settings are blue/checked giving the impression that these settings are enabled and active. But they are not. For a new Configuration Profile the related settings are not available/present in the Policies tab. This gives the impression that (from the ‘Enterprise Secure AI’ perspective) the settings are enabled but in reality they are not because the policies are not present in the Policies tab. This is confusing. This behavior-by-design could be changed, suggestion:Check box = Grey/unchecked: Not configured = setting not in Policies tab (Edge defaults apply)Check box = Blue/unchecked: Configured = setting in Policies tab = ‘disabled’Check box = Blue/checked: Configured = setting in Policies tab = ‘enabled’A consideration to take by the Development team for Edge Management Service. All comments welcome 😉 Read More
Acting on Real-Time data using custom actions with Data Activator
Being able to make data driven decisions and act on real-time data is important to organizations because it enable them to either avert crisis in systems that monitor product health and take other actions based on their requirements. For an example, a shipping company may want to monitor their packages and act in real-time when the temperature of the packages becomes too hot. One way of monitoring and acting on data is to use Data Activator, which is a no-code experience in Microsoft Fabric for automatically taking actions when the condition of the package temperature is detected in the data.
Let’s look at Contoso Bikes is a fictitious bike rental company that has a real-time dataset of all bikes available in the docking stations scattered across different neighborhoods in the city. They want to optimize the availability and distribution of their bikes based on the demand and supply patterns. They want to automatically trigger alerts, notifications, or workflows when certain conditions are met in the data, high or low availability of bikes in a certain neighborhood to action job requests to increase the number of available bikes at docking stations.
Using custom actions to trigger alerts with Data Activator
To achieve this, you can set up custom actions with Data Activator to trigger alerts that will enable Contoso Bikes to act on the data. Custom actions in Data Activator are reusable action templates that you can use in multiple triggers, in multiple Reflex items. A custom action defines how to call a specific external system from a Data Activator trigger using a flow
1 – Set a trigger and create a custom action
An alert needs to be already set on your data, you can follow these steps to get and set one using the sample bike data.
Inside of your alert, set the trigger condition to select the No_Bikes property from the dataset
Then set the condition to check when the number of bikes drops to less than 5, so that the trigger can run when the condition is met. This can also be filtered down further, for example you can add a filter that checks for a specific Neighbourhood.
Lastly, create a custom action by selecting Custom Action then + Create using the top navigation bar. Give your custom action a name, then add input fields which are used as input when triggering alerts. Lastly copy the connection string.
Select Create flow in Power Automate, this will navigate to Power Automate. You can add any action then save the flow so that you can come back to Data Activator.
In Data Activator, scroll to the Act section and choose your custom action then fill out the required information for properties. You can create corresponding properties by using the New Property at the top navigation bar.
Select Save.
2 – Configure a custom action in Power Automate
To trigger and send actionable alerts to Contoso Bikes employees, you can use Power Automate as a custom action. Then you will be able to have a notification that is sent to Contoso Bike with an option to mark a job request completed after the bike docking stations have been restocked.
In the Power Automate flow created after creating a custom action, update the When a Data Activator trigger fires with the connection string.
Add an action to Create Item, this will allow Contoso Bikes to receive and store job requests in a SharePoint list. Update it with the relevant fields including the ones from Data Activator, use this format to get values from the trigger triggerOutputs()?[‘body/inputFields/Bikepoint’]. You can opt to us another data source.
Add an action to Post an Adaptive Card and wait for a response in a Teams channel to alert Contoso bikes and take action. Update the message property for this action with the below JSON schema.
{
“type”: “AdaptiveCard”,
“$schema”: “http://adaptivecards.io/schemas/adaptive-card.json”,
“version”: “1.2”,
“body”: [
{
“type”: “Container”,
“items”: [
{
“type”: “TextBlock”,
“text”: “Not enough bikes at the docking stations”,
“wrap”: true,
“style”: “heading”,
“id”: “lblDisplay”
}
]
},
{
“type”: “TextBlock”,
“text”: “Please see and increase number of bikes in the docking stations below”,
“wrap”: true,
“size”: “Small”,
“weight”: “Lighter”,
“color”: “Default”,
“isSubtle”: true,
“id”: “lblDescription”
},
{
“type”: “FactSet”,
“facts”: [
{
“title”: “Bikepoint:”,
“value”: “@{triggerOutputs()?[‘body/inputFields/Bikepoint’]}”
},
{
“title”: “Neighbourhood:”,
“value”: “@{triggerOutputs()?[‘body/inputFields/Neighbourhood’]}”
},
{
“title”: “No. of bikes:”,
“value”: “@{triggerOutputs()?[‘body/inputFields/No of Bikes’]}”
},
{
“title”: “No. of Empty docks:”,
“value”: “@{triggerOutputs()?[‘body/inputFields/Empty Docks’]}”
},
{
“title”: “Street:”,
“value”: “@{triggerOutputs()?[‘body/inputFields/Street’]}”
},
{
“title”: “Job No.”,
“value”: “@{body(‘Create_a_job_item’)?[‘Title’]}”
}
]
},
{
“type”: “ActionSet”,
“actions”: [
{
“type”: “Action.Submit”,
“title”: “Completed”,
“id”: “btnCompleted”
}
]
}
]
}
Lastly, add an action Update item to change the job request status from Not Started to Completed after the completed button on the adaptive card alert has been selected to indicate the docking stations have sufficient bikes available. Make sure to have proper naming conventions as best practice.
To sum up, by creating custom actions you can act on data in real time and across different platforms. You can also customize the actions to suit your specific needs and scenarios. With Data Activator, you can turn your data into actions and achieve your business goals.
Other resources
Get started with Data Activator training
Get started with Real-Time Intelligence
Get started with Data Activator documentation
Microsoft Tech Community – Latest Blogs –Read More
Use Cases for Testing Restrictoutboundnetworkaccess for Speech Service
Transcribing an Audio File from a Storage Account Using the Speech Service
UseCase 1 – Azure Speech Service Outbound access not restricted
Prepare the Audio File: Upload the audio file to your storage account and note its URL. We can take sample file from here: cognitive-services-speech-sdk/sampledata/audiofiles at master · Azure-Samples/cognitive-services-speech-sdk · GitHub
Set Up the Speech Service: Obtain the API key and endpoint URL from your speech service in Azure as below reference
3. Make the GET Request: Follow below steps in Postman to make a POST request to Speech Service
Open Postman and create a new POST request.
Set the URL to https://<SpeechServiceLocation>.api.cognitive.microsoft.com/speechtotext/v3.2/transcriptions.
Add Headers:
Ocp-Apim-Subscription-Key: <keyOfSpeechService>
Content-Type: application/json
Set the Body to raw and select JSON format.
Then, paste the following JSON:
{
“contentUrls”: [
“SASLinkToAudioFileOnStorage”
],
“locale”: “en-US”,
“displayName”: “My Transcription”,
“model”: null,
“properties”: {
“wordLevelTimestampsEnabled”: true,
“languageIdentification”: {
“candidateLocales”: [
“en-US”, “de-DE”, “es-ES”
]
}
}
}
The Post Request will return a status code of 201 as shown – it indicates that the request was successfully processed, and a new transcription job has been created. This status code confirms that the transcription process has been initiated
In the response body of the POST request, find the URL provided under the ‘Links’ section and make a GET request to that URL.
The response from this GET request will contain a contentUrl, which you need to use to make another request to fetch the transcribed data
Since the outbound access was not disabled, we were able to fetch the Transcribed data from speech service.
UseCase 2 – Azure Speech Service Outbound access is restricted
Repeat the steps as mentioned in UseCase1 to send POST request to Speech Service.
The request will return a status code of 403.This means that we are not allowed to access Audio File from Storage account because here we have mentioned – restrictOutboundNetworkAccess”: true, and “allowedFqdnList”: “microsoft.com” which means we have restricted outbound access and speech service can only access “microsoft.com” only.
Microsoft Tech Community – Latest Blogs –Read More
High costs for MS Syntex – although restricted to some sites – maybe open for a short time
Hi everyone,
we are experiencing high costs for MS Syntex. We just wanted it to use for some sites – so i restricted it to 2 sites.
But i did not see that i need to restrict each service – so some users seem to “use” it.
How can i identify these sites and stop them from using any of the services?
How can i completely disabled Syntex for our tenant if nothing else works?
BR
Stephan
Hi everyone, we are experiencing high costs for MS Syntex. We just wanted it to use for some sites – so i restricted it to 2 sites.But i did not see that i need to restrict each service – so some users seem to “use” it.How can i identify these sites and stop them from using any of the services?How can i completely disabled Syntex for our tenant if nothing else works? BRStephan Read More
[MSFT Defender for Cloud] Connection Defender for cloud and AWS account with free 30-day period
Hello.
I’m a cloud security engineer.
We are preparing to link MSFT MDC to enhance the security of AWS environment.
I leave a post because there is a pre-linked inquiry.
1. MDC offers a 30-day free period for Azure subscriptions. However, we couldn’t find any mention of free offers for AWS accounts. Does MDC offer free usage for AWS?
2. Are API query costs and log collection and archiving costs incurred separately other than MDC costs?
Please answer me.
Thank you.
Hello.I’m a cloud security engineer. We are preparing to link MSFT MDC to enhance the security of AWS environment. I leave a post because there is a pre-linked inquiry. 1. MDC offers a 30-day free period for Azure subscriptions. However, we couldn’t find any mention of free offers for AWS accounts. Does MDC offer free usage for AWS? 2. Are API query costs and log collection and archiving costs incurred separately other than MDC costs? Please answer me. Thank you. Read More
The same document looks different in SharePoint than the desktop App (word)
In SharePoint online word view number bullets start like 1.0,1.1,1.2,…. But in desktop view, it’s like 1.1,1.2,1.3,….
I have tried the below troubleshooting steps.
1. Modified the site’s permission hierarchy to specific user. When the bullets that begin with 1.0, 1.1, 1.2, and so on are granted access to the site by the owner, member, and site administrator. The document is correct in both the desktop and SharePoint views when I remove all site permissions and grant read access.
2. Used a new browser(We are normally use Microsoft Edge browser) to visit this same SharePoint location. An identical problem was encountered.
3. Attempted to use the identical file on a different SharePoint site. However, the problem persisted.
Can someone please help me to fix this issue?
In SharePoint online word view number bullets start like 1.0,1.1,1.2,…. But in desktop view, it’s like 1.1,1.2,1.3,…. I have tried the below troubleshooting steps. 1. Modified the site’s permission hierarchy to specific user. When the bullets that begin with 1.0, 1.1, 1.2, and so on are granted access to the site by the owner, member, and site administrator. The document is correct in both the desktop and SharePoint views when I remove all site permissions and grant read access.2. Used a new browser(We are normally use Microsoft Edge browser) to visit this same SharePoint location. An identical problem was encountered.3. Attempted to use the identical file on a different SharePoint site. However, the problem persisted. Can someone please help me to fix this issue? Read More