Month: October 2024
If multiple cells are blank return blank, only add if all cells have value
Good morning all and thank you for taking the time to read my post.
I’m new to excel and trying to create a document with some values in of my monthly electricity bill (boring I know lol).
To simplify, I have 3 cells. Let’s call them A1, B1 and C1. These cells contain a value as I input data each month. So, row 1 would be Jan, 2 February etc. up to December. D1 would be my result.
I want to Add together A1+B1+C1 and put that into D1. If however I have no data I want blank “” in D1.
The issue I have is the months I have no data for yet returns #value. I want it to read blank until I input data but I don’t want to copy the formula each time, I want the formula to always stay in the sheet.
I have managed to create a formula for returning blank if I Have 1 cell blank =IF(A1=””,””,A1+B1+C1), but I can’t see how to look at 3 cells for blank. I have tried multiple methods like =IF(A1,B1,C1=””,””,A1+B1+C1) etc but get error messages or #value returned in D1
I hope this makes sense and thank you again.
Good morning all and thank you for taking the time to read my post. I’m new to excel and trying to create a document with some values in of my monthly electricity bill (boring I know lol). To simplify, I have 3 cells. Let’s call them A1, B1 and C1. These cells contain a value as I input data each month. So, row 1 would be Jan, 2 February etc. up to December. D1 would be my result. I want to Add together A1+B1+C1 and put that into D1. If however I have no data I want blank “” in D1. The issue I have is the months I have no data for yet returns #value. I want it to read blank until I input data but I don’t want to copy the formula each time, I want the formula to always stay in the sheet. I have managed to create a formula for returning blank if I Have 1 cell blank =IF(A1=””,””,A1+B1+C1), but I can’t see how to look at 3 cells for blank. I have tried multiple methods like =IF(A1,B1,C1=””,””,A1+B1+C1) etc but get error messages or #value returned in D1 I hope this makes sense and thank you again. Read More
Set content-type using logic app standard built-in blob connector
Many users are migrating from logic app consumption to logic app standard to utilize the great features that it provides.
When those users replace the blob managed connector with blob built-in connector, they miss the content-type advanced parameter of the managed create blob action.
For reference: Azure Blob Storage – Managed Connector | Microsoft Learn
The upload blob to storage container built-in action does not have this parameter and the connector determine content-type automatically based on the content of the blob content parameter.
For reference: Azure Blob Storage – Built-in Connector | Microsoft Learn
For users who wants to specify the content-type explicitly, they can pass the following json in the blob content parameter:
{
“$content-type”: “application/octet-stream”,
“$content”: “blob content”
}
The built-in upload blob to storage container will look as follows:
Microsoft Tech Community – Latest Blogs –Read More
Windows 11 Insider Preview 10.0.26120.1930 (ge_release_upr) installation
I found this installation tedious and slow. I hope next Insiders will be less time comsuming. Thanks
I found this installation tedious and slow. I hope next Insiders will be less time comsuming. Thanks Read More
Employment verification and support tickets
We have problems with Employment verification. I think we did everything we found on blogs and even what I got back in two emails from Microsoft, which are the same, it looks like copy and paste.
The funny thing is that they tell me that I have to use an email that is not info, sales, marketing for the contact email and they write me to my personal email email address removed for privacy reasons
When I want to upload another support ticket they tell me that I can’t upload another ticket for the same topic, that I have to provide more information in the one I already have open. When I want to open it I get an error and it tells me that it is not possible to get the ticket data.
This is unbelievable, with Android and Apple we didn’t have even half of the problems we are having with Microsoft. It’s quite frustrating.
Grateful if anyone can help us.
We have problems with Employment verification. I think we did everything we found on blogs and even what I got back in two emails from Microsoft, which are the same, it looks like copy and paste. The funny thing is that they tell me that I have to use an email that is not info, sales, marketing for the contact email and they write me to my personal email email address removed for privacy reasons When I want to upload another support ticket they tell me that I can’t upload another ticket for the same topic, that I have to provide more information in the one I already have open. When I want to open it I get an error and it tells me that it is not possible to get the ticket data. This is unbelievable, with Android and Apple we didn’t have even half of the problems we are having with Microsoft. It’s quite frustrating.Grateful if anyone can help us. Read More
Action pack Azure credits added to new subscription
Hi all – as the title says.
Renewed my action pack (realise it will be the last time im able to do this) – and it automatically created a new subscription in my existing tenant and allocated the monthly credit to said subscription.
I contacted support – and have been getting the run around for approx 3 weeks – chasing down details etc that have no relevance to the question at hand. Its pretty clear that they wont be helping anytime soon.
In the past ive always been able to allocate the monthly credit to this subscription…. but apparently not anymore.
Does anyone know if i can move the credits over to the existing subscription (and if so, how)? or do i need to move the resource groups to the new subscription ?
Hi all – as the title says.Renewed my action pack (realise it will be the last time im able to do this) – and it automatically created a new subscription in my existing tenant and allocated the monthly credit to said subscription. I contacted support – and have been getting the run around for approx 3 weeks – chasing down details etc that have no relevance to the question at hand. Its pretty clear that they wont be helping anytime soon. In the past ive always been able to allocate the monthly credit to this subscription…. but apparently not anymore. Does anyone know if i can move the credits over to the existing subscription (and if so, how)? or do i need to move the resource groups to the new subscription ? Read More
Web based iOS device enrollment – BYOD devices
Hi All,
This is regarding – Web based iOS device enrollment – BYOD devices
We have plan to go with iOS web-based device enrollment for personal iOS and iPad devices, because of the complications involved in the enrollment method “Account driven user enrollment”
There are a few things I need to clarify here, please share your thoughts.
After the device is enrolled, I would like to apply the APP protection policies to Microsoft Apps to protect the corporate data present in mobile devices, so in this case should i need to deploy the Microsoft apps at first from Microsoft Intune? or I can apply the App protection policies directly to the Microsoft Apps already exist in the user’s personal devices?
Please confirm the app deployment through Microsoft Intune is must before we apply the App protection policies to the users ?
If YES for the second question, can I use the option “iOS store App” in the Microsoft Intune to deploy Microsoft Apps to the personal iOS devices enrolled in Intune through web-based enrollment?
Hi All,This is regarding – Web based iOS device enrollment – BYOD devicesWe have plan to go with iOS web-based device enrollment for personal iOS and iPad devices, because of the complications involved in the enrollment method “Account driven user enrollment”There are a few things I need to clarify here, please share your thoughts.After the device is enrolled, I would like to apply the APP protection policies to Microsoft Apps to protect the corporate data present in mobile devices, so in this case should i need to deploy the Microsoft apps at first from Microsoft Intune? or I can apply the App protection policies directly to the Microsoft Apps already exist in the user’s personal devices?Please confirm the app deployment through Microsoft Intune is must before we apply the App protection policies to the users ?If YES for the second question, can I use the option “iOS store App” in the Microsoft Intune to deploy Microsoft Apps to the personal iOS devices enrolled in Intune through web-based enrollment? Read More
Request to Improve Certification Browsing
When searching for certifications or applied skills, can we get a filter to hide ones we have already achieved, and maybe a tag on the cards themselves with a green tick mark to say we have achieved it.
Thank you.
When searching for certifications or applied skills, can we get a filter to hide ones we have already achieved, and maybe a tag on the cards themselves with a green tick mark to say we have achieved it. Thank you. Read More
Double reservastion
Hello! I’m using Microsoft Bookings to take reservations. I have set up a service so that customers can only pick time from one specific employee’s schedule, making sure only one person can reserve at a time. But today, probably due to a large amount of reservation coming in a once, a double reservation occured:
I’ve made sure the service has only one emplyee assigned(Louise), and customers cannot chose others. The reservation also worked for a few months without issue, so it’s probably not setting’s problem. Is this a bug on the Bookings site, or I’m missing something here? Please help me figure this out! Thanks.
Hello! I’m using Microsoft Bookings to take reservations. I have set up a service so that customers can only pick time from one specific employee’s schedule, making sure only one person can reserve at a time. But today, probably due to a large amount of reservation coming in a once, a double reservation occured:I’ve made sure the service has only one emplyee assigned(Louise), and customers cannot chose others. The reservation also worked for a few months without issue, so it’s probably not setting’s problem. Is this a bug on the Bookings site, or I’m missing something here? Please help me figure this out! Thanks. Read More
Set email signatures for all users in Exchange Online?
Is there currently a way to set email signatures for all mailboxes in Exchange Online, without the use of a paid product, and without the use of email flow rules to add disclaimers?
It looks like there used to be a PowerShell module that did it through use of the command Set-MailboxMessageConfiguration. As far as I can tell, that hasn’t worked since the switch to roaming signatures.
I’ve looked at the PS module ExchangeOnlineManagement but that only seems to have a handful of commands, and nothing useful, as far as I can tell. The documentation on that module is a disaster.
Thanks in advance!
Is there currently a way to set email signatures for all mailboxes in Exchange Online, without the use of a paid product, and without the use of email flow rules to add disclaimers? It looks like there used to be a PowerShell module that did it through use of the command Set-MailboxMessageConfiguration. As far as I can tell, that hasn’t worked since the switch to roaming signatures.I’ve looked at the PS module ExchangeOnlineManagement but that only seems to have a handful of commands, and nothing useful, as far as I can tell. The documentation on that module is a disaster. Thanks in advance! Read More
Choosing the Right Microsoft Project Tool
A Simple 4-Step Program to Find the Perfect Solution for Your Team
Finding the right project management tool can be a time-consuming and confusing process. If you don’t want to buy a pig in a poke or spend hours evaluating different tools, then our program is the perfect solution for you.
Join our webinar to explore the available Microsoft Project Management solutions and discover how they address various business needs. Solutions to be evaluated include:
Microsoft Project Desktop Microsoft Project OnlineMicrosoft Planner (formerly Project for the Web)Microsoft Dynamics 365 Project Operations
As a result of the webinar, you will gain:
a high level understanding of the available Microsoft Solutions for Project Managementa clear exemplification on how each solution and its functionalities can attend specific business needsa well defined path forward for you to continue with a deeper understanding and evaluation of the right solution for your need, Steps 2,3 an 4
Discovery Session
How will I benefit from this session?
Book a 1:1 discovery session with proMX to identify your pain points and project management goals. We will deeply analyze your business requirements and provide you an expert consultancy tailored to your needs.
To provide you with maximum service, the discovery session is automatically linked to step 3 and step 4.
A Simple 4-Step Program to Find the Perfect Solution for Your TeamFinding the right project management tool can be a time-consuming and confusing process. If you don’t want to buy a pig in a poke or spend hours evaluating different tools, then our program is the perfect solution for you.Join our webinar to explore the available Microsoft Project Management solutions and discover how they address various business needs. Solutions to be evaluated include: Microsoft Project Desktop Microsoft Project OnlineMicrosoft Planner (formerly Project for the Web)Microsoft Dynamics 365 Project OperationsAs a result of the webinar, you will gain:a high level understanding of the available Microsoft Solutions for Project Managementa clear exemplification on how each solution and its functionalities can attend specific business needsa well defined path forward for you to continue with a deeper understanding and evaluation of the right solution for your need, Steps 2,3 an 4 Discovery SessionHow will I benefit from this session?Book a 1:1 discovery session with proMX to identify your pain points and project management goals. We will deeply analyze your business requirements and provide you an expert consultancy tailored to your needs.To provide you with maximum service, the discovery session is automatically linked to step 3 and step 4. Read More
Problems with custom forms and the new SharePoint list views
Microsoft is pushing the new look for SharePoint lists, and I have an example that seems to affect customs forms size / dimensions:
As you can see, we need to scroll to see the entire windows.
I had a browser that had cached the old list layout, and that displayed the custom form correctly. But as soon as I refreshed a few times, I also got the wrong dimensions here.
I tried to republish the app, but that didn’t help.
Is there a way to fix this, or is it possible to get the old view back?
Microsoft is pushing the new look for SharePoint lists, and I have an example that seems to affect customs forms size / dimensions:As you can see, we need to scroll to see the entire windows.I had a browser that had cached the old list layout, and that displayed the custom form correctly. But as soon as I refreshed a few times, I also got the wrong dimensions here.I tried to republish the app, but that didn’t help.Is there a way to fix this, or is it possible to get the old view back? Read More
Windows 11 Insider Preview 10.0.26120.1930 (ge_release_upr)
Windows 11 Insider Preview 10.0.26120.1930 (ge_release_upr) Telepítési hiba – 0x80070002. Már harmadszor próbálom telepíteni, de visszavonja mindig a módosításokat, és kék képernyővel indul újra, kötet választási lehetőséggel. Ma próbáltam törölni a C:WindowsSoftwareDistribution mappát, és újra próbálom javítás után telepíteni. De a Microsoft munkatársai online sem tudtak segíteni nekem.
Windows 11 Insider Preview 10.0.26120.1930 (ge_release_upr) Telepítési hiba – 0x80070002. Már harmadszor próbálom telepíteni, de visszavonja mindig a módosításokat, és kék képernyővel indul újra, kötet választási lehetőséggel. Ma próbáltam törölni a C:WindowsSoftwareDistribution mappát, és újra próbálom javítás után telepíteni. De a Microsoft munkatársai online sem tudtak segíteni nekem. Read More
Employment verification failed – Fix Now – Not Working
Fix Now button does nothing, or at least not as pictured in your own guide article.
Account Verification side-screen is NOT showing up after clicking on the Fix Now button, as depicted the image in your own article. https://learn.microsoft.com/en-us/partner-center/enroll/verification-responses
Fix Now button just restarts the process of verification, which fails constantly, without specifying what is wrong.
This is an issue that needs to be resolved by Microsoft, there are multiple such reports.
Fix Now button does nothing, or at least not as pictured in your own guide article.Account Verification side-screen is NOT showing up after clicking on the Fix Now button, as depicted the image in your own article. https://learn.microsoft.com/en-us/partner-center/enroll/verification-responsesFix Now button just restarts the process of verification, which fails constantly, without specifying what is wrong.This is an issue that needs to be resolved by Microsoft, there are multiple such reports. Read More
Most widely used SharePoint Framework ISVs from the Store – September 2024
We are excited to see the continuous growth on the submissions of the SharePoint Framework (SPFx) solutions to the app source and on the usage of the SharePoint store for extending experiences for SharePoint, Microsoft Teams and Microsoft Viva. Here are the top 10 most wide used ISVs based on the solution installations from the SharePoint store and/or from Microsoft AppSource during September 2024.
SharePoint Framework is extensibility model for Microsoft Viva, Microsoft Teams, Outlook, Microsoft 365 app and SharePoint (soon also for Copilot). It enables the same code to be used easily across the Microsoft 365 with this widely adopted tooling which uses industry standard tech with easy and automatic SSO and hosting. Usage of SPFx continues to grow steady and we have currently tens of millions of monthly active users in Microsoft 365 on custom extensibility build with SPFx.
Here are the latest roadmap items around SharePoint Framework and store:
Card visualization features and HTML support for Viva Connections quick views with the 1.20 release
Chart card support for the Viva Connections with the SPFx 1.19 release
Deprecation of SharePoint add-in and Azure ACS authentication models – UX powered extensibility should be transformed to us SharePoint Framework powered implementations. Add-in model was introduced back in 2012 and has not really evolved since. This deprecation does not impact SharePoint Framework (SPFx) solutions.
Additional capabilities and features for SharePoint Framework solutions in Microsoft 365 as part of the SPFx 1.18 release.
Enabling Microsoft Viva Connections targeted solutions, powered by SharePoint Framework, in the app source and store – Will be automatically set for suitable SPFx solutions as part of the submission pipeline
Extending SharePoint Framework solutions across the Microsoft 365 with support for Microsoft Teams, Microsoft Viva, Outlook, Microsoft 365 app (Office), SharePoint and more – see the v1.16 release announcement for more details
Alignment of SharePoint Framework solution packaging model with the Microsoft Teams packages – include the best of both worlds and enable SPFx powered solutions across the Microsoft 365
Support for SharePoint Framework solutions in the Microsoft Teams store – no exact schedule, dependent on the previous bullet point
Support SharePoint Framework extensibility for list and library new, edit and view panels
and much more to come…
What about Copilot/AI extensibility story with SPFx? – Yes. Please see following session from Build 2024 for the preview of the upcoming extensibility options with the SPFx in the context of AI – Integrating your bots and Copilot experiences natively into SharePoint and Viva Connections. These will be also covered in our public community calls in autumn 2024.
We are looking forward to more great solutions that enable innovation, and help our customers get more done with Microsoft Viva, Microsoft Teams, SharePoint and more.
These are the ISVs which has the most usage from the SharePoint store during last month:
Accelerator 365 by Reply
Solution details:
Solutions at app source / store
Solution provider: Accelerator 365 by Reply
Sprinklr, Inc.
Solution details:
Solutions at app source / store
Solution provider: Sprinklr, Inc.
Achievers
Solution details:
Solutions at app source / store
Solution provider: Achievers
Ichicraft
Solution details:
Solutions at app source / store
Solution provider: Ichicract
SharePinPoint Apps and IT Services
Solution details:
Solutions at app source / store
Solution provider: SharePinPoint Apps and IT Services
Plumsail
Solution details:
Solutions at app source / store
Solution provider: Plumsail
Envoqon Software
Solution details:
Solutions at app source / store
Solution provider: Envogon Software
SharePoint|sapiens
Solution details:
Solution at app source / store
Solution provider: SharePoint | sapiens
Bloch Engineering
Solution details:
Solutions at app source / store
Solution provider: Bloch Engineering
AQL Technologies
Solution details:
Solutions at app source / store
Solution provider: AQL
Resources
Please see following resources around getting started on building extensibility for Microsoft Teams, Microsoft Viva and SharePoint using SharePoint Framework.
Announcing SharePoint Framework 1.20 with updates on building enterprise extensibility within Microsoft 365
Announcing SharePoint Framework 1.19 with updates on building enterprise extensibility within Microsoft 365
Announcing SharePoint Framework 1.18 with updates for Microsoft Teams, Microsoft Viva and SharePoint
Announcing general availability of SharePoint Framework 1.16 – Enabling SPFx across Microsoft 365 platform
Explore and deploy SharePoint Framework solutions from partners in SharePoint (Microsoft 365)
Overview of the SharePoint Framework
Publish SharePoint Framework applications to the marketplace
Overview of Viva Connections Extensibility
Guidance for implementing partner offerings for Viva Connections with ACEs and custom APIs
Microsoft Learn – Extend Microsoft Viva Connections
SharePoint Framework samples to get started from Microsoft and community – Microsoft 365 & Power Platform Unified Sample Gallery
Happy coding! 🧡
Microsoft Tech Community – Latest Blogs –Read More
Toybox project was removed from the Mesh Toolkit Unity
The latest update to the Mesh Toolkit Unity project removes almost all of the content of the Toybox demo project. Please restore it.
https://github.com/microsoft/Mesh-Toolkit-Unity/commit/678ec280221e21952fe9c15993dd801a0acdd4f7
The latest update to the Mesh Toolkit Unity project removes almost all of the content of the Toybox demo project. Please restore it. https://github.com/microsoft/Mesh-Toolkit-Unity/commit/678ec280221e21952fe9c15993dd801a0acdd4f7 Read More
Export all tables in schema
I’m recently started working in Microsoft Synapse and exploring the templates with tables and need to retrieve a list of all tables from a specific schema in the templates e.g. Automotive. I’ve tried using the DESCRIBE command, but it only gives information about a single table. How can I write a SQL query to list all tables in a schema and export it to CSV?
Is there a specific system view or query I should use in Synapse to achieve this?
Any help would be appreciated.
Thanks in advance!
I’m recently started working in Microsoft Synapse and exploring the templates with tables and need to retrieve a list of all tables from a specific schema in the templates e.g. Automotive. I’ve tried using the DESCRIBE command, but it only gives information about a single table. How can I write a SQL query to list all tables in a schema and export it to CSV? Is there a specific system view or query I should use in Synapse to achieve this? Any help would be appreciated.Thanks in advance! Read More
Windows 11 Insider Preview 10.0.26120.1930 (ge_release_upr)
Dear sir
I am not able to update current version of windows 11 to Windows 11 Insider Preview 10.0.26120.1930 (ge_release_upr)
the version currently i am using is under
Edition Windows 11 Home Single Language
Version 24H2
Installed on 04/04/2024
OS build 26120.1912
Experience Windows Feature Experience Pack 1000.26100.28.0
Dear sir I am not able to update current version of windows 11 to Windows 11 Insider Preview 10.0.26120.1930 (ge_release_upr)the version currently i am using is underEdition Windows 11 Home Single LanguageVersion 24H2Installed on 04/04/2024OS build 26120.1912Experience Windows Feature Experience Pack 1000.26100.28.0 Read More
What is the fastest way to transfer photos from Android to PC on Windows 11?
The storage of my Android phone (Samsung Galaxy S22) is almost full and I need to backup my photos to my Windows 11 computer. I tried to connect via USB but not all photos are in the DCIM folder. In addition, there are 5000+ photos and images on my phone. I want to know what is the fastest way to transfer photos from Android to PC on my Windows 11 computer.
P.S. I also tested a few solutions from search engine but those methods are too old and not working now. Please suggest a reliable and fast method for bulk photo transfer from Android phone to computer.
Thanks
The storage of my Android phone (Samsung Galaxy S22) is almost full and I need to backup my photos to my Windows 11 computer. I tried to connect via USB but not all photos are in the DCIM folder. In addition, there are 5000+ photos and images on my phone. I want to know what is the fastest way to transfer photos from Android to PC on my Windows 11 computer. P.S. I also tested a few solutions from search engine but those methods are too old and not working now. Please suggest a reliable and fast method for bulk photo transfer from Android phone to computer. Thanks Read More
Issue Adding Iframes in SharePoint Pages
Hello everyone,
We are currently facing an issue when trying to add iframes to our SharePoint pages. We receive the following message: “We cannot insert this HTML code because it contains an unsecured script.”
We have already configured and allowed the necessary URLs in the “HTML Field Security” settings. However, the problem persists.
Has anyone encountered a similar issue or can provide guidance on how to resolve this? Any help would be greatly appreciated!
Thank you!
Hello everyone, We are currently facing an issue when trying to add iframes to our SharePoint pages. We receive the following message: “We cannot insert this HTML code because it contains an unsecured script.” We have already configured and allowed the necessary URLs in the “HTML Field Security” settings. However, the problem persists. Has anyone encountered a similar issue or can provide guidance on how to resolve this? Any help would be greatly appreciated! Thank you! Read More
SQL server management studio 20.2 wrong french translation parameter in sql jobs
Hi,
I’m in front of a little problem.
I have created a SSIS package with VS2019, in which i have implemented an input boolean parameter
I have deploy the package on a SQL server 2022, used with SSMS 20.2 in french.
But when i want to configuration the parameter in the SQL Job, the translation of the boolean is wrong.
I have the choice between FALSE and VRAI (True translated in french.)
If i choose “VRAI”, i get a error saying that it is not a valid value for a boolean parameter.
Does anyone have a solution?. Maybe there’s an update that correct this issue.
Help would be really useful
Thank you
Best regards
Hi,I’m in front of a little problem.I have created a SSIS package with VS2019, in which i have implemented an input boolean parameterI have deploy the package on a SQL server 2022, used with SSMS 20.2 in french.But when i want to configuration the parameter in the SQL Job, the translation of the boolean is wrong.I have the choice between FALSE and VRAI (True translated in french.)If i choose “VRAI”, i get a error saying that it is not a valid value for a boolean parameter.Does anyone have a solution?. Maybe there’s an update that correct this issue.Help would be really usefulThank youBest regards Read More