English

Delegate365 v9.2.5 includes a new module showing a user´s authentication methods and the assigned devices. See the details here. Note: This update does not require a new setup, if the previous version was v9.2.4. Otherwise, the Admin has to run the setup after the update process. New authentication methods menu in Users: In the Users module, when a user is selected, the context menu shows the Authentication methods item. View and delete devices: After opening the Authentication methods menu, a panel opens and shows the assigned devices, and the last login to that device, as here. The admin can remove devices by clicking on the Delete icon per device. A confirmation with the device name follows, like for “Deleted Device” here: When confirmed, a toaster notification in the bottom right corner shows the successful removal of the device. That´s it. Continue as needed to cleanup old devices. ...

Static website hosting in Azure Storage is really cool and quick method for simple deployment scenarios. Azure CDN edge nodes provide the cache and distribution layer with custom domains, rules, and further configuration options for such a static website. But what to do if you update the static website and it doesn’t deliver the new content? How can you force an update? See the solution here. In this sample, we have a community website www.cloudusergroup.at running in Azure. You can find out how to create and to deploy a static website on an Azure Storage Account at Static website hosting in Azure Storage and a tutorial at Tutorial: Host a static website on Blob Storage. In this case, the website has a custom domain bound to the website with Azure CDN, see more at Quickstart: Integrate an Azure Storage account with Azure CDN. ...

Azure storage accounts are a great and inexpensive way to store lots of data. I am using Azure Table storage to store large amounts of structured data for various tools. I needed to filter all rows that have a specific field that shows Null. While this sounds simple, it is a bit tricky. Here’s how. The problem is that columns showing “Null” just don’t exist, but they are shown in list with Null. Therefore, it does not work to filter them out. In my example, I had a table with a column called Users (of type Int32) that contained items with a number and others that had no value. So, the following query filters for a timeframe and all items having a Users value greater than 0. Unfortunately, the query also shows elements with the Null value… ...

Delegate365 v9.2.4 is the latest update that brings new service health, guest user information, teams templates and other improvements. See the details here. Important: To upgrade to this version, Delegate365 setup must be run. We will inform all customers to make an appointment for the setup. This is required because the Delegate365 app needs additional permissions to read the service health (see below). Follow the steps at Delegate365-(Re)run the setup. The dashboard service health: As described at Delegate365 changelog 9.3-Service health, the old Microsoft Service Communications API has been retired by Microsoft. Therefore, the service health components in Delegate365 had to be changed. After the setup, the dashboard shows the service health properly again. The new service health shows more detailed information. Each service can be opened by clicking on it. ...

In Delegate365, a new Microsoft Team can be deployed using a teams template. Teams can also be cloned. Details can be found here. Menu Teams: A Microsoft Team is built on a Microsoft 365 Group. The Teams module can be found in the Groups / Teams menu. The following screenshot shows the new and adjusted functions. Create a new team with a teams template: As usual, click on the plus icon in the top left of the list. In the groups pane, enter the new team name and properties. By default, the Create a Team switch is set to Yes. Below that, there is a new dropdown control Template that allows to specify which teams template shall be applied to the new team. When done, click Save at the bottom of the panel. Usually the new team is ready after a few seconds to a minute. ...

This is a quick guide on how to use a button to update a bound field on a form in a Power App. Since this is a little tricky, here are the instructions. The sample The Power App here is a simple calculator (and not pretty, but functional). Product subscriptions are coming from a SharePoint Online list and populate the Data List control on the left. When the user clicks on a row, the item corresponding is shown in the detail fields on the right in an Edit Form. When the Calculate button is pressed, the OnSelect event calculates the fields below the button. It calculates the SubscriptionEndDate, which corresponds to the SubscriptionStartDate plus one month, the runtime, which is the number of days of the *SubscriptionStartDate *month, and the Total, which is the price - quantity. Also, the button updates the item in the data source. ...

Working with Microsoft Azure and Microsoft 365, Azure Active Directory as an identity and management system becomes more and more important. Like Active Directory, Azure AD grows throughout time with guest accounts, cloud accounts and synchronized accounts. From a governance and lifecycle point of view - and also for security reasons - it is therefore important to clean up Azure AD from time to time. The cleanup process supports a healthy lifecycle management. In this article we describe how to quickly identify guest users in your own Azure AD with on-board resources. ...

SharePoint (or Microsoft) lists provide a good storage for not too extensive structured data. Sometimes administrators want to restrict access to certain items or lines. This approach shows how you, as an administrator, can do this without using item permissions, but with simpler and easier-to-manage views and permissions. The goal Administrators often want users to see only certain records or only their own records from a larger list. Technically, it is possible to set permissions for specific users per item (see below). On the other hand, setting item permissions is not a good solution in every use case. If a SharePoint list is filled by a given user or by a task, and specific people shall see only their data in a list, depending on their department, or similar organizational information, setting item permissions can be elaborate in terms of effort. ...

I had to export email messages from a specific folder in my Outlook mailbox to a CSV file for further processing. Nothing special, just a quick export. I noticed that Outlook allows messages to be exported, but the date of the message is missing in the export file! Really? So here is a workaround to quickly export email messages using Graph PowerShell. Why PowerShell Of course there are many ways to export emails. Unfortunately, the Outlook method is unsatisfactory. When opening the File menu in Outlook for the desktop, there is an “Open & Export” menu which has an Import/Export function. Well, the wizard allows to export messages to a CSV or to a PST file. ...

Another challenging year is coming to an end. We would like to wish happy holidays and a happy new year to all of you. Once more, we say thank you for the good cooperation in 2021 and are looking forward to a healthy and successful 2022! As in previous years, this Christmas we are supporting a selected project with a donation. atwork is closed from December 24th, 2021 to January 9th, 2022. Our on-call duty and our support will be able to be contacted during the holidays. Our entire team will be back for you from January 10, 2022. ...