Category: Microsoft
Category Archives: Microsoft
Formatting View in List based on criteria
Hi all,
I have a SharePoint list in which I would like to create a formatting view on row-level. I want to achieve that the rows will be visualized red when the Urgency is set to ‘Oplossen binnen <6 maanden’ (English (Solve in 6 months), the status is unequal to ‘Gereed’ (English: Done) and the item has been there for over 6 month checking to the date it is created.
I used following syntax but unfortunately nothing happens. Can someone help me with this?
{
“$schema”: “https://developer.microsoft.com/json-schemas/sp/v2/row-formatting.schema.json“,
“additionalRowClass”: “=if([$Urgentie] == ‘Oplossen binnen <6 maanden’ && [$Status] != ‘Gereed’ && (Number(utcNow()) – Number([$Created])) > 15778800000, ‘ms-bgColor-redDark’, ”)”
}
Hi all, I have a SharePoint list in which I would like to create a formatting view on row-level. I want to achieve that the rows will be visualized red when the Urgency is set to ‘Oplossen binnen <6 maanden’ (English (Solve in 6 months), the status is unequal to ‘Gereed’ (English: Done) and the item has been there for over 6 month checking to the date it is created. I used following syntax but unfortunately nothing happens. Can someone help me with this? {“$schema”: “https://developer.microsoft.com/json-schemas/sp/v2/row-formatting.schema.json”,”additionalRowClass”: “=if([$Urgentie] == ‘Oplossen binnen <6 maanden’ && [$Status] != ‘Gereed’ && (Number(utcNow()) – Number([$Created])) > 15778800000, ‘ms-bgColor-redDark’, ”)”} Read More
My computer beeps and black screen
Sometimes, usually around night time, I’ll hear a sudden beep sound coming from my computer. It’s not a notification beep or an error beep. It’s happened multiple times, and I’m not sure what’s causing it. Sometimes the beep is accompanied by a brief black screen or a flicker, but other times it just disappears as quickly as it started.
The other issue my computer will go to a black screen for a few seconds before reverting back to normal. This has happened even when I’m in the middle of using the computer, and it’s not related to any specific task or program. I’ve tried restarting my computer and checking for updates, but the issues persist. Has anyone else experienced anything similar.
Sometimes, usually around night time, I’ll hear a sudden beep sound coming from my computer. It’s not a notification beep or an error beep. It’s happened multiple times, and I’m not sure what’s causing it. Sometimes the beep is accompanied by a brief black screen or a flicker, but other times it just disappears as quickly as it started. The other issue my computer will go to a black screen for a few seconds before reverting back to normal. This has happened even when I’m in the middle of using the computer, and it’s not related to any specific task or program. I’ve tried restarting my computer and checking for updates, but the issues persist. Has anyone else experienced anything similar. Read More
Outlook not sending notifications?
Hey,
we have this issue since a couple of days that the Outlook Desktop App does not send notifications when a mail arrives.
I checked various settings within Outlook and Windows 10 but nothing seems to work. We made sure that we are not in some sort of Focus Mode and all toggles for notifications are on.
Anyone has other troubleshooting steps?
Hey,we have this issue since a couple of days that the Outlook Desktop App does not send notifications when a mail arrives.I checked various settings within Outlook and Windows 10 but nothing seems to work. We made sure that we are not in some sort of Focus Mode and all toggles for notifications are on.Anyone has other troubleshooting steps? Read More
E2 365 for Non profits has expired – how to change to/ purchase E1
Our organization E2 will be expired on 22 August, and we have received notification from email address removed for privacy reasons that they would reach out to us within 1 week after we had contact them. But till now we haven’t got any news from them. So what we should do now? Thank you for your help.
Our organization E2 will be expired on 22 August, and we have received notification from email address removed for privacy reasons that they would reach out to us within 1 week after we had contact them. But till now we haven’t got any news from them. So what we should do now? Thank you for your help. Read More
how to set the icon with text under conditional formula?
hi
Can please advise how to set based on the legend
When I input 0 to display color icon with text at the side and and rest.
Thank you
hi Can please advise how to set based on the legendWhen I input 0 to display color icon with text at the side and and rest.Thank you Read More
Save button disabled when trying to add a custom app from a meeting extension
Hi Everyone,
I need help with custom apps. I am trying to add a custom app to an in-progress meeting from the add apps button on the meeting ribbon, I was able to see my custom app when I hit the button, but when I try to add, the Save button is greyed out.
Am I missing any configurations to save the app and get it pinned on the ribbon?
Also,
I want my custom app to show up on the meeting ribbon automatically for certain users when the meeting starts. Is there a place to add the user accounts to whom this app should be visible?
Thank you!
Hi Everyone, I need help with custom apps. I am trying to add a custom app to an in-progress meeting from the add apps button on the meeting ribbon, I was able to see my custom app when I hit the button, but when I try to add, the Save button is greyed out. Am I missing any configurations to save the app and get it pinned on the ribbon? Also,I want my custom app to show up on the meeting ribbon automatically for certain users when the meeting starts. Is there a place to add the user accounts to whom this app should be visible? Thank you! Read More
How to fix Q.B Desktop 2024 Keeps Crashing after update?
I’ve been experiencing frequent crashes with Q.B Desktop 2024. The application shuts down unexpectedly during transactions and updates. I’ve tried reinstalling the software and checking for updates but the problem persists. Has anyone encountered this issue or have suggestions for a fix? Any help would be greatly appreciated!
I’ve been experiencing frequent crashes with Q.B Desktop 2024. The application shuts down unexpectedly during transactions and updates. I’ve tried reinstalling the software and checking for updates but the problem persists. Has anyone encountered this issue or have suggestions for a fix? Any help would be greatly appreciated! Read More
Exploring Microsoft: Innovations and Impact
Welcome to our discussion on Microsoft! In this forum, let’s delve into the diverse facets of Microsoft’s contributions, innovations, and impact across technology and beyond.
Overview of Microsoft’s Influence: Microsoft has been a pioneer in the tech industry since its inception. From operating systems like Windows to productivity tools such as Microsoft Office, the company has significantly shaped how individuals and businesses operate globally.
Advancements in Cloud Computing: Azure, Microsoft’s cloud computing platform, has revolutionized how businesses manage data and applications. Let’s discuss its capabilities, benefits for enterprises, and the future of cloud technology.
Empowering Developers and Innovators: Microsoft Learn offers valuable resources for developers, equipping them with skills in AI, machine learning, and more. How has this platform impacted your career or projects?
Social Impact and Sustainability Initiatives: Beyond technology, Microsoft is committed to societal impact and sustainability. Let’s explore initiatives like AI for Good and their environmental goals. How important are these efforts in shaping Microsoft’s reputation?
Future Outlook: Looking ahead, Microsoft continues to innovate with products like HoloLens and Surface devices. What trends do you foresee in Microsoft’s future developments? How might these innovations impact industries?
Engage and Share: We encourage you to share your experiences, insights, and questions related to Microsoft. Whether you’re a user, developer, or enthusiast, your perspective adds value to our discussion. Let’s explore together how Microsoft is shaping the future of technology and beyond.
Join the conversation and let’s explore the vast world of Microsoft’s innovations and impact together!
Welcome to our discussion on Microsoft! In this forum, let’s delve into the diverse facets of Microsoft’s contributions, innovations, and impact across technology and beyond.Overview of Microsoft’s Influence: Microsoft has been a pioneer in the tech industry since its inception. From operating systems like Windows to productivity tools such as Microsoft Office, the company has significantly shaped how individuals and businesses operate globally.Advancements in Cloud Computing: Azure, Microsoft’s cloud computing platform, has revolutionized how businesses manage data and applications. Let’s discuss its capabilities, benefits for enterprises, and the future of cloud technology.Empowering Developers and Innovators: Microsoft Learn offers valuable resources for developers, equipping them with skills in AI, machine learning, and more. How has this platform impacted your career or projects?Social Impact and Sustainability Initiatives: Beyond technology, Microsoft is committed to societal impact and sustainability. Let’s explore initiatives like AI for Good and their environmental goals. How important are these efforts in shaping Microsoft’s reputation?Future Outlook: Looking ahead, Microsoft continues to innovate with products like HoloLens and Surface devices. What trends do you foresee in Microsoft’s future developments? How might these innovations impact industries?Engage and Share: We encourage you to share your experiences, insights, and questions related to Microsoft. Whether you’re a user, developer, or enthusiast, your perspective adds value to our discussion. Let’s explore together how Microsoft is shaping the future of technology and beyond.Join the conversation and let’s explore the vast world of Microsoft’s innovations and impact together! Read More
Text Box Conditional Formatting
Hi
I have a database of circa 100 audit questions and for each answer is a combo box for Yes: meets the standard, No: Minor NC, No: Major NC, OFI and N/A. I would like to be able to format the fill colour of a text box below each question based on the value of the combo box field (traffic light system) with grey for null or “N/A” and wondered of there is a simple solution for this. So far, I can only find conditional formatting as a solution but this requires 5 different formats for each individual question.
I’d very much appreciate being pointed in the right direction.
Thanks.
Hi I have a database of circa 100 audit questions and for each answer is a combo box for Yes: meets the standard, No: Minor NC, No: Major NC, OFI and N/A. I would like to be able to format the fill colour of a text box below each question based on the value of the combo box field (traffic light system) with grey for null or “N/A” and wondered of there is a simple solution for this. So far, I can only find conditional formatting as a solution but this requires 5 different formats for each individual question. I’d very much appreciate being pointed in the right direction. Thanks. Read More
Teams Meeting Recording Custom Location
Hi
We are trying to setup events such that the attendees are not limited to specific teams or channels but rather open to the whole company in terms of both presenters and attendees. Is there a way to create the meeting such that the recordings for all these events go to a single saved location.
The two options I have come across is using a Shared Channel and creating an organization wide team. Both of these should allow me to save the recordings to one standard location
The problem with the shared channel is that people in the company who are not members of the channel can not participate in the chat
The problem with the org-wide team is that the whole company will have access to these recordings whereas we would like the videos to potentially be edited before being made publicly available
Any suggestions?
Hi We are trying to setup events such that the attendees are not limited to specific teams or channels but rather open to the whole company in terms of both presenters and attendees. Is there a way to create the meeting such that the recordings for all these events go to a single saved location. The two options I have come across is using a Shared Channel and creating an organization wide team. Both of these should allow me to save the recordings to one standard location The problem with the shared channel is that people in the company who are not members of the channel can not participate in the chat The problem with the org-wide team is that the whole company will have access to these recordings whereas we would like the videos to potentially be edited before being made publicly available Any suggestions? Read More
Power Automate Licensing Questions
I know it has nothing to do with the subject, but I need help on the subject below about Power Automate, can you help me or refer me to someone who can?
We need to create several automations using Microsoft’s Power Automate, such as sharing flows with automations created with other users who do not have any Power Automate account, providing a link on a web page so that any user even without a power automate account can benefit from and use that flow/automation. What Power Automate Plan do you recommend, taking into account that only 1 or 2 users will have a power automate account and pay to create the automations, but then they can be made available and used by other users without having to have a Power Automate account/License.
Thanks
fernando
I know it has nothing to do with the subject, but I need help on the subject below about Power Automate, can you help me or refer me to someone who can?We need to create several automations using Microsoft’s Power Automate, such as sharing flows with automations created with other users who do not have any Power Automate account, providing a link on a web page so that any user even without a power automate account can benefit from and use that flow/automation. What Power Automate Plan do you recommend, taking into account that only 1 or 2 users will have a power automate account and pay to create the automations, but then they can be made available and used by other users without having to have a Power Automate account/License.Thanksfernando Read More
Connecting to mysql or pgsql from spark
Hello,
Having a Spark notebook connecting to CosmosDB for data load. Using linked resource:
df = spark.read.format(“cosmos.olap”)
.option(“spark.synapse.linkedService”, “<enter linked service name>”)
.option(“spark.cosmos.container”, “<enter container name>”)
.load()
Is is possible to use linkedService when connecting to Azure DB for mysql/pgsql? I did not find anything in the documentation. It seems that the only way is to use standard spark connection configuration with username/password. I did not find any other way in documentation.
I would prefer to use already defined linked service to connect to these databases.
It this possible?
Thanks!
Hello, Having a Spark notebook connecting to CosmosDB for data load. Using linked resource:df = spark.read.format(“cosmos.olap”)
.option(“spark.synapse.linkedService”, “<enter linked service name>”)
.option(“spark.cosmos.container”, “<enter container name>”)
.load()as per https://learn.microsoft.com/en-us/azure/synapse-analytics/synapse-link/how-to-query-analytical-store-spark-3 Is is possible to use linkedService when connecting to Azure DB for mysql/pgsql? I did not find anything in the documentation. It seems that the only way is to use standard spark connection configuration with username/password. I did not find any other way in documentation. I would prefer to use already defined linked service to connect to these databases. It this possible? Thanks! Read More
MS Hive ODBC Driver – AppV – Windows 11 21H2
Hi everyone,
I need to prepare an AppV package with the mentioned app. It will be published to Windows 11 machines.
In general, sequencing ODBCs is not a problem. It should be working fine. And it is on Windows 10. It is not, however, on Windows 11.
What I did:
Got the latest MS ADK (ver. 10.1.25398.1) and installed Sequencer;Created dummy ODBC entries (User and System, x86 and x64);Sequenced the HIVEODBCDRIVER on W11 21H2
Then, I published the package on W10 and
Launched the ODBC shortcut
No problem at non-admin account (MS Hive ODBC Driver showed up in ODBC console)
I published the package on W11 and launched the same shortcut:
The driver didn’t appear in ODBC console.
It’s all fine however, as that package is to work in a connection group with other Appv package.
So, I created XML for a Connection Group which contains the ODB Driver Appv Package and a N++ AppV package I created quickly for testing purposes.
On W10:
I published those two packages;Added the Connection Group;Enabled it;Launched N++ (CG was then active);In N++ hit Ctrl+O and typed in ‘cmd.exe’;Then I had cmd launched from N++ and running inside the Connection Group bubble;I navigated to C:WindowsSystem32 and started odbcad32.exe;The desired driver was nicely accessible.
Then, I followed the same steps on W11:
The driver was not visible in odbcad32.exe started from N++ inside the same Connection Group.
Maybe you guys can point me what I’m doing incorrectly??
Hi everyone, I need to prepare an AppV package with the mentioned app. It will be published to Windows 11 machines.In general, sequencing ODBCs is not a problem. It should be working fine. And it is on Windows 10. It is not, however, on Windows 11.What I did:Got the latest MS ADK (ver. 10.1.25398.1) and installed Sequencer;Created dummy ODBC entries (User and System, x86 and x64);Sequenced the HIVEODBCDRIVER on W11 21H2Then, I published the package on W10 andLaunched the ODBC shortcut No problem at non-admin account (MS Hive ODBC Driver showed up in ODBC console)I published the package on W11 and launched the same shortcut:The driver didn’t appear in ODBC console.It’s all fine however, as that package is to work in a connection group with other Appv package. So, I created XML for a Connection Group which contains the ODB Driver Appv Package and a N++ AppV package I created quickly for testing purposes. On W10:I published those two packages;Added the Connection Group;Enabled it;Launched N++ (CG was then active);In N++ hit Ctrl+O and typed in ‘cmd.exe’;Then I had cmd launched from N++ and running inside the Connection Group bubble;I navigated to C:WindowsSystem32 and started odbcad32.exe;The desired driver was nicely accessible.Then, I followed the same steps on W11:The driver was not visible in odbcad32.exe started from N++ inside the same Connection Group.Maybe you guys can point me what I’m doing incorrectly?? Read More
Comparing Shared and Inactive Mailboxes for Retaining Ex-Employee Content
Every Microsoft 365 tenant must deal with ex-employee mailboxes. The default choice is to make the mailboxes into shared mailboxes. But inactive mailboxes could be a better option to deal with the requirements to preserve user privacy and avoid inadvertent disclosure of PII to people who don’t need that information. Perhaps it’s time to reassess how your organization deals with ex-employee mailboxes?
https://office365itpros.com/2024/07/22/ex-employee-mailboxes-choice/
Every Microsoft 365 tenant must deal with ex-employee mailboxes. The default choice is to make the mailboxes into shared mailboxes. But inactive mailboxes could be a better option to deal with the requirements to preserve user privacy and avoid inadvertent disclosure of PII to people who don’t need that information. Perhaps it’s time to reassess how your organization deals with ex-employee mailboxes?
https://office365itpros.com/2024/07/22/ex-employee-mailboxes-choice/ Read More
Error “the operation cannot be performed because the object has been deleted
Microsoft office home & Business 2021 and Microsoft office LTSC stand 2021 happening intermittent error. after finishing typing a reply email and clicking the reply button, an error prompt appears. The user needs to close the email, reopen it, and retype the message.
i have did window update, update office, repair office, disable add-in, re-install office, create new outlook profile.
Microsoft office home & Business 2021 and Microsoft office LTSC stand 2021 happening intermittent error. after finishing typing a reply email and clicking the reply button, an error prompt appears. The user needs to close the email, reopen it, and retype the message.i have did window update, update office, repair office, disable add-in, re-install office, create new outlook profile. Read More
How can I resolve Error PS060 in Q.B during a pay-roll update?
I’ve encountered Q.B Error PS060 while attempting to update pay-roll in my Q.B software. It’s disrupting my workflow. Could you provide detailed instructions or steps to resolve this issue effectively? I need to fix it as soon as possible to ensure pay-roll processing isn’t delayed.
I’ve encountered Q.B Error PS060 while attempting to update pay-roll in my Q.B software. It’s disrupting my workflow. Could you provide detailed instructions or steps to resolve this issue effectively? I need to fix it as soon as possible to ensure pay-roll processing isn’t delayed. Read More
Add days based on specific date field column and a number field column as multiplier
Hi,
I hope you guys are not tired solving someone’s problem.
I currently have SP list and manage to use CALCULATED Column with other columns.
This is my formula for that calculated column.
=IF([Months to Pay]>=3,DATE(YEAR([First Payment]),MONTH([First Payment]),DAY([First Payment])+30),” “)
But my problem is that it wont be called in POWER AUTOMATE Filter Query.
Now I hope you can help turn this into Power Automate.
I have 3 columns, No. of Months will Pay (number), First Payment (date), Second Payment(date)
I tried it using init variable and update items, but it wont work.
How can I able to formulate it? Its like First Payment * No of Months to Pay = Second Payment
Thank you.
Hi, I hope you guys are not tired solving someone’s problem.I currently have SP list and manage to use CALCULATED Column with other columns.This is my formula for that calculated column.=IF([Months to Pay]>=3,DATE(YEAR([First Payment]),MONTH([First Payment]),DAY([First Payment])+30),” “) But my problem is that it wont be called in POWER AUTOMATE Filter Query.Now I hope you can help turn this into Power Automate.I have 3 columns, No. of Months will Pay (number), First Payment (date), Second Payment(date) I tried it using init variable and update items, but it wont work. How can I able to formulate it? Its like First Payment * No of Months to Pay = Second Payment Thank you. Read More
Problem with defender onbording using script
Hello,
I try to onboard PC with win 11 to Endpoint and I receive same error as in thread
Bryll advised some steps, but:
“1. Make sure that you are using the correct service name for Microsoft Defender for Business. The service name should be “Microsoft Defender for Endpoint Onboarding” (without the quotes). + 2. Check if the service is running on the device. You can do this by opening the Services app (services.msc) and looking for the “Microsoft Defender for Endpoint Onboarding” service. If the service is not running, start it and try onboarding the device again.” – I don’t see this service on the machine nor on the machine that is already onboarded.
“Check the Diagnostic Data Service:” – I don’t see this service neither (nor on onboarded device). I also tried to enable ‘Send optional diagnostic data’ and restart PC, but still don’t have this service.
Also, solution to create new user account and switch to it is not for us.
I found
https://learn.microsoft.com/en-us/defender-endpoint/troubleshoot-onboarding#view-agent-onboarding-errors-in-the-device-event-log to troubleshoot event log, but the machine doesn’t have Applications and Services Logs > Microsoft > Windows > SENSE folder. (onboarded PCs have it)
Any other advise?
Hello,I try to onboard PC with win 11 to Endpoint and I receive same error as in threadhttps://answers.microsoft.com/en-us/msoffice/forum/all/defender-for-business-onboarding-endpoint-device/9b8d1dc1-4e78-4a24-a98d-e7faf761540a Bryll advised some steps, but:”1. Make sure that you are using the correct service name for Microsoft Defender for Business. The service name should be “Microsoft Defender for Endpoint Onboarding” (without the quotes). + 2. Check if the service is running on the device. You can do this by opening the Services app (services.msc) and looking for the “Microsoft Defender for Endpoint Onboarding” service. If the service is not running, start it and try onboarding the device again.” – I don’t see this service on the machine nor on the machine that is already onboarded. “Check the Diagnostic Data Service:” – I don’t see this service neither (nor on onboarded device). I also tried to enable ‘Send optional diagnostic data’ and restart PC, but still don’t have this service. Also, solution to create new user account and switch to it is not for us. I found https://learn.microsoft.com/en-us/defender-endpoint/troubleshoot-onboarding#view-agent-onboarding-errors-in-the-device-event-log to troubleshoot event log, but the machine doesn’t have Applications and Services Logs > Microsoft > Windows > SENSE folder. (onboarded PCs have it)Any other advise? Read More
How can I convert AAC file to MP3 without losing quality?
Hey,
I’ve got a massive collection of music files in AAC format, but my car’s stereo system only supports MP3. I’ve tried using three online AAC to MP3 converters but they either don’t support batch conversions or have poor quality output. I’ve also tried using software like FFsmpeg, but I’m not familiar with the command-line interface and it seems like overkill for what I need. I’m looking for something user-friendly and easy to use.
Does anyone have a reliable method or software that can help me convert AAC to MP3 without compromising on quality? I’ve got a large collection ( thousands of songs) so I’m looking for a solution that can handle large batches.
Thanks
Hey, I’ve got a massive collection of music files in AAC format, but my car’s stereo system only supports MP3. I’ve tried using three online AAC to MP3 converters but they either don’t support batch conversions or have poor quality output. I’ve also tried using software like FFsmpeg, but I’m not familiar with the command-line interface and it seems like overkill for what I need. I’m looking for something user-friendly and easy to use. Does anyone have a reliable method or software that can help me convert AAC to MP3 without compromising on quality? I’ve got a large collection ( thousands of songs) so I’m looking for a solution that can handle large batches. Thanks Read More