Office

PowerApps provide a good solution for small apps. They run on a device and connect to an online data source. But what happens if no data connection is available, for instance in a building? Well, you can develop a PowerApp that works offline and synchronizes local data to the data source when you’re back online. See how this works here! A basic demo app To show the basic functionality, I developed the following, colorful demo PowerApp. The app consists of one screen in tablet mode including a connection toggle control, two input fields for a name and an email address, two data tables and some buttons. The goal is to read and write data in offline and online mode. ...

Governance specifies the rules for an organization. The Office 365 collaboration platform allows to invite external users for contributing in groups. In this part, we want to monitor all groups that have external guests and inform the group owners, who has access to a group or a team. See how this works here. Get all groups with external guests We use the same mechanism as before, see the article about Orphaned Groups. A function runs e.g. every day, reads all existing groups in the Office 365 tenant, and writes each group in a queue. A second function is triggered by that queue and reads all the external group members for one group. The following graphics shows that process from a technical standpoint. ...

Delegate365 protocols operations in it’s audit logs. This log space can be accessed from entitled users and it’s simple to create a custom Power BI dashboard for your Delegate365 data. See how this works here step-by-step. Tip: The article Delegate365-Working with Audit Logs covers the methods for accessing the data and working with the audit logs as well. This article informs how to connect to your Delegate365 with Microsoft Power BI step-by-step and how create your custom dashboard. You need to have a Power BI license, see details at Power BI Pricing. ...

We from atwork will are looking forward to see you at SharePoint Conference North America 2019 that will take place in May 2019 in Fabulous Las Vegas. Check it out now and save $50 off your registration! SharePoint Conference North America 2019 will take place in the MGM Grand in Las Vegas, Nevada from May, 21st to 23rd, 2019. Add #SPC19 to your calendar! See the details at sharepointna.com. “The SharePoint conference returns to Las Vegas: the world’s biggest and most comprehensive event empowering you to achieve more in the modern workplace with Microsoft 365.” ...

Office 365 Home is a really cool offer for up to 6 users within your family. You get the Premium versions of Word, Excel, PowerPoint, Outlook, Publisher, 1 TB OneDrive cloud storage each for each person, the subscription includes 60 minutes of free Skype calls every month to phones in over 60 countries and more, as described here. Here’s how to invite your family members. We described the process at “How to use Office 365 Home for sharing or How to get 5 times 1 TB OneDrive storage and 5 times 60 Skype minutes per month” some years ago (and also in German). Anyway, since I keep forgetting how to invite family members to my (renewed) Office 365 Home subscription, here’s the documentation for that… ...

When working internationally, you can now use three time zones in your Outlook calendar. See how to configure this helpful feature here quickly. The default time zone in Outlook matches your current geographic location. This is based on the time zone configured in the Windows Control Panel. So, to add up two more time zones in Outlook, open the Files / Options / Calendar and select your second and third time zone as in the following screenshot. ...

In the Easter week, we joined the Microsoft Tech Summit Amsterdam. The event took place at RAI Amsterdam from March 28-29, 2018. See some impressions here. Beside the breakout sessions, Tech Summit provided experts panels, workshops, and booths to directly get in contact with the Microsoft teams and third party vendors and to ask questions. See more details at the conference website at www.microsoft.com/techsummit/amsterdam. We from atwork were glad to contribute with breakout sessions and a workshop along with speakers from Microsoft and some fellow MVP colleagues: ...

Office 365 Groups retention policies are very helpful to reduce orphaned groups in an organization’s tenant. Kindly, the Office 365 system sends out notifications to inform the group owner(s) to renew a group – or that a group will be deleted. What, if you oversee such a notification? See here how to restore an Office 365 group – thanks soft delete! So, in my case, I oversaw the notifications and saw that my “projects” group was no longer accessible. I got a HTTP 403-Forbidden message when opening the SharePoint site of that group. ...

After we returned from MVP Summit, we were proud to be part of Microsoft Tech Summit from March 14th to 15th in Paris. The cost-free roadshow took place in Paris Expo Porte de Versailles and delivered two days of news and How-To’s of the Microsoft cloud services. See some impressions here. Beside the breakout sessions, Tech Summit provided experts panels, workshops, and booths to directly get in contact with the Microsoft teams and third party vendors and to ask questions. See more details at the conference website at www.microsoft.com/techsummit/paris. ...

This week, the Microsoft Tech Summit roadshow took place in Frankfurt, Germany. On two days, from February 21-22, 2018, the cost-free roadshow informed about topics from Azure to Microsoft 365. We were happy to be part of the Tech Summit. See some impressions here. The keynote was delivered by Giovanni Mezgec, General Manager, Microsoft Office 365 Marketing and Corey Sanders, Director of Compute, Microsoft Azure. Then, there followed a variety of IT Pro Breakouts and Developer Breakouts. Beside the breakout sessions, Tech Summit provided experts panels, workshops and booths to directly get in contact with the Microsoft teams and third party vendors and to ask questions. See more details at the conference website at https://www.microsoft.com/de-de/techsummit/frankfurt. ...