User Profile
oliwer_sundgren
Steel Contributor
Joined 6 years ago
User Widgets
Recent Discussions
Re: How to change the value of a column in Site Pages in Sharepoint
Hello louisquinet ! The below PNP Powershell Script would probably be what you seek 🙂 Note that this script will add the same value to the SME column for all list items. $SiteURL = "https://yourdomain.sharepoint.com/Sites/sitename" $ListName ="YourListname" #Connect to PnP Online Connect-PnPOnline -Url $SiteURL -Credentials (Get-Credential) #Get all List items $ListItems = Get-PnPListItem -List $ListName -ErrorAction Stop #Update List Items SME value foreach ($Item in $ListItems){ Set-PnPListItem -List $ListName -Identity $Item -Values @{"SME" = "The Value you want to add"} } If you want to add unique values via Powershell to different items in the list then we'll need to modify the script. The above script is just to get you started 🙂 Let me know how it goes or if you have further questions Kind regards Oliwer Sundgren243Views0likes1CommentRe: Powershell error with the below code
Hello Rambo. Since $Data.Value didnt give any output then the Value Column in your csv is not formatet correct. If you do the same but instead of running $Data.value could you run just $Data and see what the output is like? Cheers Oliwer2.2KViews0likes9CommentsRe: Clarification on Microsoft Teams Encryption: E2EE vs. Default Encryption
HelloMarnik ! Below is a snippet from Microsoft Learn about E2EE "End-to-end encryption is the encryption of information at its origin and decryption at its intended destination without the ability for intermediate nodes to decrypt. When meetings in Teams are end-to-end encrypted, nobody except for the participants in the meeting can hear or see the communication. No other party, including Microsoft, has access to the decrypted conversation." By default Teams encrypts communication via TLS, this means that in transit and at rest the data is encrypted, but the data passes is stored and accessible by Microsoft, log systems and so forth. For example, when you have a 1:1 call and choose to record the call, Microsoft services will have to "Hear" and "see" the call in order for it to record it and store it. What this means is that the data is encrypted between Client-Server-Client. With E2EE, the communication is encrypted Client-Client, this means that no intermediate party can hear or see the data, not even Microsoft. Since Microsoft cant access the data, features below wont work in E2EE calls, since Microsofts services cant "Hear" or "See" the content. Screen Recording Transcript Copilot Dial in Together mode Request control Live captions Invite more participants Summary: E2EE calls is more secure than the regular teams encryption since Microsoft or other parties other than the participants of the meeting can "See" or "Hear" the call/meeting. This also means that some well known features in teams wont be usable in these calls since Microsoft doesnt have access to it. However, your data will always be encrypted in some way despite what method you choose to use With that in mind, E2EE calls should probably not be the default. I have a hard time thinking that a "Daily standup" or "Virtual Coffe breaks" should be E2EE encrypted. Use cases for E2EE calls: E2EE calls would be most usefull in meetings or calls that are highly confidential, for example board meetings that cant be recorded, meetings with client that fall under an NDA or similar. Hope this helps you, if not let me know and I'll be happy to further assist 🙂 Cheers Oliwer Sundgren702Views1like0CommentsRe: Powershell error with the below code
Hi Rambo, no problem at all we've all been there 🙂 In Powershell after you've ran these 2 lines in your code $keyVaultName = "marketing-test" $data = Import-Csv "C:\Users\Ram.Muppaneni\Downloads\marketing.csv" Then just simply type $Data.Value in the Powershell terminal and see what the output is What editor are you using to write the Powershell script? See my example below from Visual Studio Code where I have one line of code, I run that line and then in the terminal I type $Data to get the value of that variable When you do this, $Data.Value should give you some output. If possible, share a screenshot of that output. With sensitive information blurred or replaced with test data. Let me know if you dont follow and I can guide you further 🙂 Cheers2.2KViews0likes11CommentsRe: How to Solution Prevent User Downgrade Sensitivity Label is changed
Hello! namlovely201180 Sadly there is no way to completely block the possibility of downgrading to a lower sensitivity label. However you can set up an alert policy for label changes and get notified that way. Let me know if you need further information on this Cheers Oliwer813Views0likes0CommentsRe: Excluding Communication Sites from Retention Policy
Hello! Hmm that is strange, communication sites are supported in retention policies. Do you see any communication sites or is it just empty? Would it be possible to share a screenshot of how it looks when you try and search for a com site in the retention policy? Cheers Oliwer265Views0likes2CommentsRe: In Outlook how to create common event Categorize for the whole organization
Hello again! Djeanthi2215 You have to create it under Preferences yourself. Do the following 1: Right click the white the "preferences" folder 2: Choose "New" and then "String Value" 3: name it "newcategories" and then click enter 4: Doubleclick "newcategories" to modify it 5: in "value data" Write the following to add the categories that you had in your example and then click "OK" Needs analasys; Demo; Contract; Renewal 6: Restart Outlook and you will see the new categories 🙂 Let me know how it goes! And then we can discuss Intune or GPO Cheers Oliwer Sundgren574Views0likes3CommentsRe: In Outlook how to create common event Categorize for the whole organization
Hello !Djeanthi2215 Do you mean the color categories that you can add to emails and calendar events? If that is the case then yes you can deploy this to the whole organisation using GPO or Intune Configuration profiles. What you want to do is create a new reg key in the following path HKEY_CURRENT_USER\Software\Microsoft\Office\16.0\Outlook\Preferences And the key you want to create will have these properties Type: String Name: newcategories Value: The name of your categories separated by ";" See picture below for example Now after I have done the above change in my registry, If i Look in Outlook at my categories in the calendar I can see these new categories. Is this what you were looking for? If that is the case, you can deploy this reg key to your users via GPO or Intune configuration profiles 🙂 Let me know how it goes or if you have further questions If this helped solve your issue feel free to mark my reply as "best solution" Cheers Oliwer Sundgren595Views0likes5CommentsRe: Powershell error with the below code
Hi Rambo363636 Just like LainRobertson said when you work with CSV in Excel you dont need to specify double quotes or the delimiter (comma) in the cells itself. When you run $data = Import-Csv "C:\Users\Ram.Muppaneni\Downloads\marketing.csv" I would recommend that you also double check that the data is correctly formated by just typing out $Data or $data.Value and $data.Name to see that everything outputs correctly. Sometimes Excel defaults to the incorrect delimiter that Powershell assumes will be used. If you could try the above commands and then send a screenshot of the output (With the values blurred out of course) we could see if the CSV is looking up to par Looking forward to your reply Cheers Oliwer Sundgren2.3KViews0likes13CommentsRe: Conditional Access Help
Hello! Hmm this is strange, since the Office365 cloud app includes Sharepoint, OneDrive, Exchange Teams and much more but not Entra ID, so you adding Office365 to the blocked apps list should not block sign in via EntraID to the users. I have an Conditional access policy myself where I block all apps except a custom application and that works. How does the authentication look to your custom app? Is it SSO or how do users sign in? Could you share screenshots of your CA policy with sensitive information blurred out? Cheers! Oliwer Sundgren295Views0likes0CommentsRe: How to create a rule in Defender for M365 to block sender domain age has less than 2 weeks ?
Hello! vinaybabupamu Sadly I dont believe this feature exists within Defender or Exchange Online Protection. There is other tools in the toolbox to protect against unwanted emails But If you specifically want to check domain age and other information from WHOIS I would recommend that you take a look at Azure Sentinel, and specifically the "Domain tools" connector/Playbook, This could perhaps be what you are looking for Let me know if this helps! Cheers Oliwer Sundgren351Views1like0CommentsRe: How to impose MFA for external users who may access encrypted messages?
HEllo Dorinilieconstantin ! I believe for this to work the users would have to be guest users in your tenant and have MFA configured. That way they could be able to authenticate with MFA Also if the external users have their own Entra ID tenant this should work by default if im not misstaken I would recommend that you try and invite an external email (for example Gmail or hotmail) to your tenant as a guest, configure MFA on that guest account and then see if you can share an encrypted email and authenticate to open it via MFA Let me know how it goes Cheers! Oliwer Sundgren199Views0likes0CommentsRe: Use your organization's branding with Copilot in PowerPoint
Hello hemanth1595! Yes I've managed to use my companies templates with Copilot. The steps I did was 1: Open PowerPoint 2: Create a new presentation based on the template you want to choose. 3: Ask copilot to create a new presentation 4: Copilot will prompt you and say something like "Creating a new presentation will override the current slides, do you want me to continue?" Click yes on that 5: Let Copilot do its magic 6: Voila 🙂 Let me know if this works for you Kind Regards Oliwer922Views0likes0CommentsRe: Application Segmentation
Hi! princzsaharan Would it make sense to segment the applications based on work function(department) instead of worktitle? For example Marketing apps like Google Analytics and similar will not be used by IT, and IT related apps will not be used by HR. Then there are some apps like Viva engage, Teams and similar that will be used by the whole company? Let me know if this makes sense, otherwise we can keep brainstorming 🙂 cheers Oliwer199Views0likes0CommentsRe: Lost ECP and OWA Exchange
Hello again Seraphin67 Im sorry to say but it does seem that there is something very wrong with the server. I would recommend that you try and install a new Exchange server to the organisation and see if that new installation will work as expected, and then work on removing the failing server from the organisation. Kind Regards Oliwer318Views1like0Comments