Month: September 2024
Dax referenced measures causes performance issues
Hi,
I have created a dax measure as below:
VT_Targetunitrate_2 =
SUMX ( Accruals, IF ( [Accrual cost source_2] = “Target”, [Switch Cost] ) )
I also tried using calculate but i am not able to apply the filter condition because [Accrual cost source_2] is a dax measure
FYI, Accrual Cost Source_2 & Switch cost in above dax code are both separate measures as below:
[Priority 1],[Priority 2] , [Priority 3] & Parameter Value cost are in turn referenced measures.
But this takes a lot of time to run in visual and its causing performance issues.
PFA file here Financial Management -Tanvi Trial.pbix
Can you please help how to improve performance as this is only a sample file with few million rows.
Please let me know if you need further info!
Thanks in advance!
Hi, I have created a dax measure as below: VT_Targetunitrate_2 =SUMX ( Accruals, IF ( [Accrual cost source_2] = “Target”, [Switch Cost] ) ) I also tried using calculate but i am not able to apply the filter condition because [Accrual cost source_2] is a dax measure FYI, Accrual Cost Source_2 & Switch cost in above dax code are both separate measures as below: [Priority 1],[Priority 2] , [Priority 3] & Parameter Value cost are in turn referenced measures. But this takes a lot of time to run in visual and its causing performance issues. PFA file here Financial Management -Tanvi Trial.pbixCan you please help how to improve performance as this is only a sample file with few million rows. Please let me know if you need further info! Thanks in advance!@SergeiBaklan Read More
YouTube videos disappearing when clicked in sharepoint
Hi, I have a SharePoint page with short YouTube videos. They keep disappearing when trying to click them to play. Sometimes though they stay, but mostly they disappear. I have taken a video of this happening, if that would help explain what I mean. Any ideas on how to stop this happening please? Thanks.
Hi, I have a SharePoint page with short YouTube videos. They keep disappearing when trying to click them to play. Sometimes though they stay, but mostly they disappear. I have taken a video of this happening, if that would help explain what I mean. Any ideas on how to stop this happening please? Thanks. Read More
Check VMSS Scale Mode via PowerShell
Hello:
Can someone please suggest how I can check the scale mode in my VMSS (Virtual machine scale set) via Powershell?
Ideally, I want to see if it’s manual or auto and number of max Instances…
Thank you!
Hello: Can someone please suggest how I can check the scale mode in my VMSS (Virtual machine scale set) via Powershell? Ideally, I want to see if it’s manual or auto and number of max Instances… Thank you! Read More
Activating MS Authenticator for MS365
Hello, is anyone familiar on how to reactivate MS365 Authenticator on new iPhone? I recently changed iPhones and my old authenticator did not transfer over. I have my login credentials but can’t fully login as I don’t have the two step authentication. I have been trying to get assistance from Microsoft support, but they keep hanging up on me. I would appreciate some assistance with this issue, thanks in advance.
Hello, is anyone familiar on how to reactivate MS365 Authenticator on new iPhone? I recently changed iPhones and my old authenticator did not transfer over. I have my login credentials but can’t fully login as I don’t have the two step authentication. I have been trying to get assistance from Microsoft support, but they keep hanging up on me. I would appreciate some assistance with this issue, thanks in advance. Read More
Messages didn’t moved to new folder
Hi there! I have created a new rule, which should move new messages from one sender to the new folder. But for some reason my old messages are still in Inbox, although I’ve pointed that arrived messages should be in the new folder too.Can anyone help?
Hi there! I have created a new rule, which should move new messages from one sender to the new folder. But for some reason my old messages are still in Inbox, although I’ve pointed that arrived messages should be in the new folder too.Can anyone help? Read More
Converting a Classic Sharepoint Hub to a Modern Hub
Hi there,
Our organization has a dated SharePoint hub that still uses the Classic Sharepoint interface and appearance. Interestingly, new pages and subsites that are created immediately assume the Modern appearance.
We’d like to adapt our Classic hub site (that is, our site that all employees are directed to, located at https://ORGANIZATION-NAME.sharepoint.com) to the Modern look. Whether this means creating it from scratch or doing some conversion, I wanted to ask for some guidance.
If we convert:
What happens to pages and document libraries that were created using Sharepoint classic? Are these converted, too? Are they lost?How do we convert the site?We have seen information such as ‘connect to a Microsoft365 Team to convert to modern,’ but we do not see this button anywhere. Our site is already connected to a Microsoft365 Team.We have a custom theme that was built into Sharepoint classic. What happens to this theme if we convert to modern? Is it lost, does it need to be recreated?
If we create a new site:
How do we assign our Sharepoint hub url (that is, the URL https://ORGANIZATION-NAME.sharepoint.com) to the new site we create?How do we make the new hub site the “parent” to subsites?
Thank you all!
Hi there, Our organization has a dated SharePoint hub that still uses the Classic Sharepoint interface and appearance. Interestingly, new pages and subsites that are created immediately assume the Modern appearance. We’d like to adapt our Classic hub site (that is, our site that all employees are directed to, located at https://ORGANIZATION-NAME.sharepoint.com) to the Modern look. Whether this means creating it from scratch or doing some conversion, I wanted to ask for some guidance. If we convert:What happens to pages and document libraries that were created using Sharepoint classic? Are these converted, too? Are they lost?How do we convert the site?We have seen information such as ‘connect to a Microsoft365 Team to convert to modern,’ but we do not see this button anywhere. Our site is already connected to a Microsoft365 Team.We have a custom theme that was built into Sharepoint classic. What happens to this theme if we convert to modern? Is it lost, does it need to be recreated?If we create a new site:How do we assign our Sharepoint hub url (that is, the URL https://ORGANIZATION-NAME.sharepoint.com) to the new site we create?How do we make the new hub site the “parent” to subsites?Thank you all! Read More
Discover how Azure HPC can improve patient outcomes
1McKinsey & Company, The next frontier of healthcare delivery, 2022.
2Sesterce, Unleashing the Power of HPC in Healthcare: A Digital Odyssey, 2024.
3Accenture, Unleashing the power of unstructured data, 2021.
4Trend Micro, Quarter of Healthcare Ransomware Victims Forced to Halt Operations, 2022.
Microsoft Tech Community – Latest Blogs –Read More
Session Recording
Hi,
I missed the first 20 minutes. Is this being recorded and if so can it be shared with me?
Hi, I missed the first 20 minutes. Is this being recorded and if so can it be shared with me? Read More
CNTRL + up/down not working along with certain fn keys and I tried to troubleshoot keyboard
Hi, I am in the process of learning quicker ways around excel and for some reason my cntrl up/down doesn’t work but left right does. Certain fn commands also don’t work like shift fn f8. I troubleshooted the keyboard and made sure scroll lock is off but still no dice.
Hi, I am in the process of learning quicker ways around excel and for some reason my cntrl up/down doesn’t work but left right does. Certain fn commands also don’t work like shift fn f8. I troubleshooted the keyboard and made sure scroll lock is off but still no dice. Read More
Using site templates for SharePoint in Microsoft 365
SharePoint site templates come in all shapes and sizes, save time and address numerous scenarios, and provide an opportunity to programmatically adhere to your organization’s preferred custom site creation policies.
Using a template when creating SharePoint sites improves efficiency and helps standardize site creation. While templates provide a starting point, they are customizable to adapt them to specific needs of a project or team. As your organization grows, templates make it easier to deploy new sites quickly and efficiently, with governance to ensure features and settings comply with organizational policies or industry regulations.
Select “+ Create site” on the SharePoint start page and choose between a Team site or a Communication site (pictured). Then, select the template that you want to use to create your new site – out-of-the-box or custom.
At their core, SharePoint site templates contain pre-populated pages, page templates, news post templates, themes, and web parts. When you create a site, you choose from either a Communication site or a Team site, and then select the site template that matches your desired outcome. You will find numerous site templates available directly within the service, ready to use. You can create and deploy your own custom site templates – for reuse within your tenant. And take advantage of custom PnP site templates from GitHub – implemented via PowerShell.
This article aims to highlight what’s possible, share what’s new, and clarify where and how you get, deploy, and use SharePoint site templates in Microsoft 365.
Use and adopt SharePoint site templates directly from SharePoint service within Microsoft 365.
Much of what we’ve learned about SharePoint site templates, and developed for use in production, now resides within the Microsoft 365 commercial service – meaning many of the deployable site templates are now available to choose from during the standard, out-of-the-box + Create site process – in SharePoint. These templates make it easy to create a SharePoint site. They demonstrate the art of what’s possible with design-focused layouts and content to save you time (and heartache 😉).
To get a broad overview of what’s available, review the SharePoint Look Book page – now hosted on adoption.microsoft.com (recently updated; more on the original look book website below). This page highlights the value of each site and breaks down what gets created for you when applying the various templates. And we published an important related Help article to learn how to apply and customize SharePoint site templates, including several guided walkthroughs to familiarize yourself with how to create sites for your organization. Below are two site template examples:
IT help desk (Team site template)
The ‘IT help desk’ template helps manage technical requests, track devices, and share training materials.
Learning central (Communication site template)
The ‘Learning central’ template provides a landing experience for your organization’s learning opportunities.
As with all our other Microsoft-provided site templates, these are automatically available in SharePoint tenants and can be applied by users with site owner permissions or higher. When you create a new site, you will be asked if you’d like to use a template. Select Browse templates to see Microsoft templates and templates from your organization. Additionally, we’ve released the site template history panel. Site owners will be able to access the Site information panel from within Settings, and then select View template history. A history of all site templates previously applied to the site will then be displayed. Selecting an entry will display all site script actions and if they ran successfully or encountered errors. Whether you’re creating a new site or applying a template to an existing site, navigate to Settings and then select Apply a site template.
Learn how to create SharePoint sites in Microsoft 365 and apply and customize SharePoint site templates.
Create your own custom site templates.
Custom templates made by your organization using site scripts will display in the site template gallery based on the type of site a user chose to start with – either a communication site or team site. Therefore, it is likely that all the custom site templates will not appear in the site template gallery at once. Soon, users will have the ability to choose to view all custom site templates in the From your organization tab regardless of the type of site chosen.
Site templates provided by your organization will appear in the From your organization tab when selecting a template type. Customization instructions will vary depending on the site template design. Review customization resources below to learn more about site personalization options.
You can create site templates to provide reusable lists, themes, layouts, pages, or custom actions so that your users can quickly build new SharePoint sites with the features they need. Learn more about how to create custom site templates for your organization.
Learn more about configuring and deploying SharePoint site template and site scripts.
Deploying scenario-based solutions with custom PnP site templates from the GitHub repository.
Explore additional scenario-based solutions with custom PnP* site templates found in the GitHub repository. Several custom site templates exist for you to utilize and are standardized for how to implement into your own environment using PowerShell.
*PnP stands for Patterns & Practices.
View available custom PnP SharePoint site templates in GitHub.
Learn how to apply custom PnP SharePoint site templates.
The following video by Microsoft MVP, Paolo Pialorsi, shows you how to provision custom PnP site templates from the GitHub repository, in this instance using the example of the ‘Learning Pathways’ site template. Watch now:
The move away from the original lookbook.microsoft.com website.
Previously, Microsoft maintained a website at lookbook.microsoft.com – where tenant admins could select scenario-based templates and deploy them – from this website directly into their own tenant. The website’s DNS registration has expired and no longer resolves. We understand this is not ideal. Going forward, Microsoft is investing in the SharePoint Look Book page on adoption.microsoft.com; we created a new aka.ms link: aka.ms/SharePointLookBook to take you directly to this page.
The SharePoint Look Book page on adoption.microsoft.com is our primary destination to display SharePoint site templates, including ones you can find in GitHub and provision using PowerShell.
I would like to thank two Microsoft MVPs and community members, Tracy van der Schyff and Marc Anderson – for sharing their thoughts and insights with everyone during this change. We aim to highlight the value of SharePoint site templates and improve Microsoft change management communications. Here are what Tracy and Marc published in support of adding clarity during this update:
“Recent changes to the #SharePoint Look Book” by Tracy van der Schyff.
“SharePoint Lookbook: What’s happened to it?” by Marc Anderson.
In the end…
In summary, templates serve as a blueprint for creating new SharePoint sites, ensuring that they are set up quickly, consistently, and with best practices in mind. They offer a balance between uniformity and customization, making it easier to manage and scale SharePoint environments within an organization.
We hope the above helps you get informed in all the ways SharePoint site templates help you save time and ground what SharePoint can do for you and your organization – be it through use site templates from within the service, custom site templates you create and deploy, or if you benefit from custom site templates from the GitHub repository.
Discover what’s possible, save time, and remember: Make it your own. SharePoint site templates are a map; you are the trailblazing guide!
Thanks, Mark Kashman, Senior Product Manager – Microsoft
Microsoft Tech Community – Latest Blogs –Read More
Azure Database for MySQL – August 2024 updates and latest feature roadmap
We’re excited to share a summary of the Azure Database for MySQL – Flexible Server announcements from last month, as well as the latest roadmap of upcoming features!
September 2024 Live webinar
These updates and the latest roadmap are also covered in our Monthly Live Webinar on YouTube (Click here to subscribe to our YouTube channel!), which streams the second Wednesday of every month, at 7:30 AM Pacific time. Below is a link to the session recording of the live webinar we delivered last week:
August 2024 updates and announcements
Flexible maintenance options for Azure Database for MySQL flexible servers (General Availability)
The new flexible maintenance options enable greater control over the timing of the maintenance activities performed on Azure Database for MySQL flexible server instances, so that you can align maintenance schedules with your operational needs. After receiving a maintenance notification, you can reschedule it to a more convenient time, irrespective of whether it was system or custom managed. Since we released this feature in public preview last year, we’ve incorporated several important updates and feedback to ensure a smoother and more flexible experience.
Key enhancements in GA include:
Expanded Reschedule Window: The reschedule window has been extended to cover all available maintenance dates within the region (ensuring up to 30-day reschedule windows), offering much more flexibility compared to the limited 14-day window from the public preview.
Reschedule via Azure CLI: You can now reschedule maintenance activities through the Azure CLI. This provides flexibility and automation for managing maintenance windows across multiple servers.
Learn more: Announcement Blog | Documentation | Demo video
Latest feature roadmap
Feature
Description
Release status
Coming soon!
(Tentative*)
On-demand backup and export
This feature provides you with the ability to export at-moment physical backup of the server to an Azure storage account (Azure blob storage) using an Azure CLI command. After export, these backups can be used for data recovery, migration, data redundancy and availability, or auditing. Learn more.
Public Preview
General Availability
in Q4 CY24
Long Term Retention of Backups
Previously with Azure Database for MySQL, you could retain automated backups and on-demand backups for up to 35 days. With Long Term Retention, you can now retain the backups up to 10 years, further accommodating your audit and compliance needs. Learn more.
Public Preview
General Availability
in Q4 CY24
MySQL Discovery & Assessment in Azure Migrate
With this functionality, you can use Azure Migrate to discover MySQL servers in your environment, assess them by identifying their compatibility for moving to Azure Database for MySQL, and receive compute and storage SKU recommendations along with their costs. Learn more.
Private Preview
Public Preview
in Q4 CY24
CMK-enabled support for Accelerated Logs
Accelerated Logs, available with the Business Critical service tier and designed for mission-critical workloads, is a feature provides an increase in throughput of up to two times (2x) for your applications at no additional cost. The feature will soon be supported on servers that have Customer Managed Keys (CMK) enabled.
–
General Availability
in Q4 CY24
Azure DB for MySQL bindings in Azure Functions
This new feature will ensure native support for input bindings, output bindings and a function trigger for Azure DB for MySQL – Flexible Server. That is, you will be able to read data from an Azure DB for MySQL database into a function, save data back to the Azure DB for MySQL database or even trigger a function when a change is detected on a MySQL table!
–
Public Preview
in Q4 CY24
Error Logs (in Server Logs)
This feature allows you to maintain MySQL error log files under Server logs and download them for up to seven days. These error logs can help you efficiently identify and troubleshoot performance and reliability issues, and proactively detect and respond to unauthorized access attempts, failed login attempts, and other security-related events. Learn more.
Public Preview
General Availability
in Q1 CY25
Virtual Canary
The Virtual Canary feature is an exciting solution for Azure MySQL users who prioritize staying at the forefront of technology by making sure that their servers always run the most current version. Servers opted in for virtual canary receive maintenance updates earlier in advance. You can also take advantage of the feature as an opportunity to perform an additional layer of update testing on your dev, test, or staging servers to help avoid workload-specific issues like application-level compatibility issues. The feature thus offers an efficient way to manage updates, align testing and production environments, and maintain operational stability with minimal disruption.
–
Public Preview
in Q1 CY25
Near-zero downtime maintenance for HA servers
This feature is designed to substantially reduce maintenance downtime for HA-enabled servers, ensuring that in most cases, maintenance downtime is expected to be between 40 to 60 seconds. This capability is pivotal for businesses that demand high availability and minimal interruption in their database operations. Learn more.
Public Preview
General Availability
in Q1 CY25
*The roadmap features and dates are tentative and subject to change. Please stay tuned for continuous updates.
Conclusion
As we continue to work on new features and functionalities, your feedback is very critical for our improvement. If you wish to enroll in Private Preview for any of the above features, or if you have any suggestions for or queries about our service, email us at AskAzureDBforMySQL@service.microsoft.com.
To learn more about what’s new with Flexible Server, see What’s new in Azure Database for MySQL – Flexible Server. Stay tuned for more updates and announcements by following us on social media: YouTube | LinkedIn | X.
Microsoft Tech Community – Latest Blogs –Read More
IF OR AND Formula returning False value
Hello, reaching out for assistance with this formula. I am expecting a calculated value but I an only getting False. What I would really like to do is have the formula check if the cell contains “Officer” so that I don’t have to keep adding in the different possible variations. Ultimately, if the H6 is Officer or First Officer and the D equals Los Angeles, multiply by 1.5, all else, multiply by 2. Any assistance is appreciated.
=IF(OR(H6=”Officer”,H6=”First Officer”), IF(AND(D6=”Los Angeles”), 1.5*SUM(K6:L6)+SUM(N6:O6)/100*M6+SUM(N6:O6)/100*2*SUM(K6:L6)+2*R6+SUM(M6,P6,Q6,S6,T6,U6),
2*SUM(K6:L6)+SUM(N6:O6)/100*M6+SUM(N6:O6)/100*2*SUM(K6:L6)+2*R6+SUM(M6,P6,Q6,S6,T6,U6)))
Hello, reaching out for assistance with this formula. I am expecting a calculated value but I an only getting False. What I would really like to do is have the formula check if the cell contains “Officer” so that I don’t have to keep adding in the different possible variations. Ultimately, if the H6 is Officer or First Officer and the D equals Los Angeles, multiply by 1.5, all else, multiply by 2. Any assistance is appreciated. =IF(OR(H6=”Officer”,H6=”First Officer”), IF(AND(D6=”Los Angeles”), 1.5*SUM(K6:L6)+SUM(N6:O6)/100*M6+SUM(N6:O6)/100*2*SUM(K6:L6)+2*R6+SUM(M6,P6,Q6,S6,T6,U6),2*SUM(K6:L6)+SUM(N6:O6)/100*M6+SUM(N6:O6)/100*2*SUM(K6:L6)+2*R6+SUM(M6,P6,Q6,S6,T6,U6))) Read More
Download File – Sharepoint / MS Graph
Hello good evening,
I’ve been working on a problem for quite a while now and can’t get any further. I hope someone here can help me.
Initial situation:
I have a sharepoint page.
This page contains lists.
These lists contain text columns and also image columns.
The lists receive data from Powerapps.
So far so good. It works.
Now I am working on the implementation of a programme that will run on a server. This programme retrieves the data from the lists regularly.
I use Microsoft Graph to retrieve the lists. That also works. So token, graphclient, communication etc. are all good.
But: For the image column I only get a json back, which contains the server url and also the relative url. If I put the url together and call it up via the browser, I can also see the image.
Well, I thought to myself. Then I download the image directly via Http and save it accordingly, but that doesn’t work! I always get the error 401 – Unauthorised.
I load my Http client with the appropriate header and the token which is also valid.
I had created the app in the Azure Entra and also set the authorisations accordingly. Files.Read.All, Files.ReadWrite.All, Sites.Read.All, Sites.ReadWrite.All, Sites.Selected.
Retrieving the list and processing it with MS Graph also works. It’s just a matter of downloading the image file 😞
I use C#.
AuthenticationResult tokenMSAL = getToken();
using (HttpClient httpClient = new HttpClient())
{
httpClient.DefaultRequestHeaders.Authorisation = new AuthenticationHeaderValue(‘Bearer’, tokenMSAL.AccessToken);
// Download the image and save it
var img = httpClient.GetAsync(signatureUrl).GetAwaiter().GetResult();
As I am at a loss at the moment and have already invested a lot of time, I hope that someone here can give me an alternative solution or knows which authorisation must be set for the download to work.
Thank you very much and have a nice evening!
Greetings Manu
Hello good evening,I’ve been working on a problem for quite a while now and can’t get any further. I hope someone here can help me. Initial situation:I have a sharepoint page.This page contains lists.These lists contain text columns and also image columns.The lists receive data from Powerapps.So far so good. It works. Now I am working on the implementation of a programme that will run on a server. This programme retrieves the data from the lists regularly.I use Microsoft Graph to retrieve the lists. That also works. So token, graphclient, communication etc. are all good.But: For the image column I only get a json back, which contains the server url and also the relative url. If I put the url together and call it up via the browser, I can also see the image.Well, I thought to myself. Then I download the image directly via Http and save it accordingly, but that doesn’t work! I always get the error 401 – Unauthorised.I load my Http client with the appropriate header and the token which is also valid.I had created the app in the Azure Entra and also set the authorisations accordingly. Files.Read.All, Files.ReadWrite.All, Sites.Read.All, Sites.ReadWrite.All, Sites.Selected.Retrieving the list and processing it with MS Graph also works. It’s just a matter of downloading the image file 😞 I use C#. AuthenticationResult tokenMSAL = getToken();using (HttpClient httpClient = new HttpClient()){httpClient.DefaultRequestHeaders.Authorisation = new AuthenticationHeaderValue(‘Bearer’, tokenMSAL.AccessToken);// Download the image and save itvar img = httpClient.GetAsync(signatureUrl).GetAwaiter().GetResult(); As I am at a loss at the moment and have already invested a lot of time, I hope that someone here can give me an alternative solution or knows which authorisation must be set for the download to work. Thank you very much and have a nice evening!Greetings Manu Read More
Intune Decks
Hello Partner Community – I am in search of Intune PowerPoint decks and wondering if anyone has links handy or can point me in the right direction.
Any type of deck would be great (pitch deck, overview), but I am also looking specifically for more technical focused decks on Intune that might cover configuration profiles, endpoint security configuration, app deployment, device enrollment, Autopilot, etc.
Thanks!
Hello Partner Community – I am in search of Intune PowerPoint decks and wondering if anyone has links handy or can point me in the right direction. Any type of deck would be great (pitch deck, overview), but I am also looking specifically for more technical focused decks on Intune that might cover configuration profiles, endpoint security configuration, app deployment, device enrollment, Autopilot, etc. Thanks! Read More
Not for profit password reset support
Hello. I was recently successful I setting up a Microsoft not for profit account for a community organisation I volunteer for. I have however had trouble logging in an asking for a password reset. I had been emailing the support team but they have not been replying to my emails as they said they couldnt verify my identity even though I provided them with everything they asked for. I am just trying to find out who I need to speak and what I need to do to reset the password as on the login screen there is no “reset password link” and the password I originally set doesn’t work. Any help with this much appreciated as I am doing this voluntarily and what I thought would be a very simple request is turning out to be very time-consuming. Many thanks
Hello. I was recently successful I setting up a Microsoft not for profit account for a community organisation I volunteer for. I have however had trouble logging in an asking for a password reset. I had been emailing the support team but they have not been replying to my emails as they said they couldnt verify my identity even though I provided them with everything they asked for. I am just trying to find out who I need to speak and what I need to do to reset the password as on the login screen there is no “reset password link” and the password I originally set doesn’t work. Any help with this much appreciated as I am doing this voluntarily and what I thought would be a very simple request is turning out to be very time-consuming. Many thanks Read More
Excel date formula for AM & PM at same date (for one month)
Hello, I saw in format Cells you can select date / 4/3/12 1:30PM and then go agan in the cell to personalize, but how it is working to have for instance 01/10/2024 AM and 01/10/2024 PM (… for the month)?
Hello, I saw in format Cells you can select date / 4/3/12 1:30PM and then go agan in the cell to personalize, but how it is working to have for instance 01/10/2024 AM and 01/10/2024 PM (… for the month)? Read More
Nesting IF formulas in same cell
I’m not great at writing formulas and usually find answers on forums like this to help me. I’m trying to put two formulas in one cell.
My issue:
Goal 1. I want to only add two cells if they both have values (i have figured out the formula for this: =IF(OR(ISBLANK(K14),ISBLANK(I14)),””,K14-I14 and it works fine.
Goal 2. I want to format the cell to subtract time to get total shift time, even if it’s after midnight. The problem here is, it won’t calculate correctly if the time goes after midnight. Example: shift started at 11 pm, and ended at 1 am… I have to enter a special formula to correctly formula after midnight. I do have a working formula for that: IF(I15>K15,K15+1,K15)-I15
NOW…. how do combine both formulas so I get the total if both values are present ANNNND format it correctly if the time goes past midnight.
My brain hurts – please help
I’m not great at writing formulas and usually find answers on forums like this to help me. I’m trying to put two formulas in one cell. My issue: Goal 1. I want to only add two cells if they both have values (i have figured out the formula for this: =IF(OR(ISBLANK(K14),ISBLANK(I14)),””,K14-I14 and it works fine. Goal 2. I want to format the cell to subtract time to get total shift time, even if it’s after midnight. The problem here is, it won’t calculate correctly if the time goes after midnight. Example: shift started at 11 pm, and ended at 1 am… I have to enter a special formula to correctly formula after midnight. I do have a working formula for that: IF(I15>K15,K15+1,K15)-I15 NOW…. how do combine both formulas so I get the total if both values are present ANNNND format it correctly if the time goes past midnight. My brain hurts – please help Read More
Find Hardware/firmware details for a specific device using API
My customer wants to see the Hardware/firmware and Software information for a specific device using PowerApp/Power Automate by leveraging MDE API.
There is a specific API call to get the software by device
GET /api/machines/{machineId}/software
But there is no similar API call to get hardware/Firmware info for a specific device. We only have
GET api/machines/HardwareFirmwareInventoryByMachine
GET /api/machines/HardwareFirmwareInventoryExport
However, these dont support any filtering. My customer is a large customer. Downloading the full list with pagination and filtering separately in real time is not an option. Is there an easier way to get hardware/firmware information for a device directly in the API call?
My customer wants to see the Hardware/firmware and Software information for a specific device using PowerApp/Power Automate by leveraging MDE API.
There is a specific API call to get the software by device
GET /api/machines/{machineId}/software
But there is no similar API call to get hardware/Firmware info for a specific device. We only have
GET api/machines/HardwareFirmwareInventoryByMachine
GET /api/machines/HardwareFirmwareInventoryExport
However, these dont support any filtering. My customer is a large customer. Downloading the full list with pagination and filtering separately in real time is not an option. Is there an easier way to get hardware/firmware information for a device directly in the API call?
Read More
Planner for Legal and DMS Integrations
Hi there,
Like the look of the new templates. Is Planner suitable for regulated industries like law? And does planner integrate with other document systems, or just Sharepoint/OneDrive?
Thanks
Hi there, Like the look of the new templates. Is Planner suitable for regulated industries like law? And does planner integrate with other document systems, or just Sharepoint/OneDrive? Thanks Read More
Are you happy and successful with Dynamics?
I’d love to chat with a mid-sized nonprofit (in the 20-50 staff range +/-) that is up and running with Dynamics (whether or not they are using F&E), using it across more than one department, and generally satisfied with how things are going.
I’m curious how much customization is in place, how much iteration has happened since go-live, what your tech stack looks like, how much is managed internally by an admin vs externally by a partner/managed services, and the LOE for getting an admin up to speed and/or expectations for ongoing partner support (cost, hours per month, etc).
To be totally transparent, we have found Dynamics more difficult to work in than expected and would like to understand from others whether our expectations are realistic or not. Thanks in advance to anyone willing to chat!
I’d love to chat with a mid-sized nonprofit (in the 20-50 staff range +/-) that is up and running with Dynamics (whether or not they are using F&E), using it across more than one department, and generally satisfied with how things are going. I’m curious how much customization is in place, how much iteration has happened since go-live, what your tech stack looks like, how much is managed internally by an admin vs externally by a partner/managed services, and the LOE for getting an admin up to speed and/or expectations for ongoing partner support (cost, hours per month, etc). To be totally transparent, we have found Dynamics more difficult to work in than expected and would like to understand from others whether our expectations are realistic or not. Thanks in advance to anyone willing to chat! Read More
