Toni Pohl

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. ...

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. ...

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. ...

Microsoft announced the retirement of the Microsoft Service Communications API (Msg MC299902). Therefore, we changed the service health components in Delegate365 to use the successor API functions with immediate effect and to get more data. A new setup of Delegate365 is required. See the details here. The Service health module in Delegate365 shows, what´s happening in a specific Microsoft 365 tenant at a glance to all authorized users. Contrary to the required authorizations in M365, this is not necessary in Delegate365. All admins can view the service health and the message center posts. ...

The Cloud Hub Teams app is a business application that provides data from your Microsoft 365 tenant, the Message Center and the Incident Center, as well as the status and history of global Azure services. Since Microsoft recently announced the discontinuation of the Microsoft Service Communications API, all organizations using the Cloud Hub Teams app have to renew their app permissions once in order to be able to use the successor API functions. See how it works here. ...