SharePoint

Sometimes it´s good to get data from a data source as a table and as quickly as possible in an automated way. While this can be done with multiple ways, here´s a quick solution if you want to get the items from a custom list in SharePoint Online sent as a HTML table in an email with Azure Logic Apps (or Power Automate). In this sample, we assume we have a custom list in a SharePoint Online site that includes some hundred lines of data with license requests and billing information. We want to get specific items that will expire in near future where there´s no invoice set. We will do this with a filtered query. The result shall be formatted as HTML table and sent to an email address. Azure Logic Apps and Power Automate (Flow) is perfect for such a quick task. ...

Recently, I stumbled across a strange behavior when running self-developed SPFx webparts in various browsers. When the SPO app was deployed, it worked well with Single-Sign-On, but in some browsers, the webpart was blocked. Instead, a grey box saying “login.microsoftonline.com refused to connect.” was displayed. I experienced that behavior in Chrome, and Edge, while FireFox, Safarai and Opera showed the webpart. Also, there was a different experience when working in the normal mode, or in the In-Private mode. If that happens to you, check out the solution here. ...

Global Microsoft 365 Developer Bootcamp is back! This year the event will take place virtually from more than 100 cities worldwide. Join us at our Microsoft 365 Developer Bootcamp - Austria on November, 13th, 2020! The Global Microsoft 365 Developer Bootcamp is here for the 4th year straight. Check out Microsoft 365 Events Bootcamps and join us at our bootcamp in Austria using Microsoft Teams. Register now! We are excited to kick off the virtual Global Microsoft 365 Developer Bootcamp Austria 2020! The Microsoft MVPs and community leaders invite YOU to attend this bootcamp to learn the latest on Microsoft 365 platform such as Microsoft Graph, SPFx, Microsoft Teams, the Power Platform, Bots, AI and more. Learn how to apply the latest technologies to your future projects. ...

From an historical point of view, various single services such as Exchange and SharePoint Online have been integrated into Office 365, or as it´s named now, Microsoft 365. The platform shows user profile pictures, and syncs that between the services, depending on the service (licenses). Since this can be a little bit confusing, we now have a good article explaining the user profile sync. User profile picture sync is a important topic for every organization using Microsoft 365. In the end, you want to see users picture in people pickers, in Teams chats and calls, in Exchange, Delve, and so on. We have written some articles about that topic as well in the past, see SharePoint Online UserProfiles and the story about synchronizing with Azure Active Directory-Part 1, Part 2, How user profile synchronization works in Office 365 services and How the UserProfile in Azure Active Directory and how a Mailbox in Exchange Online looks like (using Microsoft Graph). We also have developed a solution for syncing user profile pictures from on premises systems to Microsoft 365. If you are interested in that, pls. contact us. ...

Microsoft 356 helps you communicate from anywhere. Today, the Microsoft 365 Virtual Marathon online event starts and I show different services like the quick to use crisis communication SharePoint site the Microsoft Health Care Bot service and more. Check out the Microsoft 365 Virtual Marathon and see how to start with these two services here. Microsoft 365 Virtual Marathon You can still join the free 36-hour Microsoft 365 Virtual Marathon online event and attend hundreds of interesting sessions, see the schedule. We from atwork will present the following sessions: ...

Today´s another quick tip for Microsoft 365 users: If you are using OneDrive for Business (OFB) and encounter the default 1 TB storage limitations, there is a way to get more storage space. To do so, see the article by John Patrick White at Increase your OneDrive Storage Limit beyond 5 TB and Joel Olson´s blog post at Three tiers to increase to unlimited storage in OneDrive for Business. It is not very well known that the storage quota can be controlled and extended. Thank you guys, this is valuable for many Office 365 users with a lot of files! ...

Delegate365 v9.1 provides basic management of SharePoint Online (SPO) sites that are assigned to an OU. See the prerequisites (part 1) and the features (part 2) here. Part one - Create the SPO app once Register the SPO app and to add that data in Delegate365. This needs to be done once by a Global Admin of the tenant. Important: Do the SPO app setup FIRST: To allow communication between Delegate365 and the SPO system, an app is required. Follow the steps described at Register SharePoint Add-ins to create the app or follow the step-by-step instructions here. ...

We are looking forward to this year´s SharePoint Conference (SPC) in Las Vegas in May! Sharepoint Conference 2020 offers over 200 sessions, panels and workshops covering all topics around SharePoint, Teams, and the Power Platform. This is an event for everyone working in the Microsoft 365 workspace. We from atwork look forward to being there again. Plus, get a discount for SPC 2020 here! There will be an amazing line-up with more than 150 top-speakers delivering lots of news and insights into the SharePoint ecosystem. In addition to Microsoft speakers, there are also a lot of speakers from the community. We from atwork are honored to speak there with colleagues like Andrew Connell, Laura Rogers, Tony Redmond, Benjamin Niaulin, Daniel Glenn, David Warner, Dux Raymond Sy, Heather Newman, Laura Kokkarinen, and many more! ...

Using an Azure Logic app is often a quick fix for small computing tasks. So my scenario is as follows: I want to use a form on a website to offer text fields and file upload. The submit button is intended to send the data to a Logic App. The Logic App receives the data and writes it to a SharePoint Online list and sends a notification if necessary. See the implementation here. ...

The SharePoint Conference (SPC) returns to Las Vegas in May 2020! Sharepoint Conference 2020 is packed with over 200 sessions, panels and workshops for everyone working in the Microsoft 365 workspace. We from atwork look forward to being there again. The SPC 2020 event registration is already open and there are reduced price packages available. Additionally, find a discount code here! Vegas, baby! SPC 2020 takes place at the MGM Grand in Las Vegas, Nevada, May 19 - 21, 2020. The workshops start on May 17th. It’s time to add the event to your calendar and to follow @SPConf and #SPC20 on Twitter and to watch SharePointTV! ...