Category: Microsoft
Category Archives: Microsoft
Alter the value of one MS List column dependant on another
Hi
I have tried searching for days but i think i may be getting the wording wrong.
I have an MS list hosted on a sharepoint site, the focus is 2 colums for this query.
When an item is created a column PDC is marked as Yes or No, with a choice.
Another column is Item status, with Open or Closed as choices.
I am trying to create and write a flow that when an item is marked as Closed, it marks PDC as No automatically. The flow i create, when i try and apply a True or False condition, and for True add an action of ‘Update item’ it presents me with a blank item template (as though i am creating a new item). I am wanting to update the item that has been changed to Closed, not an entire new one.
Screen shot is below just in case i am not explaining it well.
Thanks everyone
HiI have tried searching for days but i think i may be getting the wording wrong. I have an MS list hosted on a sharepoint site, the focus is 2 colums for this query. When an item is created a column PDC is marked as Yes or No, with a choice. Another column is Item status, with Open or Closed as choices. I am trying to create and write a flow that when an item is marked as Closed, it marks PDC as No automatically. The flow i create, when i try and apply a True or False condition, and for True add an action of ‘Update item’ it presents me with a blank item template (as though i am creating a new item). I am wanting to update the item that has been changed to Closed, not an entire new one. Screen shot is below just in case i am not explaining it well. Thanks everyone Read More
Is there a way to force keyboard type for the HTML 5 client?
We have an older application that is not accepting keyboard input in certain controls. In doing some investigation, it was determined that setting the remote keyboard layout to “US (QWERTY)” allows entry for the controls.
Rather than having end users go into the settings of the client (which is lost across browsers/machines) we’d like to figure out a way to “force” this setting.
Is there a cmdlet or some other way we can have the HTML 5 client always use that keyboard?
Thanks,
Tim
We have an older application that is not accepting keyboard input in certain controls. In doing some investigation, it was determined that setting the remote keyboard layout to “US (QWERTY)” allows entry for the controls. Rather than having end users go into the settings of the client (which is lost across browsers/machines) we’d like to figure out a way to “force” this setting. Is there a cmdlet or some other way we can have the HTML 5 client always use that keyboard? Thanks,Tim Read More
How do I fix error code 12029 in Quick+Books?
I’ve been encountering Quick+Books error code 12029 repeatedly while trying to update or access my company files. It disrupts my workflow and I’m unsure how to fix it. Could you please provide detailed steps or solutions to resolve this issue quickly and prevent it from happening again?
I’ve been encountering Quick+Books error code 12029 repeatedly while trying to update or access my company files. It disrupts my workflow and I’m unsure how to fix it. Could you please provide detailed steps or solutions to resolve this issue quickly and prevent it from happening again? Read More
Not Evaluated – Delay
Hello All,
Anyone else experiencing a delay after enrolling Android devices?
Past few days, devices are taking hours to progress past Not Evaluated.
Thanks
Hello All, Anyone else experiencing a delay after enrolling Android devices?Past few days, devices are taking hours to progress past Not Evaluated. Thanks Read More
Limitations while using Copilot in MS Teams
Hi
With Copilot in MS Teams I face several limitations. Is it configurable?
1) Prompt related to my Outlook emails returns 10 messages max. Being asked, copilot says there are exactly 10 messages! But I can see in Outlook that there are many more
2) Prompt related to messages in a chart (summarize etc.) sets a time range (about month) and works only with messages posted within that range. I cannot extend it
HiWith Copilot in MS Teams I face several limitations. Is it configurable? 1) Prompt related to my Outlook emails returns 10 messages max. Being asked, copilot says there are exactly 10 messages! But I can see in Outlook that there are many more2) Prompt related to messages in a chart (summarize etc.) sets a time range (about month) and works only with messages posted within that range. I cannot extend it Read More
Compare 2 columns and sum the larger value in column
Hello, I need help again. This is my formula: =SUM(IF(’01-24 DB’!$AK19:$AK156>’01-24 DB’!$AN19:$AN156,’01-24 DB’!$AK19,$AN20))
I would like to have a formula where I compare the value between AK and AN, and it picks the larger value and then it sums up the whole column.
Thank you.
Hello, I need help again. This is my formula: =SUM(IF(’01-24 DB’!$AK19:$AK156>’01-24 DB’!$AN19:$AN156,’01-24 DB’!$AK19,$AN20)) I would like to have a formula where I compare the value between AK and AN, and it picks the larger value and then it sums up the whole column. Thank you. Read More
Replace part of a link with text from a cell and capitalize
Hello,
I am using IMAGE formula to grab photos from a website
I would like to automatically replace part of the link with the text of a different cell and capitalize the letters.
Attached example file
Could you please help me out?
Thanks a lot!
Hello, I am using IMAGE formula to grab photos from a website I would like to automatically replace part of the link with the text of a different cell and capitalize the letters. Attached example file Could you please help me out? Thanks a lot! Read More
Keyword search doesnt work for applications in Software Center
MCM (SCCM) 2403
it seems that searching for keywords (set for application in Software Center) seems to be broken in our environment
If i add “abcxyz” to an application as keyword it could not be found via Software Center but if i add it the localized description the application could be found
Any ideas here?
MCM (SCCM) 2403it seems that searching for keywords (set for application in Software Center) seems to be broken in our environmentIf i add “abcxyz” to an application as keyword it could not be found via Software Center but if i add it the localized description the application could be foundAny ideas here? Read More
Automatically select drop down list option based on value of other cell
Hi all
I have a column with cells that are populated from a drop down list. I would like one of the list options to be populated auotmatically based on the value of another cell but I am not sure if this is possible.
I would usually use an IF formula for this but can’t with a drop down list as the cells are restricted to the list options so no formla can be added to them. Is there another way to do it?
Thank you
Hi all I have a column with cells that are populated from a drop down list. I would like one of the list options to be populated auotmatically based on the value of another cell but I am not sure if this is possible.I would usually use an IF formula for this but can’t with a drop down list as the cells are restricted to the list options so no formla can be added to them. Is there another way to do it?Thank you Read More
Conditional access issue with app exclusion.
Hi,
We have a conditional access policy (Grant) with some controls and a few apps excluded. The exclusion does not work. The “What if” tool shows everything correctly, but the user is still affected by the policy even when trying to use an excluded app. Sign-in logs show that the policy was triggered as well. Has anyone experienced something like this?
Hi, We have a conditional access policy (Grant) with some controls and a few apps excluded. The exclusion does not work. The “What if” tool shows everything correctly, but the user is still affected by the policy even when trying to use an excluded app. Sign-in logs show that the policy was triggered as well. Has anyone experienced something like this? Read More
Getting local admins from all PCs
Hello,
I am new to power shell scripting and i got a task where i need to restive all the users that have local admins on their devices.
Any help?
I managed to create a script but i got errors on all users.
This is the script:
#Get Current Computer Name
$computer = $env:computername
#Get Current UserName
$CurrentUser = whoami
#Get User’s Local Group Membership
$CurrentUserGroups = whoami /groups
#Check if current user is a member of the Local Admins group
$CurrentUserAdmin = $CurrentUserGroups -like “*S-1-5-32-544*”
#If user is an admin
if ($CurrentUserAdmin) {
$body = ConvertTo-JSON @{Device = $computer; User = $CurrentUser; IsAdmin = ‘true’}
#Start Flow
Invoke-RestMethod -uri $URI -Method Post -body $body -ContentType ‘application/json’
}
#If user is not an admin
else {
$body = ConvertTo-JSON @{Device = $computer; User = $CurrentUser; IsAdmin = ‘false’}
#Start Flow
Invoke-RestMethod -uri $URI -Method Post -body $body -ContentType ‘application/json’
}
Hello, I am new to power shell scripting and i got a task where i need to restive all the users that have local admins on their devices.Any help? I managed to create a script but i got errors on all users.This is the script:#Get Current Computer Name$computer = $env:computername#Get Current UserName$CurrentUser = whoami#Get User’s Local Group Membership$CurrentUserGroups = whoami /groups#Check if current user is a member of the Local Admins group$CurrentUserAdmin = $CurrentUserGroups -like “*S-1-5-32-544*”#If user is an adminif ($CurrentUserAdmin) {$body = ConvertTo-JSON @{Device = $computer; User = $CurrentUser; IsAdmin = ‘true’}#Start FlowInvoke-RestMethod -uri $URI -Method Post -body $body -ContentType ‘application/json’}#If user is not an adminelse {$body = ConvertTo-JSON @{Device = $computer; User = $CurrentUser; IsAdmin = ‘false’}#Start FlowInvoke-RestMethod -uri $URI -Method Post -body $body -ContentType ‘application/json’} Read More
Apps detected as Trojan by Microsoft Defender: Opinion require
Hi,
Last time, my apps was detected as malware by Microsoft Defender (MD). But at that time, we just submit the file for analysis and then MD no longer detect my apps as malware after the ticket close.
However, for my new revamped application from previous version, the analysis failed and tell me that my apps contained malware. It is a VPN application that alter the virtual network for tun interface.
Any thoughts or approach that I can take from here until I MD remove the false detection?
Hi, Last time, my apps was detected as malware by Microsoft Defender (MD). But at that time, we just submit the file for analysis and then MD no longer detect my apps as malware after the ticket close. However, for my new revamped application from previous version, the analysis failed and tell me that my apps contained malware. It is a VPN application that alter the virtual network for tun interface. Any thoughts or approach that I can take from here until I MD remove the false detection? Read More
Stream Moves to Intelligent Versioning
In a change designed to reduce the consumption of storage quota, Stream video versions are no longer being generated for non-video updates such as changes to video metadata. Anything that alters the video content, like trimming some seconds from the start or end of a video, will create a new version. It seems like a perfectly reasonable change to make that might help SharePoint storage not be consumed quite so quickly.
https://office365itpros.com/2024/07/24/stream-video-versions/
In a change designed to reduce the consumption of storage quota, Stream video versions are no longer being generated for non-video updates such as changes to video metadata. Anything that alters the video content, like trimming some seconds from the start or end of a video, will create a new version. It seems like a perfectly reasonable change to make that might help SharePoint storage not be consumed quite so quickly.
https://office365itpros.com/2024/07/24/stream-video-versions/ Read More
Game recording app keeps asking for PIN password?
Is this safe and should I delete the app from my computer?
Is this safe and should I delete the app from my computer? Read More
How to create view joining two table of similar records without duplicating.
Hi All,
Hope all are doing great. I have a small query regarding the Join function to create view. I have two table in which table 1 is having 40k records and table 2 is having 40k records. But when i am joining the both to create view, it is showing 47k records. Please note that i am combining table using two common column in both, one is “Calendar_Date” and one is “Personal_ID”. In some cases few Personal ID has duplicate records for each month. So while creating the view the, these duplicate records gets multiplied . Hence the total records exceeds 47k. How to make it same 40k records which i am having in each table.
Any help would be highly appreciated.
Regards,
Sagar
Hi All,Hope all are doing great. I have a small query regarding the Join function to create view. I have two table in which table 1 is having 40k records and table 2 is having 40k records. But when i am joining the both to create view, it is showing 47k records. Please note that i am combining table using two common column in both, one is “Calendar_Date” and one is “Personal_ID”. In some cases few Personal ID has duplicate records for each month. So while creating the view the, these duplicate records gets multiplied . Hence the total records exceeds 47k. How to make it same 40k records which i am having in each table. Any help would be highly appreciated. Regards,Sagar Read More
Pictures integrated in a list- not visible- error code #UNKNOWN!
Hi all,
I have a problem. I get a list from a company I am working with and they integrate pictures in the list.
I get an error message that the pictures are #UNKNOWN!
See attached screenshots.
I updated already to the newest version of Excel. I am using a MacBook Air- MAC OS Ventura 13.1.
And I am the only one having problems with this list.
Everybody else using it can see the pictures.
Appreciate your help.
Hi all, I have a problem. I get a list from a company I am working with and they integrate pictures in the list.I get an error message that the pictures are #UNKNOWN!See attached screenshots. I updated already to the newest version of Excel. I am using a MacBook Air- MAC OS Ventura 13.1. And I am the only one having problems with this list.Everybody else using it can see the pictures. Appreciate your help. Read More
Microsoft Cost Management updates—June 2024 (summary)
FinOps X 2024 was a hit. To learn about our announcements, see News and updates from FinOps X 2024.
Cost Management announced FOCUS 1.0 support in exports.
Review an estimate of your costs when you deploy virtual machines in the Azure portal.
Access Cost analysis from the Azure Kubernetes Service cluster menu.
Pricing updates on Azure.com including new regions, new services, and a slew of updates for services like Virtual machines, Azure SQL DB, Azure Data Factory, Azure Functions, and more.
New ways to save money with Microsoft cloud:
VM Hibernation is now Generally Available
Documentation updates spanning Cost Management, Azure Hybrid Benefit, reservations, Marketplace charges, and Billing experiences.
This is just a quick summary. For the full details, please see Microsoft Cost Management updates—June 2024.
Microsoft Tech Community – Latest Blogs –Read More
Security Baselines
Hi, I’m having an issue after enabling the baseline securities. When we connect our laptop to the docking station via the Thunderbolt port, the peripherals (mouse, keyboard, and network connection) get blocked.
We suspected the policy “Disable new DMA devices when this computer is locked,” but disabling it didn’t help.
Does any body have any idea, which policy it might be blocking the peripherals ? this is a headache to find.
Hi, I’m having an issue after enabling the baseline securities. When we connect our laptop to the docking station via the Thunderbolt port, the peripherals (mouse, keyboard, and network connection) get blocked. We suspected the policy “Disable new DMA devices when this computer is locked,” but disabling it didn’t help. Does any body have any idea, which policy it might be blocking the peripherals ? this is a headache to find. Read More
Server 2022 – Hyper V
Good Morning All,
I hope someone can help me with this setup.
We were running 2012 R2, so had to upgrade to 2022 (via our support people) – One server running 4 Hyper V’s – and its running like a dog – we run one main program from the RDS which looks at the SQL server.
Dell Poweredge R450 – Xeon Silver 4314 16 Core – 128GB Ram ** Recommended by our Support people – About 20 Users.
The VM’s have been setup thus :-
DB – 32768 Ram / 10 VP
DC – 4096 Ram / 4 VP
RDS – 32768 Ram / 8 VP
FS – 16384 Ram / 6 VP
All have VMQ enabled / All have IPSEC Offloading Enabled / All have SR-IOV disabled.
Running an SQL query directly on the DB is faster than the 2016 (Which I would expect as Im the only user on the new server) But running the program we use through the RDP is painfully slow.
Has anyone got any ideas how I can improve our setup ?
Any help would be greatly appreciated, it really will !
Regards
BC
Good Morning All, I hope someone can help me with this setup. We were running 2012 R2, so had to upgrade to 2022 (via our support people) – One server running 4 Hyper V’s – and its running like a dog – we run one main program from the RDS which looks at the SQL server. Dell Poweredge R450 – Xeon Silver 4314 16 Core – 128GB Ram ** Recommended by our Support people – About 20 Users. The VM’s have been setup thus :- DB – 32768 Ram / 10 VPDC – 4096 Ram / 4 VPRDS – 32768 Ram / 8 VPFS – 16384 Ram / 6 VP All have VMQ enabled / All have IPSEC Offloading Enabled / All have SR-IOV disabled. Running an SQL query directly on the DB is faster than the 2016 (Which I would expect as Im the only user on the new server) But running the program we use through the RDP is painfully slow. Has anyone got any ideas how I can improve our setup ? Any help would be greatly appreciated, it really will ! RegardsBC Read More