Use SharePoint view column formatting for displaying pictures and conditional formatting Tuesday, December 4, 2018 8:00 AM Toni Pohl Today I want to share just a quick tip for custom formatting views in SharePoint lists since I need them from time to time. My goal was to show a picture of a text field with an URL and to use conditional formatting with a traffic light system to visualize the sentiment of tweets that are written to a SharePoint Online custom list from a Flow. See the formatting options here. App | Cloud | Design | English | Flow | Microsoft | Microsoft365 | Office365 | Open Source | SharePoint | atwork | Tools | Developer Mediumlink | Permalink | Comments (0) | Post RSS mehr
Office 365 Groups Governance Toolkit Part 4-Ownerless Groups Monday, December 3, 2018 4:00 PM Martina Grom In this multi-part series we show you how to handle the Office 365 Groups and Microsoft Teams governance toolkit. The next article cover the governance part of our Groups Governance Toolkit.Imagine your company policy requires at least 2 owners per Office 365 Group or per Microsoft Team. In this part, we want to monitor all groups that are ownerless (orphaned), or do not comply with our organization's policies. The IT department shall get the information of all groups and teams where there are no owners or not enough owners and the possibility to fix that. Read below how this can be accomplished. Azure | Developer | English | Microsoft | Office365 | Microsoft365 | PowerShell | Tools | atwork | Cloud | DevOps | Flow | GitHub | Governance | Logic apps | Microsoft Teams Mediumlink | Permalink | Comments (0) | Post RSS mehr
Office 365 Groups Governance Toolkit Part 3-Develop Azure Functions Sunday, December 2, 2018 4:00 PM Martina Grom After the introduction of the Office 365 Groups and Microsoft Teams Governance Toolkit and with the necessary requirements we are now looking into Azure Functions. In our group and team provisioning scenario, we need a little code for provisioning of an Office 365 group and a Microsoft team. Serverless computing with an Azure Function provides the optimal solution for that. Follow these steps to create the function we need for our workflow. Azure | Cloud | Developer | English | Microsoft | MVP | Microsoft365 | Office365 | PowerShell | Tools | atwork | Flow | GitHub | Governance | Logic apps | Microsoft Teams Mediumlink | Permalink | Comments (0) | Post RSS mehr
Office 365 Groups Governance Toolkit Part 2-Provisioning requirements Monday, November 26, 2018 5:00 PM Martina Grom In part 1 of this series we described the scenario for our Office 365 groups governance toolkit. In this part we will setup a workflow for the Office 365 and Microsoft Teams provisioning. Workflows help to follow specific processes for a successful collaboration. Offering self-services for users is a key to reduce workloads on the IT department and to allow users to cover their requirements quickly while the organization's policies are enforced during the process. A frequently asked request is how to provision a new Microsoft Team in Office 365 in a secure and monitored way. See how this can be implemented here. To allow an app to create a Microsoft group or team programmatically in a workflow, we will use the Microsoft Graph API, Azure Functions and Flow or Logic Apps. With these technologies, we can create powerful workflows to offer a self-service for users to create a team when needed, approved by the manager and being provisioned with all the necessary properties and permissions. Azure | Cloud | Developer | English | Microsoft | MVP | Microsoft365 | Office365 | PowerShell | Tools | atwork | Flow | GitHub | Governance | Graph | Logic apps | Microsoft Teams | SharePoint | Yammer Mediumlink | Permalink | Comments (2) | Post RSS mehr
Change a connection for existing Azure LogicApps Friday, October 20, 2017 2:00 PM Toni Pohl If one of your coworkers created a LogicApp some months ago and you want to "de-personalize" the connections used in a flow, you can modify the settings easily – if you know how to. Azure | App | Cloud | English | Developer | Microsoft | Flow | Business Intelligence Mediumlink | Permalink | Comments (0) | Post RSS mehr
Provisioning an Office 365 group with an approval flow and Azure functions-part 3 Thursday, October 5, 2017 8:00 PM Martina Grom This article describes the workflow for the group provisioning process by using the Azure function from part two in combination with PowerApps, SharePoint Online and Flow to enable a good user experience. Technically, we already have the toolset with the ProvisionGroup function. Now let’s create the rest. Azure | App | Cloud | Developer | English | Exchange | Microsoft | MVP | Office | Office365 | PowerApps | Event | PowerShell | SharePoint | Flow Mediumlink | Permalink | Comments (5) | Post RSS mehr
Provisioning an Office 365 group with an approval flow and Azure functions-part 1 Thursday, September 28, 2017 3:30 AM Martina Grom Office 365 groups span over various Office 365 services and provide a great way for collaborating. By default, every user can create an Office 365 group. While self-service is a good thing and many businesses adopted into that direction, some companies still prefer the controlled approach. In real world environments, organizations usually want to restrict the group provisioning so that IT can control the wild growth of groups. This article series shows how to create an Office 365 group with an attached approval process with SharePoint Online, Flow and Azure functions. See how this works here! Azure | Cloud | Developer | English | Exchange | Microsoft | Office | Office365 | PowerShell | SharePoint | Flow | App | MVP | Event | PowerApps Mediumlink | Permalink | Comments (8) | Post RSS mehr
Integrate Microsoft Flow with an onprem SQL Server Tuesday, April 25, 2017 6:00 AM Jörg Schoba The blog shows how a Microsoft Flow can be integrated with an onprem SQL Server and retrieve and filter data dynamically from the database. Azure | Cloud | Flow | Microsoft | Office365 | SQL Server Mediumlink | Permalink | Comments (0) | Post RSS mehr