Schlagwort: HowTo (Seite 1 von 3)

Will it WLED? Outdoor LED Strip

Februar 3, 2026 / Adrian Ritter / Keine Kommentare

For the smarthome related project this holiday I was inspired by Chris Mahers YouTube Series „Will it WLED„. So I bought an APPECK permanent outdoor LED wich I want to control with WLED.

From time to tim as special offer at Amazon (https://www.amazon.de/dp/B0FS11YD2V)

To control LEDs with WLED it is kind of obvious that you need supported LEDs. Because usually there is no information about the used LEDs, there is a bit of gambling but based on Chris videos I was confident that the Appeck LED strip will work.

Technical Specs of the LED-Strip:
Model	C5109-C
Length	30m
Segments	6 / 5m
LEDs per segment	12
Over all LED count:	72
Power Input	AC 100-240V
Power Output	DC 24V
Wattage (max)	54W
Color	RGBW
Brightness	RGB: 1900LM W:2800LM
Color Temp.	W: 2700K
Conrtrol Methods	2,4GHz WiFi / App / Remote / Voice
Operating Temperature	– 20 °C – + 40 °C

Vacuum robot without cloud – Viomi SE with Valetudo

Januar 25, 2024 / Adrian Ritter / Keine Kommentare

For some time I thought about integrating an vacuum robot into our smarthome. But as the rest of the smarthome the robot should work offline. So I came across Valetudo Firmware an the list of supported robots: Supported Robots | Valetudo

Next step was, to find a supported robot for a reasonable price. I came across a Viomi SE at an Amazo Warehouse deal in „Good“ confition for 150€ so i decided to give it a try.

Setup Syntex Pay As You Go

August 20, 2023 / Adrian Ritter / Keine Kommentare

On 1st of July Microsofft changed the Licensing options.

So existing Syntex per user licenses can still be assigned and used but they are no longer an option for new licenses. This does not affect SharePoint Syntex Advanced Management licenses.

Project Moon Wall – Wall panel out of the 3D Printer – Part 3

August 16, 2023 / Adrian Ritter / Keine Kommentare

In the thrid part of the series, I describe how I mounted the moon tiles on the wall behind my TV.

Project Moon Wall – Wall panel out of the 3D Printer – Part 2

August 3, 2023 / Adrian Ritter / Keine Kommentare

In Part 2 of this 3 Part series I want to adress some of the issues and learnings I came across while printing the 26 wall panels.

SharePoint Site Template with Emoji 📚🚀⭐

April 6, 2023 / Marvin Bangert / Keine Kommentare

Hey folks,

Today we will have a look at how to add Emoji into your SharePoint site script / site template. You might already notice, it’s easy to add them manually into your navigation, but it’s hard to add via Site Designs. Let’s get started.

Power Automate – Error handling

März 26, 2023 / Marvin Bangert / Keine Kommentare

Hi folks,

Today we will check out some configuration you can do to handle your errors in Power Automate cloud flows. No system/flow is perfect, so always assume your flow can fail at any point, so let’s prepare for it.

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.

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.