admin
6661 TopicsCreating Logic to find whether columns in one table matches other columns in other table
Hi Team, I have 2 tables: Door table as below: Store Status table as below: They are modelled as below (let me know if we can better model it-suggestions are welcomed): Now, I need to create a logic(Breach) to find when Door Table - Status column being Open when Store Status table - Status column being Closed (indicated by - 'C'). During this logic, we have to make sure it satisfies below conditions: DateTime column of Store Status table should match the createdon column of Door table Store id column of Store Status table should match the siteid of Door table Output should return 1 if the conditions meets else 0. Could you please help me create a logic for this? PFA file here B&M.pbix Thanks in advance! SergeiBaklan49Views0likes1CommentMulti Tenant Organization - one shared user not showing up in Global Address List
I set up a multitenant organization with two tenants. Overall it seems right, users can find each other and chat fairly seamlessly on teams, and shared users appear on the opposite global address list. However, one user is an exception. They appear on their home tenant's Global Address list, but not on the other tenant's (all other shared users appear to). They are members on the other tenant (as are the rest of the shared users), and are not set as hidden on a global address list anywhere I can see. I can't see anything different about them in any way. They were neither the first nor the last to be shared, and I have tried unsharing then sharing them again. They can however be found on teams by typing their name. Probably not related, but I will point out that the one other thing I have not managed to get working is a "chat" link on people's outlook directory listings. None of the shared users have one, despite being chatable with on teams. Any idea where I might look for the culprit?7Views0likes0CommentsSharepoint central IT management best practices
Hi, At my company, we would like to use our corporate SPO infra more and more to diminish our local storage needs and foster collaboration but the problem is that we are having a huge sprawl and we don't have any control of what is being published like confidential stuff, documents with personal data in them, DBs etc. Is there a paper with Central IT SPO management best practices that can help us controlling/avoiding this type of situations? Thanks/Brgds jc33Views0likes1CommentAccess to Exchange Admin Centre blocked using most (but not all) URL links
Suddenly, when I try to use most of the published links to the Exchange Admin Centre, including the links on the Microsoft 365 Admin Centre, my access to the Admin Centre for Exchange is blocked. The messages vary but the most common one is "admin.exchange.microsoft.com closed the connection". All of the links for the other admin centres work just fine for me (Teams, InTune, SharePoint etc.) - it's just the Exchange Admin Centre link that are mostly problematic. Two examples of links that don't work for me: https://admin.exchange.microsoft.com/?landingpage=homepage&form=mac_sidebar https://admin.exchange.microsoft.com/#/homepage The only link I can find that still does work for me: https://admin.cloud.microsoft/exchange#/Solved322Views1like3CommentsCreate a Power query or Dax to find Open Status more than 1 hour
Hi Team, I have the door table Here I want to find that whether door is being open continuously(having open status & not closed) for more than 1 hour for each DeviceId. Data Description: The Status column shows whether door is open or Closed. CreatedOn column shows time duration. DeviceId column shows Deviceid. My first requirement is: We need to add the minutes(createdon) between each row for same deviceid where the status = open. But where a status = closed (if closed comes in between open) we reset the number of minutes. So we sum by the previous value where status = Open - Something like If current status = open and previous status = open then sum the time and do the below: Sum(previous value + new sum) Where/if status = closed set time count = 0 Sum(previous value + new sum) is going to take into account only the consecutive open status >60 min for same divice id whenever status is closed, this Sum(previous value + new sum) will be reset to/equal to 0 So on the first open status, the count will be 0. Then the next open status it will be time between 2 open statuses, then on the third it will be the time between two open statuses add the previous time.but any close status then time is reset. Could you please help me with a power query logic/dax logic? Second Requirement: This is only a sample data. But we have billions of rows of data in our dataflow that comes from SQL views. So, thought not to use DAX for this calculation in future. we can precalculate the maximum open state duration by preprocessing data (SQL, Power Query(dataflow), Spark, anything else...). So can you help me prepare data upfront. we need to solve the problem with a with a proper data model. for example, create a table with the longest open events upfront (in whatever technique you are comfortable with) Could you please help me to achieve this? PFA file here B&M.pbix Thanks in advance!Solved169Views0likes9Comments"OVERWRITE EXISTING CELLS WITH NEW DATA..." GET DESELECTED
HELLO , I HAVE OFFICE 365 . FROM 1 MONTH AGO THE BUTTON IN DATA TAB THEN PROPERTIES AND IN IT "OVERWRITE EXISTING CELLS WITH NEW DATA..." GET DESELCTED AUTOMATICALLY AND WHEN WE REFRESH DATA IT GET OVERLAPPED . EARLIER IT WAS WORKING FINE LIKE IN SCREEN SHOT WE HAD SELECTED "OVERWRITE........" TAB BUT WHEN WE PRESS OK AND REOPEN IT IT GET DESELECTED PLEASE HELP ON THIS92Views0likes4CommentsClipchamp’s brand kit: simplifying consistent video creation for organizations
Empowering our users to tell stories worth sharing lies at the heart of what we do at Clipchamp, and in a world increasingly focused on enterprise narratives, it’s become clear that these stories are often needed to help communicate the ethos of a brand. That’s why we’re excited to share more about our refreshed brand kit feature, designed to improve organizational branding capabilities within our video editor. With this update you now can organize a comprehensive collection of video elements—like logos, colors, and fonts—into a brand kit, for your teams and organizations to apply to any video. Whether it's an internal team meeting recording or a ‘how-to' video showcasing new product features, users and organizations can easily ensure that their brand identity is represented correctly, every time. Our brand kit empowers admins and brand managers to collate approved assets and share brand kits across global teams, ensuring that visual standards are consistent across the board, and across the world. GIF of Microsoft Clipchamp Brand kit and the branded elements it supports This ability to ensure that assets are uniform means that consistent content is now achievable at scale, helping to bolster the clarity of messaging for large enterprises, while leveraging a familiar and easy-to-use interface that doesn’t require extensive video editing experience. The flexibility and ease of uploading branding elements to your brand kit means that you can ensure not only the clarity of the message, but also its aesthetic and creative presentation with images, music, graphics and more. By the end of March 2025, brand managers and admins will be able to leverage template generation as well, allowing their teams to create foundational branded projects that can be easily replicated, modified, and reused. Brand consistency across your organization Organizations in today’s digital-first world understand the critical importance of consistent messaging and visuals in maintaining a cohesive brand narrative, for both internal and external communications. With Clipchamp's brand kit feature, ensuring uniformity of content is now easier than ever. "Knowing that all our content is aligned with our brand guidelines - whether it's the logo, fonts, colors, or even the music - gives us total confidence in the product. It saves time and helps every team member, no matter their design skills, to produce professional, on-brand videos." Paul Burke, Head of Global Brand at Amadeus. Once set up, your brand kit integrates directly into Clipchamp, appearing by default for all users in your organization. This eliminates the need for manual uploads or version control headaches. To get started, here are the steps below. If you want a deeper dive into creating and sharing brand kits across your organization, check out more details here 1. Select an existing SharePoint site or create a new site to host the brand kits This can be any type of site, such as a communication site, a team site that's connected to a Microsoft 365 Group, or a modern team site that isn't connected to a Microsoft 365 Group. Then, add the people you want to be able to upload files as members or owners of the site or Microsoft 365 Group. 2. Use PowerShell to designate the document library as org asset type BrandKitLibrary Ensure you have SharePoint PowerShell client versions >= 24830.12754 or download the most recent. Run the cmdlets in a PowerShell terminal. Connect-SPOService -Url https://yourorg-admin.sharepoint.com/ -Credential admin@yourorg.onmicrosoft.com (The parameter -Url points to the admin site.) Configure the new Document Library as Org Asset Type: BrandKitLibrary Add-SPOOrgAssetsLibrary -OrgAssetType BrandKitLibrary -LibraryUrl https://yourorg.sharepoint.com/sites/BrandGuide/brandkit In the above example "BrandGuide" is the SharePoint site and "brandkit" is the document library name. 3. Create a brand kit and add media within Clipchamp Select the 'Brand kit' section in the left side panel and select 'Create brand kit'. Choose the folder you designated as a BrandKitLibrary in the previous step. You may wish to share the brand kit to collaborate with colleagues on populating assets. To share the brand kit while preparing it, select "Share brand kit". Provide recipients with the link and ensure they have edit access. Sharing consistent assets across different locations ensures that every video being shared looks on-brand and reinforces brand recognition, no matter where it’s seen. Plus, we’ve made sharing brand kits simple by using familiar OneDrive patterns. That way, users don’t have to interact with unfamiliar technologies—just seamless access to everything you need, so you can stay focused on creating professional, polished content. Add a wide range of your media assets A screenshot of a video editing project in Clipchamp, with the brand kit panel open The brand kit feature in Clipchamp allows for a broad range of assets to be uploaded, ensuring that users can express their brand narrative through a variety of media. Clipchamp supports an array of branding elements, including logos, colors, fonts, images videos, graphics, music, and sound effects. A screenshot of a video editing project in Clipchamp, with the brand kit panel open. The cursor hovers over the 'Add colors' section, while logos, fonts, and images are also displayed There is a strong case for adding branded elements to enterprise content: it helps to easily generate a strong brand identity, while building trust with your audience, and maintaining a professional lens on content production. Clipchamp also allows users to upload multiple branding options, so you can add your primary and secondary color palettes, or light and dark design schemes. Feedback We are so excited to bring users some new additions to brand kit and would love to hear feedback around the organizational sharing experiences. Please head to this link to share with us your insights or feedback, so we can continue to create the best possible experiences for our users.481Views2likes3CommentsOffice 365 Backup
Iam Looking For: Find a backup solution for our Office 365 data such as SharePoint/OneDrive content, e-mails, calendars, contacts, notes, tasks etc. ! The harddrives of the machine definitly need to be encrypted. Not sure of synology can do that reliably (LUKS?). Synology had some security issues in the past, but they might have been only relevant if they are exposed to the internet. I think we have two options: Backup in the office on encrypted drives with very restricted access (SSH?) Encrypt backup and upload it to S3 (not sure if there's a tool for that) I'm fine with both. Is there an open source tool that can mirror Office 365 on a local machine? (Linux) is the Synology tool proprietary?2.9KViews0likes5Comments