Tag Archives: microsoft
Starting a PA Flow from a script
I’m following:
Using site designs and Power Automate to track site creation requests | Microsoft Learn
to the letter. And it’s not triggering the flow.
#Define the parameters for the branding:
$themeName = “SiteTemplateBrandingvJustFlowv5”
#Changed @’ from @” below – check if still works.
$site_script = @’
{
“$schema”: “schema.json”,
“actions”: [
{
“verb”: “triggerFlow”,
“url”: “https://prod-105.westeurope.logic.azure.com:443/workflows/a8609dd2abb14c5gac1183be13ef0099/triggers/manual/paths/invoke?api-version=2016-06-01”,
“name”: “Record site creation event”,
“parameters”: {
“event”: “site creation”,
“product”: “SharePoint Online”
}
}
],
“bindata”: { },
“version”: 1
}
‘@
Connect-SPOService -Url “https://mydomain-admin.sharepoint.com” -Credential $credentials
$addSiteScript = Add-SPOSiteScript -Title $themeName -Content $site_script -Description “Communication site which removes data export for modern experience and adds branding.”
Write-Host $addSiteScript.Id
Add-SPOSiteDesign -Title $themeName -WebTemplate “68” -SiteScripts $addSiteScript.Id -Description “”
#ADD CREATE LIST ITEM IN O365 TEAM HUB LIST HERE
The flow is just not triggering as mentioned, can anyone see something wrong above. I’ve used 2 different accounts to create the flow.
I’m following:Using site designs and Power Automate to track site creation requests | Microsoft Learnto the letter. And it’s not triggering the flow. #Define the parameters for the branding:
$themeName = “SiteTemplateBrandingvJustFlowv5”
#Changed @’ from @” below – check if still works.
$site_script = @’
{
“$schema”: “schema.json”,
“actions”: [
{
“verb”: “triggerFlow”,
“url”: “https://prod-105.westeurope.logic.azure.com:443/workflows/a8609dd2abb14c5gac1183be13ef0099/triggers/manual/paths/invoke?api-version=2016-06-01”,
“name”: “Record site creation event”,
“parameters”: {
“event”: “site creation”,
“product”: “SharePoint Online”
}
}
],
“bindata”: { },
“version”: 1
}
‘@
Connect-SPOService -Url “https://mydomain-admin.sharepoint.com” -Credential $credentials
$addSiteScript = Add-SPOSiteScript -Title $themeName -Content $site_script -Description “Communication site which removes data export for modern experience and adds branding.”
Write-Host $addSiteScript.Id
Add-SPOSiteDesign -Title $themeName -WebTemplate “68” -SiteScripts $addSiteScript.Id -Description “”
#ADD CREATE LIST ITEM IN O365 TEAM HUB LIST HEREThe flow is just not triggering as mentioned, can anyone see something wrong above. I’ve used 2 different accounts to create the flow. Read More
Can I download Facebook video to my computer Windows 11?
I’m in a bit of a bind and hoping for some expert advice. I need to download videos from Facebook onto my Windows 11 PC for work-related projects. These videos often contain tutorials and demonstrations that are essential for my ongoing professional development and reference. Unfortunately, my attempts so far haven’t yielded any successful results using the methods I’ve found online. Security and maintaining the original quality of the videos are my top priorities. Could anyone recommend a reliable and safe method or software that works well with Windows 11? Your suggestions will be invaluable to my workflow. Thank you!
I’m in a bit of a bind and hoping for some expert advice. I need to download videos from Facebook onto my Windows 11 PC for work-related projects. These videos often contain tutorials and demonstrations that are essential for my ongoing professional development and reference. Unfortunately, my attempts so far haven’t yielded any successful results using the methods I’ve found online. Security and maintaining the original quality of the videos are my top priorities. Could anyone recommend a reliable and safe method or software that works well with Windows 11? Your suggestions will be invaluable to my workflow. Thank you! Read More
Prevent enabling lock screen camera not work
Hi,
I’m using win11,
In the group policy, there is a setting Prevent enabling lock screen camera.
From the wording, it will block the camera when I lock the screen.
but when I enabled this setting and locked screen, I can still call the camera by using script.
eg.
import cv2
cap = cv2.VideoCapture(0)
Could you help to advice how this “Prevent enabling lock screen camera” setting work, and how can I check it’s really effect after enabled.
thanks.
Hi, I’m using win11, In the group policy, there is a setting Prevent enabling lock screen camera. From the wording, it will block the camera when I lock the screen. but when I enabled this setting and locked screen, I can still call the camera by using script. eg. import cv2
cap = cv2.VideoCapture(0) Could you help to advice how this “Prevent enabling lock screen camera” setting work, and how can I check it’s really effect after enabled. thanks. Read More
How to remove the banner section from the ViVa Connections page.
Hello, Is it possible to remove the banner section on the ViVa Connections page as highlighted in the below image? So, the user can view only the dashboard sections.
Expected:
Hello, Is it possible to remove the banner section on the ViVa Connections page as highlighted in the below image? So, the user can view only the dashboard sections. Expected: Read More
Windows doesn’t let me uninstall Microsoft Edge
Currently I’m on Windows 11 Insider preview and I cannot uninstall Microsoft Edge. The uninstall button is greyed out and says “this app cannot be uninstalled because of the policy set by your organization”. I live in Greece.
Currently I’m on Windows 11 Insider preview and I cannot uninstall Microsoft Edge. The uninstall button is greyed out and says “this app cannot be uninstalled because of the policy set by your organization”. I live in Greece. Read More
How to budget your Azure cloud spend with Microsoft Cost Management
Introduction
If you are using Azure for your cloud applications, you might be wondering how to manage your costs effectively. You might have heard of Microsoft Cost Management, a service that helps you monitor, analyze, and optimize your cloud spending[1]. But did you know that Microsoft Cost Management also offers a powerful feature called Budgets?
Budgets are a way to set spending limits and track your costs against them. They help you avoid surprises in your bill, align your spending with your business goals, and empower your teams to make informed decisions[2]. In this article, you will learn the benefits of having a budget in Microsoft Cost Management, and how to set up and manage your budgets effectively.
We will also show you the three simple steps for budgeting in Azure, and who is responsible for what. These steps are based on the FinOps framework, a set of best practices for managing cloud costs. The FinOps framework consists of three phases: inform, optimize, and operate[3]. We will show you how budgets can help you in each of these phases, and how to connect them with other Microsoft Cost Management features and tools.
Figure 1 Navigating the FinOps Journey: Inform, Optimize, Operate. Retrieved from finops.org
By the end of this article, you will have a clear understanding of why you need a budget in Microsoft Cost Management, and how to use it to get the most out of your cloud investment.
What is a Budget in Microsoft Cost Management?
A budget is a way to set a spending limit for a specific scope and time period in Azure. You can create a budget for your entire billing account, or for a subset of your resources, such as a subscription, a resource group, or a tag. You can also create multiple budgets for different scopes and time periods, depending on your needs.
A budget allows you to track your actual and forecasted costs against your spending limit and get alerts when you reach certain thresholds. You can also configure action groups to trigger automated actions, such as sending emails, calling webhooks, or executing Azure functions, when your budget thresholds are met.
A budget is not a hard limit that prevents you from spending more than the amount that you set. It is a mechanism to provide you with visibility and insights into your spending patterns, and to help you proactively take action before it is too late.
Here are some key features of budgets in Microsoft Cost Management:
You can create budgets for any scope and time period, such as billing account, subscription, resource group, or tag.
You can create multiple budgets for different scopes and time periods, and track them separately or together.
You can use the suggested amount feature to get a recommended budget based on your usage patterns and historical data.
You can set up alerts for actual costs, forecasted costs, percentage of budget, or amount.
You can configure action groups to trigger automated actions, such as sending emails, calling webhooks, or executing Azure functions, when your budget thresholds are met.
You can monitor and analyze your budget usage and performance using Microsoft Cost Management and Cost Analysis.
You can update or delete your budget at any time, depending on your changing needs and circumstances (as long as you have the correct rights/permissions to do so).
Why do you need a budget in Microsoft Cost Management?
Having a budget in Microsoft Cost Management can help you in many ways, such as:
Aligning your spending with your business goals and objectives. You can use a budget to set a realistic and achievable target for your cloud spending, and to measure your progress and performance against it. You can also use a budget to communicate your expectations and constraints to your stakeholders, such as your product owners, engineering teams, finance teams, and leadership teams.
Gaining insights and visibility into your cloud costs. You can use a budget to monitor your actual and forecasted costs, and to compare them with your spending limit. You can also use a budget to drill down into your costs by different dimensions, such as service, resource, location, or tag. If your budget alert is triggered, you can investigate further to see if it was due to a usage or cost spike, anomaly or trend, and identify the root cause and potential solutions. Budget thresholds can give you an indication of your spend rate, that is how much time it takes for your resources to reach 50% (or more) of your predicted budget.
Optimizing your cloud costs and maximizing your return on investment. You can use a budget to identify areas for cost savings or efficiency improvements, such as right-sizing your resources, purchasing reservations or savings plans, or redesigning your application architecture. You can also use a budget to evaluate the impact of your optimization actions, and to validate your assumptions and hypotheses.
Operating efficiently and proactively in the cloud. You can use a budget to set up alerts and notifications when you reach certain thresholds of your spending limit, and to trigger automated actions, such as sending emails, calling webhooks, or executing Azure functions. The extensibility of these notifications can help you bring visibility of your cloud spend into other systems that your organization may use, including Microsoft Teams, email, or helpdesk ticketing systems (ITSM). You can also use a budget to define internal processes and workflows for handling budget overages, such as requesting additional funding, escalating issues, or taking corrective actions like shutting down test or development virtual machines.
Here are some benefits of budgets in Microsoft Cost Management:
Avoid surprises in your bill and stay within your budget.
Align your spending with your business goals and objectives.
Gain insights and visibility into your cloud costs.
Optimize your cloud costs and maximize your return on investment.
Operate efficiently and proactively in the cloud.
How to set up and manage your budgets in Microsoft Cost Management?
Setting up and managing your budgets in Microsoft Cost Management involves several steps, such as:
Defining the initial budget estimate
Creating the budget
Configuring the budget alerts and action groups
Monitoring and managing the budget usage and performance
Fine-tuning and adjusting the budget as needed
We will explain each of these steps in detail, and show you how to use the three simple steps for budgeting in Azure, and who is responsible for what.
Defining the initial budget estimate
Embarking on the journey of defining the initial budget estimate requires a clear delineation of roles and responsibilities. To facilitate this, we introduce the RACI model—a cornerstone of project management that delineates the involvement of project participants. RACI, an acronym for Responsible, Accountable, Consulted, and Informed, serves as a guide to define the involvement and communication flow within project tasks.
Responsible individuals are those who do the work to achieve the task. They have a hands-on role in getting the job done.
Accountable is the person or stakeholder who is the ‘owner’ of the work. They must sign off or approve when the task, deliverable, or milestone is complete.
Consulted are those whose opinions are sought; they are typically subject matter experts, with their input having a significant influence over the outcome.
Informed are those who are kept up-to-date on progress, often only on completion of the task or deliverable; they need to be aware of outcomes but are not directly involved in the work.
Integrating the RACI model is pivotal for its ability to bring clarity and structure to project management. It ensures that each participant is aware of their specific roles and responsibilities, thereby preventing any confusion or overlap in duties. By applying the RACI model to our budgeting process, we aim to foster a well-organized and transparent approach, setting a solid foundation for the project’s success.
Defining the initial budget estimate involves understanding the scope of your product, estimating the resources needed, and translating them into financial terms. You can use Azure pricing calculator, Azure TCO calculator, or Azure Advisor to help you with this step.
Here are some tips for defining the initial budget estimate:
Understand your product requirements and operational needs, such as performance, availability, scalability, security, and compliance.
Estimate the resources needed to support your product, such as compute, storage, network, database, and other services.
Translate the resources into financial terms, such as cost per hour, cost per month, or cost per year.
Consider the factors that may affect your costs, such as usage patterns, demand fluctuations, region differences, or currency changes.
Add a buffer or contingency to account for unexpected costs or changes.
Responsible: The Product Owner is responsible for defining the initial budget estimate based on the product requirements and operational needs. This involves understanding the scope of the product, estimating the resources needed, and translating these into financial terms.
Accountable: Finance is accountable for providing guidance during the budget setup process. They ensure that the budget aligns with the organization’s financial goals and complies with any financial regulations or constraints.
Consulted: The Engineering and Procurement teams are consulted during the budget setup process. They provide input on the operational needs and goals, helping to ensure that the budget is realistic and achievable.
Informed: All members of the organization, including Leadership and Finance, are informed about the budget. This promotes a culture of financial accountability and ensures everyone understands the financial constraints and goals.
Please note that the responsibilities and roles outlined in this document according to the RACI matrix are general recommendations and may vary within your organization. The suggested approach to managing responsibilities is one of many possible options and should be adapted to fit your company’s unique organizational structure and needs. It is essential to determine the most effective method for assigning and managing roles and responsibilities that align with your internal processes and culture.
In addition, if you are setting a budget on existing resources in Microsoft Azure, the budget creation process will suggest a budget amount based on historical cost.
Creating the budget
This step involves creating the budget in Microsoft Cost Management for the desired scope and time period. You can use the Azure portal, Azure CLI, Azure PowerShell, or Azure REST API to create a budget. You can also use the suggested amount feature, which provides you with a recommended budget based on your usage patterns and historical data.
Here are some steps for creating the budget:
Choose the scope and time period for your budget, such as billing account, subscription, resource group, tag, month, quarter, or year.
Specify the budget amount and currency, and optionally use the suggested amount feature to get a recommended budget.
Name your budget and provide a description, and optionally add tags to categorize and group your budget.
Save your budget and review the details.
Figure 2 Effortless Budgeting: Harness the Power of Suggested Amounts
Responsible: The Product Owner and Engineering team are responsible for creating the budget in Microsoft Cost Management for the desired scope and time period. They choose the scope and time period, specify the budget amount and currency, name and describe the budget, and save and review the budget.
Accountable: Finance and Budget Owner are accountable for reviewing and approving the budget. They ensure that the budget is consistent with the initial budget estimate, and that it meets the organization’s financial goals and standards.
Consulted: The FinOps Practitioner is consulted for help on using the suggested amount feature, which provides a recommended budget based on usage patterns and historical data. They provide financial expertise and advice on setting the budget amount and currency.
Informed: All members of the organization, including Leadership and Finance, are informed about the budget. This promotes a culture of financial accountability and transparency.
Configuring the budget alerts and action groups
This step involves setting up alerts and action groups for the desired thresholds and conditions. You can set up alerts for actual costs, forecasted costs, percentage of budget, or amount[4]. You can also set up action groups to trigger automated actions, such as sending emails, calling webhooks, or executing Azure functions, when your budget thresholds are met.
Here are some steps for configuring the budget alerts and action groups:
Choose the alert type and condition, such as actual costs, forecasted costs, percentage of budget, or amount.
Specify the alert threshold and frequency, and optionally add a custom message.
Select or create an action group to trigger automated actions, such as sending emails, calling webhooks, or executing Azure functions, when your alert condition is met.
Save your alert and action group and review the details.
Responsible: The Product Owner and Engineering team are responsible for configuring the budget alerts and action groups for the desired thresholds and conditions. They choose the alert type and condition, specify the alert threshold and frequency, select or create an action group, and save and review the alert and action group.
Accountable: The Product Owner and Engineering team are accountable for reviewing and approving the budget alerts and action groups. They ensure that the alerts and action groups are consistent with the budget goals and expectations, and that they comply with the organization’s policies and standards.
Consulted: The FinOps Practitioner is consulted for help on choosing the alert type and condition, and specifying the alert threshold and frequency. They provide financial expertise and advice on setting the budget alerts and action groups.
Informed: All members of the organization, including Leadership and Finance, are informed about the budget alerts and action groups. This promotes a culture of financial accountability and transparency.
Monitoring and managing the budget usage and performance
This step involves tracking your actual and forecasted costs against your budget, and drilling down into your costs by different dimensions. You can use Microsoft Cost Management and Cost Analysis to monitor and analyze your budget usage and performance[5]. You can also use Azure shared dashboards or share customized cost views to share your budget information with your stakeholders[6]. You can also use Azure Advisor Cost Optimization workbook to get recommendations and best practices for optimizing your costs[7].
Here are some tips for monitoring and managing the budget usage and performance:
Use Cost Analysis to view your budget usage and performance, and compare your actual and forecasted costs with your spending limit.
Use Cost Analysis to drill down into your costs by different dimensions, such as service, resource, location, or tag, and identify the cost drivers and contributors.
Use shared dashboards and customized cost views to create and share custom views of your budget information with your stakeholders, such as product owners, engineering teams, finance teams, or leadership teams.
Use Azure Advisor Cost Optimization workbook to get recommendations and best practices for optimizing your costs, such as right-sizing your resources, purchasing reservations or savings plans, or redesigning your application architecture.
Responsible: The Product Owner and Engineering team are responsible for monitoring and managing the budget usage and performance. They use Microsoft Cost Management and Cost Analysis to view and analyze their budget usage and performance, and to drill down into their costs by different dimensions. They also use shared dashboards and customized cost views to share their budget information with their stakeholders, and Azure Advisor Cost Optimization workbook to get recommendations and best practices for optimizing their costs.
Accountable: The Budget Owner is accountable for tracking and managing budgets. They establish acceptable variance thresholds (e.g., 20% overage), and identify exception handling for scenarios when altering budgets out of cycle is needed. This involves regular monitoring and reporting, as well as taking corrective action if the budget is not being adhered to.
Consulted: The Engineering team and FinOps Practitioner are consulted for help on drilling down with tools. They provide technical expertise and can help identify areas for cost savings or efficiency improvements.
Informed: All members of the organization, including Leadership, are kept informed about any changes to the budget. This helps maintain transparency and promotes a culture of financial accountability.
Fine-tuning and adjusting the budget as needed
This step involves updating or deleting your budget at any time, depending on your changing needs and circumstances. You can also use Microsoft Cost Management to analyze the variance between your budget and your actual or forecasted costs, and to identify the reasons and solutions for any discrepancies or overages.
Here are some tips for fine-tuning and adjusting the budget as needed:
Update your budget amount, scope, time period, alerts, or action groups as needed, depending on your changing needs and circumstances.
Delete your budget if it is no longer relevant or needed, such as when your product is decommissioned or migrated.
Analyze the variance between your budget and your actual or forecasted costs, and identify the reasons and solutions for any discrepancies or overages.
Take corrective actions to resolve any issues or challenges, such as requesting additional funding, adjusting resource usage, or modifying product scope.
Responsible: The Product Owner and Engineering team are responsible for fine-tuning and adjusting the budget as needed. They update or delete their budget at any time, depending on their changing needs and circumstances. They also analyze the variance between their budget and their actual or forecasted costs, and take corrective actions to resolve any issues or challenges.
Accountable: The Budget Owner is accountable for the budget performance. If the budget overage is above the defined tolerance (e.g., 20%), they take corrective actions if possible. This could involve identifying areas for cost savings, adjusting resource usage, or modifying the product scope. If the overage cannot be corrected and additional funding is needed, they request additional funding from the holdback.
Consulted: If additional funding from the holdback is not available or not sufficient, the Higher-Level Budget Owner or Finance directly review the request for additional funding. They provide financial expertise and make decisions about whether to approve the additional funding.
Informed: All members of the organization, including Leadership, are kept informed about any changes to the budget. If the budget adjustment is significant and impacts the organizational performance expectations, Leadership makes adjustments to the budgeted spending levels and records/adjusts impacts to organizational performance expectations.
Best practices for budgets in Microsoft Cost Management
To get the most out of your budgets in Microsoft Cost Management, here are some best practices to follow:
Align your budgets with SMART business goals and objectives. Ensure your budgets are Specific, Measurable, Achievable, Relevant, and Time-bound, reflecting your financial aspirations and limitations[8]. They should be realistic and attainable, fostering a sense of accountability and progress tracking. Communicate your budgets clearly to stakeholders, ensuring they comprehend the expectations and implications, and are aligned with the SMART framework for optimal clarity and effectiveness.
Use multiple budgets for different scopes and time periods. You should have an overall budget for your entire billing account, as well as individual budgets for different units, such as subscriptions, resource groups, tags, or applications. You should also have budgets for different time periods, such as monthly, quarterly, or yearly. This way, you can easily track and compare your costs across different dimensions and granularities.
Use tags to categorize and group your resources and budgets. Tags are key-value pairs that you can assign to your resources to identify and organize them[9]. You can use tags to create budgets for specific categories, such as cost center, product owner, app name, environment, or project. You can also use tags to filter and analyze your costs by different dimensions. You can also use the tag inheritance feature to inherit tags from your subscription to your individual resources.
Use actual and forecasted cost alerts for your budgets. You should set up both actual and forecasted alerts for your budgets, as they serve different purposes[10]. Actual alerts trigger on actual costs when thresholds are met, and can be considered as a reactive approach. Forecasted alerts trigger on estimates and can be considered as an active approach, as you can act before it is too late.
Use action groups to trigger automated actions for your budgets. You should set up action groups to trigger automated actions, such as sending emails, calling webhooks, or executing Azure functions, when your budget thresholds are met[11]. This way, you can notify your stakeholders, escalate issues, or take corrective actions in a timely manner.
Define internal processes and workflows for handling budget overages. You should establish acceptable variance thresholds and exception handling for scenarios when altering budgets out of cycle is needed. You should also define who is responsible, accountable, consulted, and informed for setting up and managing your budgets, and what are the roles and responsibilities of each stakeholder. You should also define what happens if your budget is exceeded, such as requesting additional funding, adjusting resource usage, or modifying product scope. You can use your preferred modeling language to describe these processes and workflows, and to align them with your organizational culture and values.
Summary
In this article, you have learnt the benefits of having a budget in Microsoft Cost Management, and how to set up and manage your budgets effectively. We have also shared some best practices for using budgets to gain insights, optimize costs, and operate efficiently in Azure.
Here are some key takeaways to remember:
Budgets are a way to set spending limits and track your costs against them in Microsoft Cost Management.
Budgets help you align your spending with your business goals, gain insights and visibility into your costs, optimize your costs and maximize your ROI, and operate efficiently and proactively in the cloud.
To set up and manage your budgets, you need to define the initial budget estimate, create the budget, configure the alerts and action groups, monitor and manage the budget usage and performance, and fine-tune and adjust the budget as needed.
To get the most out of your budgets, you should align them with your business goals, use multiple budgets for different scopes and time periods, use tags to categorize and group your resources, use actual and forecasted alerts, use action groups to automate actions, and define internal processes and workflows for handling budget overages.
We hope you have found this article useful and informative. If you have any questions or feedback, please let us know in the comments section below. Thank you for reading!
References
[1] Overview of Cost Management – Microsoft Cost Management | Microsoft Learn
[2] Tutorial – Create and manage budgets – Microsoft Cost Management | Microsoft Learn
[4] Monitor usage and spending with cost alerts in Cost Management – Microsoft Cost Management | Microsoft Learn
[5] Quickstart – Start using Cost analysis – Microsoft Cost Management | Microsoft Learn
[6] Create a dashboard in the Azure portal – Azure portal | Microsoft Learn
[7] Use and customize the Cost optimization workbook – Cloud Computing | Microsoft Learn
[8] SMART criteria – Wikipedia
[9] Tag resources, resource groups, and subscriptions for logical organization – Azure Resource Manager | Microsoft Learn
[10] Monitor usage and spending with cost alerts in Cost Management – Microsoft Cost Management | Microsoft Learn
[11] Azure Monitor action groups – Azure Monitor | Microsoft Learn
Microsoft Tech Community – Latest Blogs –Read More
Share planner with external Users – not Guests
So we are using tenant trust with shared channels to collaborate directly with our partners. So far we are very happy with the solution, but today i discovered that it doesnt seem to be able to add external users to Planner Plans. I was only able to add them as Guests.
Is there any way to get Plans workink for external users? Googling it didnt help me much here.
Appreciate the help.
So we are using tenant trust with shared channels to collaborate directly with our partners. So far we are very happy with the solution, but today i discovered that it doesnt seem to be able to add external users to Planner Plans. I was only able to add them as Guests.Is there any way to get Plans workink for external users? Googling it didnt help me much here. Appreciate the help. Read More
Weird permission issues that I can’t explain
Ok so I have a really weird permissions issue.
We have a sharepoint site which holds lots of PDF documents, these are set to ‘Anyone in the institution can view but can’t download’.
This link is then used in a cataloguing system.
If someone clicks the link in the catalogue it opens up and works fine. If then someone copies the link of the PDF and gives it to someone either via the ‘share’ or copy the address bar, the person receiving the link can’t access the file.
HOWEVER, if the person receiving the file goes to the catalogue and clicks the button to the PDF with the same link, it works.
Now the weird behavior is that if that person goes back to the original link that was sent to them that didn’t work originally, now works fine!
There’s no technical link between the catalogue and the sharepoint site, it just has a normal https link to the PDF file.
What could be going on??
Thanks
David
Ok so I have a really weird permissions issue. We have a sharepoint site which holds lots of PDF documents, these are set to ‘Anyone in the institution can view but can’t download’. This link is then used in a cataloguing system. If someone clicks the link in the catalogue it opens up and works fine. If then someone copies the link of the PDF and gives it to someone either via the ‘share’ or copy the address bar, the person receiving the link can’t access the file. HOWEVER, if the person receiving the file goes to the catalogue and clicks the button to the PDF with the same link, it works. Now the weird behavior is that if that person goes back to the original link that was sent to them that didn’t work originally, now works fine! There’s no technical link between the catalogue and the sharepoint site, it just has a normal https link to the PDF file. What could be going on?? Thanks David Read More
Microsoft RD client Android app url scheme is not working
I’ve been using a legacy URL scheme in my Android app to open the RD Client app via a deep link and initiate an automatic connection with a remote server. It used to work fine, but now it’s no longer functioning. Is there a change in the URL scheme that hasn’t been documented, or perhaps an update that affects this functionality? Can someone guide me on this issue?
I’ve been using a legacy URL scheme in my Android app to open the RD Client app via a deep link and initiate an automatic connection with a remote server. It used to work fine, but now it’s no longer functioning. Is there a change in the URL scheme that hasn’t been documented, or perhaps an update that affects this functionality? Can someone guide me on this issue? Read More
Switch function with different date formats in Access SQL
Hi.
First time trying to use switch function to combine multiple queries to one. For some reason “DateValue” function overrides “DatePart” function in switch clause and gives me wrong format for the week and month parts. This query is for creating month, week and year reports in form.
Is there easy way to get this working? Date fields in table are in short text which i combine in query (C for day, B for month and A for year). Here’s the code:
SELECT Switch(
[Forms]![frm_Main]![btn_pvk] = true, DateValue([PK112.C] & “.” & [PK112.B] & “.” & [PK112.A]),
[Forms]![frm_Main]![btn_kk] = true, DateValue([PK112.C] & “.” & [PK112.B] & “.” & [PK112.A]),
[Forms]![frm_Main]![btn_Vk] = true, DatePart(“ww”, ([PK112.C] & “.” & [PK112.B] & “.” & [PK112.A]), 2),
[Forms]![frm_Main]![btn_Vuosi] = true, DatePart(“m”, ([PK112.B] & “.” & [PK112.A]))
) AS DateFormat, Sum(PK112.E) AS VM_sum, Sum(PK112.F) AS SM_sum, Sum(PK112.G) AS P1_KA_sum, Sum(PK112.H) AS P2_KA_sum, Sum(PK112.I) AS P1_KK_sum, Sum(PK112.J) AS P2_KK_sum, Avg(PK112.K) AS TP_AVG_avg, Avg(PK112.L) AS LP_AVG_avg, Avg(PK112.M) AS LV_AVG_avg
FROM PK112
WHERE ([Forms]![frm_Main]![btn_Pvk] = true)
OR ([Forms]![frm_Main]![btn_vk] = true AND [PK112.A] = [Forms]![frm_Main].[frm_SubForm]![val_Vuosi])
OR ([Forms]![frm_Main]![btn_kk] = true AND [PK112.B] = [Forms]![frm_Main].[frm_SubForm]![num_Kk] AND [PK112.A] = [Forms]![frm_Main].[frm_SubForm]![val_Vuosi])
OR ([Forms]![frm_Main]![btn_vuosi] = true AND [PK112.A] = [Forms]![frm_Main].[frm_SubForm]![val_Vuosi])
GROUP BY Switch(
[Forms]![frm_Main]![btn_pvk] = true, DateValue([PK112.C] & “.” & [PK112.B] & “.” & [PK112.A]),
[Forms]![frm_Main]![btn_kk] = true, DateValue([PK112.C] & “.” & [PK112.B] & “.” & [PK112.A]),
[Forms]![frm_Main]![btn_Vk] = true, DatePart(“ww”, ([PK112.C] & “.” & [PK112.B] & “.” & [PK112.A]), 2),
[Forms]![frm_Main]![btn_Vuosi] = true, DatePart(“m”, ([PK112.B] & “.” & [PK112.A]))
)
ORDER BY Switch(
[Forms]![frm_Main]![btn_pvk] = true, DateValue([PK112.C] & “.” & [PK112.B] & “.” & [PK112.A]),
[Forms]![frm_Main]![btn_kk] = true, DateValue([PK112.C] & “.” & [PK112.B] & “.” & [PK112.A]),
[Forms]![frm_Main]![btn_Vk] = true, DatePart(“ww”, ([PK112.C] & “.” & [PK112.B] & “.” & [PK112.A]), 2),
[Forms]![frm_Main]![btn_Vuosi] = true, DatePart(“m”, ([PK112.B] & “.” & [PK112.A]))
);
Hi. First time trying to use switch function to combine multiple queries to one. For some reason “DateValue” function overrides “DatePart” function in switch clause and gives me wrong format for the week and month parts. This query is for creating month, week and year reports in form.Is there easy way to get this working? Date fields in table are in short text which i combine in query (C for day, B for month and A for year). Here’s the code: SELECT Switch([Forms]![frm_Main]![btn_pvk] = true, DateValue([PK112.C] & “.” & [PK112.B] & “.” & [PK112.A]),[Forms]![frm_Main]![btn_kk] = true, DateValue([PK112.C] & “.” & [PK112.B] & “.” & [PK112.A]),[Forms]![frm_Main]![btn_Vk] = true, DatePart(“ww”, ([PK112.C] & “.” & [PK112.B] & “.” & [PK112.A]), 2),[Forms]![frm_Main]![btn_Vuosi] = true, DatePart(“m”, ([PK112.B] & “.” & [PK112.A]))) AS DateFormat, Sum(PK112.E) AS VM_sum, Sum(PK112.F) AS SM_sum, Sum(PK112.G) AS P1_KA_sum, Sum(PK112.H) AS P2_KA_sum, Sum(PK112.I) AS P1_KK_sum, Sum(PK112.J) AS P2_KK_sum, Avg(PK112.K) AS TP_AVG_avg, Avg(PK112.L) AS LP_AVG_avg, Avg(PK112.M) AS LV_AVG_avgFROM PK112WHERE ([Forms]![frm_Main]![btn_Pvk] = true)OR ([Forms]![frm_Main]![btn_vk] = true AND [PK112.A] = [Forms]![frm_Main].[frm_SubForm]![val_Vuosi])OR ([Forms]![frm_Main]![btn_kk] = true AND [PK112.B] = [Forms]![frm_Main].[frm_SubForm]![num_Kk] AND [PK112.A] = [Forms]![frm_Main].[frm_SubForm]![val_Vuosi])OR ([Forms]![frm_Main]![btn_vuosi] = true AND [PK112.A] = [Forms]![frm_Main].[frm_SubForm]![val_Vuosi])GROUP BY Switch([Forms]![frm_Main]![btn_pvk] = true, DateValue([PK112.C] & “.” & [PK112.B] & “.” & [PK112.A]),[Forms]![frm_Main]![btn_kk] = true, DateValue([PK112.C] & “.” & [PK112.B] & “.” & [PK112.A]),[Forms]![frm_Main]![btn_Vk] = true, DatePart(“ww”, ([PK112.C] & “.” & [PK112.B] & “.” & [PK112.A]), 2),[Forms]![frm_Main]![btn_Vuosi] = true, DatePart(“m”, ([PK112.B] & “.” & [PK112.A])))ORDER BY Switch([Forms]![frm_Main]![btn_pvk] = true, DateValue([PK112.C] & “.” & [PK112.B] & “.” & [PK112.A]),[Forms]![frm_Main]![btn_kk] = true, DateValue([PK112.C] & “.” & [PK112.B] & “.” & [PK112.A]),[Forms]![frm_Main]![btn_Vk] = true, DatePart(“ww”, ([PK112.C] & “.” & [PK112.B] & “.” & [PK112.A]), 2),[Forms]![frm_Main]![btn_Vuosi] = true, DatePart(“m”, ([PK112.B] & “.” & [PK112.A]))); Read More
Unable to Import Excel files into SQL Server
Hello SQL Team,
I’m new to SQL Server & I just created a database and need to import an Excel file.
The problem is that the 3 methods of importing the file has failed.
If I use tasks>import file, the Wizard opens and after indicating the datasource, I get the following error message:
2. If I go to Start and use the SQL Server 2022 Import and Export Data (64-bit) in my pc Apps, I get this error:
3. If I try importing in the csv format and import as a flat file, I get the following error message:
can anyone help please?
Hello SQL Team, I’m new to SQL Server & I just created a database and need to import an Excel file. The problem is that the 3 methods of importing the file has failed. If I use tasks>import file, the Wizard opens and after indicating the datasource, I get the following error message: 2. If I go to Start and use the SQL Server 2022 Import and Export Data (64-bit) in my pc Apps, I get this error: 3. If I try importing in the csv format and import as a flat file, I get the following error message: can anyone help please? Read More
Only get part of the sharepoint list with JavaScript Fetch
Hello.
I have a problem with getting all SP list item (257 currently) with fetch.
I have the following code:
var tasks = new Request(
webUrl + “/_api/web/lists/GetByTitle(‘” + listName + “‘)/items?$top=300”
, {
method: “GET”,
credentials: ‘same-origin’,
headers: new Headers({
“Accept”: “application/json; odata=nometadata”,
})
});
fetch(tasks)
.then((response) => response.json())
.then((data) => {
let items = data.value;
console.log(‘Van: ‘ + data[“@odata.nextLink”])
items.forEach((item) => {
console.log(item.ID,item.Title,item.Program);
});
});
Without the top=300 part it only list 131 item (with it i get all item).
And the odata.nextLink is undefined. So it seems i dont get that.
How can i get all data?
Hello. I have a problem with getting all SP list item (257 currently) with fetch. I have the following code:var tasks = new Request(
webUrl + “/_api/web/lists/GetByTitle(‘” + listName + “‘)/items?$top=300”
, {
method: “GET”,
credentials: ‘same-origin’,
headers: new Headers({
“Accept”: “application/json; odata=nometadata”,
})
});
fetch(tasks)
.then((response) => response.json())
.then((data) => {
let items = data.value;
console.log(‘Van: ‘ + data[“@odata.nextLink”])
items.forEach((item) => {
console.log(item.ID,item.Title,item.Program);
});
});Without the top=300 part it only list 131 item (with it i get all item).And the odata.nextLink is undefined. So it seems i dont get that.How can i get all data? Read More
Copilot Deployment Kit in Viva Amplify now generally available
We are excited to announce the general availability of the Copilot Deployment Kit in Viva Amplify. Transform your organization to a new way of working with the power of AI in Copilot for Microsoft 365! Leveraging Microsoft’s internal Copilot deployment learnings and best practices, this Copilot Deployment Kit will help you drive awareness and adoption of Copilot by enabling employees to learn how to get ready for Copilot, what Copilot can do for them in their Microsoft 365 apps, and where to learn more.
Pre-built Copilot Deployment Kit available on campaign home page in Viva Amplify.
Includes 8 pre-drafted communications and campaign brief with objectives and key messages. Communicators can easily edit, review and publish to desired audiences through multiple channels including Outlook, Teams and SharePoint.
Communications include video introduction, simple and practical ways to try Copilot with example prompts, and additional resources to help build AI skills.
Campaign and publication reports help you see the effectiveness of the campaign.
See the the following video for a live demo on the Copilot Deployment Kit with Britt Boston (Microsoft) and and Vesa Juvonen (Microsoft).
Frequently asked questions
When will this happen?
The feature is rolling out currently to Targeted Release customers and will continue to roll out to all customers in June 2024.
This message is associated with Microsoft 365 Roadmap ID 392453.
What do you need to prepare?
This is add-on feature with the Viva Amplify and will be available within the product without any actions from your side.
How to get started using Viva Amplify
Viva Amplify empowers organizational communication teams and leaders to elevate their message and energize their people. Viva Amplify is part of Microsoft Viva Employee Experience platform. See more details from the official documentation.
What is next?
There are lot of new features in the roadmap for the Viva Amplify. We are currently working on the publishing support for the Viva Engage directly from the Viva Amplify, which will be available later this year (current plan). We are also looking into providing similar content packs with the Viva Amplify in future to streamline communications and make the change management easier. Your feedback and input is invaluable on building these experiences. Got an idea or feedback? – Please add comment below or use the Microsoft Feedback portal.
Thanks for reading. Let us know about your feedback on Viva Amplify or the Copilot Deployment Kit in the comments.
Microsoft Tech Community – Latest Blogs –Read More
Regarding file system error on Windows 10
I’ve been experiencing a strange issue with my Windows 10 system where I’m getting frequent file system errors. The error message usually appears when I’m trying to access or move files, and it says that the file system has encountered an error and is unable to complete the requested action. The error message also mentions a specific file or folder, but it’s always a random one. Sometimes the error is resolved by restarting the system or closing the application, but other times it persists and I’m unable to access the affected files or folders. Has anyone else experienced similar issues with their Windows 10 system, and if so, how did they resolve it?
I’ve been experiencing a strange issue with my Windows 10 system where I’m getting frequent file system errors. The error message usually appears when I’m trying to access or move files, and it says that the file system has encountered an error and is unable to complete the requested action. The error message also mentions a specific file or folder, but it’s always a random one. Sometimes the error is resolved by restarting the system or closing the application, but other times it persists and I’m unable to access the affected files or folders. Has anyone else experienced similar issues with their Windows 10 system, and if so, how did they resolve it? Read More
How to access shared subcalendars in Outlook new?
We use several shared calendarfolders for sharing information. These folders reside as subfolders of an account and are shared with everyone in the company. The users can access the folders perfectly in the old outlook desktop version, but this is not possible in the new version. Or is it possible that it’s only me that hasn’t figured out how? Does anybody know?
We use several shared calendarfolders for sharing information. These folders reside as subfolders of an account and are shared with everyone in the company. The users can access the folders perfectly in the old outlook desktop version, but this is not possible in the new version. Or is it possible that it’s only me that hasn’t figured out how? Does anybody know? Read More
I’m unable to login to https://dynamicspartners.transform.microsoft.com/
Hi,
I’m unable to login to https://dynamicspartners.transform.microsoft.com/. Nothing happens when I try to press the login button on the upper right corner.
Result has been the same with three different browsers (Firefox, Chrome & Edge) and with two different PCs.
Our IT says that I have the same rights than my predecessor who used to handle MS incentive cases. I am unable to for example download Proof of Execution documentation f.e: https://dynamicspartners.transform.microsoft.com/download/protected?assetname=protectedassets%2FPartner%20Activities%20-%20Business%20Value%20Assessment%20-%20POE%20Template.pptx&protected=1
Nothing happens when I open that link.
What rights should I have to be able to login to https://dynamicspartners.transform.microsoft.com/?
Any ideas that what could be causing this?
-Ossi
Hi, I’m unable to login to https://dynamicspartners.transform.microsoft.com/. Nothing happens when I try to press the login button on the upper right corner. Result has been the same with three different browsers (Firefox, Chrome & Edge) and with two different PCs. Our IT says that I have the same rights than my predecessor who used to handle MS incentive cases. I am unable to for example download Proof of Execution documentation f.e: https://dynamicspartners.transform.microsoft.com/download/protected?assetname=protectedassets%2FPartner%20Activities%20-%20Business%20Value%20Assessment%20-%20POE%20Template.pptx&protected=1 Nothing happens when I open that link. What rights should I have to be able to login to https://dynamicspartners.transform.microsoft.com/? Any ideas that what could be causing this? -Ossi Read More
Cannot get “$_.hiddenfromaddresslistsenabled -eq $true” to work with other parameters.
Hi Cannot get this command to work. Tried different variations and commands.
Get-Mailbox | Where-Object {$_.IsLicensed -eq $true -and $_.BlockCredential -eq $false -and $_.hiddenfromaddresslistsenabled -eq $true}
The below works fine:
Get-Mailbox | Where-Object {$_.IsLicensed -eq $true -and $_.BlockCredential -eq $false}
Can anyone help?
Hi Cannot get this command to work. Tried different variations and commands. Get-Mailbox | Where-Object {$_.IsLicensed -eq $true -and $_.BlockCredential -eq $false -and $_.hiddenfromaddresslistsenabled -eq $true} The below works fine:Get-Mailbox | Where-Object {$_.IsLicensed -eq $true -and $_.BlockCredential -eq $false} Can anyone help? Read More
Playlist Videos in Sharepoint list shows “Request Access” but i can be played upon clicking it
Hi Team,
We created a playlist and have shared the playlist videos to specific users. However, the playlist shows that they have to request for access. If the select the video, it can be played.
Why the “Request Access” is displayed though access is available. It misleads the user.
Hi Team, We created a playlist and have shared the playlist videos to specific users. However, the playlist shows that they have to request for access. If the select the video, it can be played. Why the “Request Access” is displayed though access is available. It misleads the user. Read More
Understanding SharePoint Online Storage
Understanding SharePoint Online storage used to be easy. Then applications like Loop arrived. Other influences like retention and archive can affect storage too. It’s a complicated situation before you throw OneDrive for Business into the mix and consider that Microsoft has removed unlimited OneDrive storage while an increasing number of apps store files in OneDrive. It’s a complicated situation.
https://office365itpros.com/2024/06/10/sharepoint-online-storage-2/
Understanding SharePoint Online storage used to be easy. Then applications like Loop arrived. Other influences like retention and archive can affect storage too. It’s a complicated situation before you throw OneDrive for Business into the mix and consider that Microsoft has removed unlimited OneDrive storage while an increasing number of apps store files in OneDrive. It’s a complicated situation.
https://office365itpros.com/2024/06/10/sharepoint-online-storage-2/ Read More
The End for Office 365 Connectors Comes Into Sight
Office 365 Connectors bring data from external sources into Microsoft 365 apps like Teams and Outlook. Workflows and Power Automate are replacing Connectors for Microsoft 365 Groups (Outlook groups) and SharePoint Online. Connectors are still available in Teams but for how long? No one knows, but it does seem like Microsoft is rationalizing no-code automation around Power Automate.
https://office365itpros.com/2024/06/11/office-365-connectors-end/
Office 365 Connectors bring data from external sources into Microsoft 365 apps like Teams and Outlook. Workflows and Power Automate are replacing Connectors for Microsoft 365 Groups (Outlook groups) and SharePoint Online. Connectors are still available in Teams but for how long? No one knows, but it does seem like Microsoft is rationalizing no-code automation around Power Automate.
https://office365itpros.com/2024/06/11/office-365-connectors-end/ Read More