Kategorie: Uncategorized (Seite 2 von 4)

Power BI: Divison wanted – my German ‘Bezirksliga’ suggestion

Juni 26, 2022 / Marvin Bangert / Keine Kommentare

Hey folks,

if you know me, you probably know I am very interested into playing, watching or talking about football (or “soccer”). After decades my home club finaly reached again the seventh German ‘Bezirksliga’ and a German community platform and news publisher “FuPa.net” about amateurs football was looking for suggestions how to split the league. So I decided to make my suggestion and building a Power BI report to help me and also make it visual. Today we will learn about the German football leagues, Power BI, Geocoodinates and how to calculate distances, Power BI Bookmarks, how to use custom functions and make API calls in Power BI and to get some webbrowser content using Power Automate Desktop.

Stream (on SharePoint) Übersicht und Stream on SharePoint Portal

Mai 29, 2022 / Adrian Ritter / Keine Kommentare

Seit Microsoft 2021 angekündigt hat Microsoft Stream (Classic) nicht weiter zu entwickeln und zugunsten von SharePoint Online / OneDrive for Business einzustellen ist einiges geschehen. Die offensichtlichste Änderung, zumindest in der Dokumentation, ist die Unterscheidung in Stream Classic und Stream on SharePoint. In gewisser Weise ist es also ein Rolle rückwärts, von Office 365 Video über Stream zurück zu Stream on SharePoint.

Allerding nicht ganz, denn der Ansatz ist ein anderer als noch zu Office 365 Video Zeiten. Zukünftig sollen Videos in SharePoint Online und OneDrive for Business ähnlich behandelt werden wie Office Dokumente. Also deutlich besser integriert als bisher.

Alle Funktionen die wir aus dem Stream (classic) Portal kennen haben es allerdings noch nicht nach SharePoint geschafft, welche Video spezifischen Funktionen aktuell schon zur Verfügung stehen möchte ich im Folgenden einmal betrachten:

Schon seit längerem verfügbar: Stream on SharePoint Portal Zu erreichen ist das neue Stream Portal über https://stream.office.com

Power Automate: Turn SharePoint values to columns

April 16, 2022 / Marvin Bangert / Keine Kommentare

Hey folks,

today we will learn how to turn SharePoint values into columns. This is just a simple example of a SharePoint list with some information (could be single line of text or choice, choice would be better to make sure your values are always written the same).

Power Automate: Trigger conditions

März 22, 2022 / Marvin Bangert / Keine Kommentare

In Microsoft Power Automate, flows are executed as soon as the trigger is met, e.g. an item is created or edited in SharePoint, a new Microsoft Forms survey has been filled out, or an email is received. But sometimes the flow should only start when a certain condition is met, for example the SharePoint list value has a certain value. For this there are the trigger conditions in Power Automate, which I would like to go into in more detail below.

Lenovo ThinkVision m14t an Desktop PC nutzen

Februar 20, 2022 / Adrian Ritter / 5 Kommentare

Heute von mir mal ein wahrscheinlich etwas nieschiger Post :) Seit längerem habe ich mit dem Gedanken gespielt einen mobilen Monitor anzuschaffen, sozusagen als Dual-Display im mobile Office. Mittlerweile findet man eine breite Auswahl in einer eben so breiten Preisspanne. Aufgrund des Touchdisplays mit der gleichen Digitizer Technologie wie bei meinem Notebook und dem Anschluss über ein USB-C Kabel fiel die Wahl auf das ThinkVision m14t Display. Würde es in dem Artikel nur um den Betrieb am Notebook gehen, könnte der Artikel hier schon zu ende sein. Kurz gesagt es funktioniert einfach. Nun dachte ich mir aber, es wäre ja schön das Display auch an meinen Desktop PC anschließen zu können. Worauf es dabei ankommt möchte ich hier kurz festhalten.

Power Automate – Add Business Days to Date (Excludes Weekends)

Januar 13, 2022 / Marvin Bangert / Keine Kommentare

Hey folks,

today I came across a problem on within the Power Platform forum on how to “Add days to a date without weekends”. Thanks Matthew Devaney who posted a blog post about “How to add business days to a date in Power Apps(Excludes Weekends)”, so I could use this as an guideline to translate it into Power Automate. Here you will find the code on how to add business days to a date in Power Automate: The setup is pretty simple, I just added a trigger “Manually trigger a flow” with a date input “myDate” (triggerBody()[‘date’]) and a number input “addBusinessDays” (triggerBody()[‘number’]). Next I added a “compose” action and used the following code:

Power BI Azure AD Error – Power BI App Permission required

Dezember 9, 2021 / Marvin Bangert / Keine Kommentare

Hey folks,

today I came across a problem on a customer site within Power BI when trying to update an App and giving access to other users within a workspace. I want to share the solution with you, hope it will help you.

Power Automate – Create SharePoint Page from Word document

Oktober 30, 2021 / Marvin Bangert / Keine Kommentare

Hey folks,

recently I came across a question in the Power Automate community forum, where retrofuture came up with the question to generate a SharePoint Page filled with a word document content uploaded/created in SharePoint Online. The basic idea came from a Youtube video by Lernen Tech / Krishan Sharma, who used a SharePoint list. In this article you will learn how to get the content from a Word document and publish it on a new SharePoint page. So in general we have two different things to achieve, first we need our Word document content as plain text (or better as HTML), the second is to create a new SharePoint page. The second thing is already pretty good explained in the video, we will just make a couple of changes, but first things first.

SharePoint Library View In File Explorer

Oktober 22, 2021 / Adrian Ritter / Keine Kommentare

Back in the days in SharePoint On-Prem there was a control that let you open a SharePoint Library in Windows Explorer. This was a handy feature, for example mass copying of documents. This feature also made it to SharePoint online, but always was depending on Internet Explorer. Last year Microsoft announced that it will bring this functionality to Microsoft Edge and the Modern UI of SharePoint Online Libraries.

Power Apps reorder items in collection

August 26, 2021 / Marvin Bangert / Ein Kommentar

Hey folks,

maybe you already came around the situation, that you want to reorder your Power Apps collection before saving it, to bring your task in the correct order or just want to rearrange it in your source (like SharePoint Online). In this article you will learn how to reorder your collection in an app.