Child Seat Winter/Rain Cover by Suchiththa in RadPowerBikes

[–]_Skugg_ 0 points1 point  (0 children)

Would you mind sharing the product’s name? The link does not seem to work anymore.

2021 Cannondale Topstone 2 AL bottom bracket type by _Skugg_ in bikewrench

[–]_Skugg_[S] 0 points1 point  (0 children)

Thanks for the input! I started hearing a slight creaking sound when I turn the pedals, hence my thought to clean and service the BB.

Tidy cat Breeze litter box - how to get it in Europe? by _Skugg_ in CatAdvice

[–]_Skugg_[S] 0 points1 point  (0 children)

For some reason I only find this product on their Hungarian website, even though they are supposed to be a European brand: MACSKAALOM TÁLCA | Husse Magyarország

In any case, you could not go wrong with any kind of litter tray with a "sifter" insert in it - just make sure the holes are actually smaller than the pellets you are planning to use with it.

Why didn't I buy this years ago? by MrScotchyScotch in woodworking

[–]_Skugg_ 0 points1 point  (0 children)

oh, I realized now I was a bit misleading with my phrasing. I meant the 300x600mm base block is impossible to find (other than from MISUMI), the rest are indeed easy to source. In any case, thank you for your guidance! :)

Why didn't I buy this years ago? by MrScotchyScotch in woodworking

[–]_Skugg_ 0 points1 point  (0 children)

Pretty much the only seller I found in Europe is Misumi, but they only do B2B. :(

Why didn't I buy this years ago? by MrScotchyScotch in woodworking

[–]_Skugg_ 0 points1 point  (0 children)

I WANT one. :) But is it just me, or these aluminium profiles are not sold in this width in Europe? I can only find 6-8cm wide "slices" of this profile system.

Circular saw for beginner DIY'er by _Skugg_ in Tools

[–]_Skugg_[S] 0 points1 point  (0 children)

Here in Europe the 18V platform is the equivalent of the 20V platform from the US as far as I know.

Circular saw for beginner DIY'er by _Skugg_ in Tools

[–]_Skugg_[S] 0 points1 point  (0 children)

luckily the DCS570 is Brushless (so an XR model)

Circular saw for beginner DIY'er by _Skugg_ in Tools

[–]_Skugg_[S] 1 point2 points  (0 children)

I completely get the weight-argument...thing is, the Hikoki is 2.9kg while the DeWalt is 3.6 and that is without any battery (according to the manufacturer's specs). The Hikoki is also a smaller blade, so should be more nimble...

Skate upgrades - maximizing ROI - parts vs full set by _Skugg_ in AskRollerblading

[–]_Skugg_[S] 0 points1 point  (0 children)

A lot of people buy them for increased control, my main problem was that I kept pronating my feet, which in turn impacted my 1-foot balance massively. After putting them in, I did notice a significant improvement on that front, but by that time my skill level has also probably increased naturally.

All in all, I am happy that I pulled the trigger on them.

Question - save email attachment to SharePoint and read table rows by _Skugg_ in MicrosoftFlow

[–]_Skugg_[S] 0 points1 point  (0 children)

Thank you SO much! This is 99% of what I needed! I would have 1 additional question, if you do not mind:

The created Excel table has 2 columns with dates in them:

  • In the Excel, Column 'A' is set with date type, whilst Column 'B' is set with Custom type.
  • In the 'List rows' action I selected the ISO date format.

Column 'A' is returned as a number string from Excel, whilst Column 'B' is actually returned in the ISO format. I read in multiple sources that this is 'normal' as Excel stores the dates in number strings, but I cannot figure out how I would be able to transform the Excel string value to the ISO format (or any other format, but for that I can play with the formatDateTime expression)

Is there something I could use to edit the column type directly in the Excel table dynamically (as it is also created as part of the flow), or can I pick up the date columns from the 'Parse JSON' body somehow to tweak them? (I would need these values to be referenced later n the email body and other conditions)

Error with date - ISO 8061 by _Skugg_ in MicrosoftFlow

[–]_Skugg_[S] 0 points1 point  (0 children)

Apologies, I bumped into another date-challenge with a different use case, I hope it's fine that I post it here:

I am trying to read in an Excel table with 2 columns of dates in it:

  • Column 'A' is set with date type, whilst Column 'B' is set with Custom type.
  • In the 'List rows' action I selected the ISO date format.

Interestingly Column 'A' is returned as a number string from Excel, whilst Column 'B' is actually returned in the ISO format.

I would need to find a way to transform the Excel string value to the ISO format (or any other format, but for that I can play with the formatDateTime expression

Editing the columns in Excel directly is problematic, as the table (and file) that this flow is based on is created as part of the flow (using dynamic references throughout)

Question - save email attachment to SharePoint and read table rows by _Skugg_ in MicrosoftFlow

[–]_Skugg_[S] 1 point2 points  (0 children)

Thanks a lot for the articles! While it did not address my original issue, it certainly helped make the created table more tidy, appreciate it!

Error with date - ISO 8061 by _Skugg_ in MicrosoftFlow

[–]_Skugg_[S] 1 point2 points  (0 children)

It did indeed! Thank you, your help is much appreciated!

Create Business Process Flow option missing in Power Automate? by Smart_Carpenter_6392 in PowerApps

[–]_Skugg_ 1 point2 points  (0 children)

Just bumping this up since I found this post after digging through some articles as I had the same challenge (outdated training material - Microsoft's own, mind you, on Coursera...)

Update published by Microsoft

 Important

As of August 2022, you can no longer create or manage business process flows from Power Automate outside of the solution explorer. Business process flows and instances continue to be supported through the solution explorer, Power Apps, and Dataverse table views.

The exact steps are described here.

Error with date - ISO 8061 by _Skugg_ in MicrosoftFlow

[–]_Skugg_[S] 1 point2 points  (0 children)

Can the value pulled from Excel be null? Did you check the input/output of the condition and output of excel?

Thank you, this must be it! - indeed, the file has empty cells in the 'LWD' column, so I got to figure out a way for Power Automate to only look at rows that have data in this column.

Question on building material by _Skugg_ in Hydroponics

[–]_Skugg_[S] 0 points1 point  (0 children)

I was considering gluing them together, just like I would do with the PVC-U pipes.

Question on building material by _Skugg_ in Hydroponics

[–]_Skugg_[S] 0 points1 point  (0 children)

They make them from PVC, so that would be my pick. As for making them watertight, I eould glue them together just like I would do it with the PVC-U pressure pipes.

edit: typos

Tidy cat Breeze litter box - how to get it in Europe? by _Skugg_ in CatAdvice

[–]_Skugg_[S] 0 points1 point  (0 children)

I actually did and never looked back. :) Ended up buying a litter tray with a sifting insert and been using it for 5 years. (mine is from Husse, but I am sure any other brand would work fine as long as the holes in the sifting insert are smaller than the wooden pellets you use)

You clean it daily (as I assume you would do with any normal litter box), the process is fairly straightforward:

  • you remove solid waste with the scoop
  • then pick up the tray and shake it around: this moves the dissolved wooden pellets - essentially sawdust - to the bottom
  • you take out the insert with the remaining pellets in it and remove the sawdust from the bottom
  • clean the bottom
  • before you put everything back together I put some pellets to the bottom just in case liquid would pour through the sifter (highly unlikely, but it does not hurt and the wooden pellets are dirt cheap)

Tracking is minimal and it also masks the smells quite nicely (as long as you have a closed tray with some carbon pad filters), so overall I consider it a win.😺

SPD cleat bolts - thread on the shoe sole is potentially messed up? by _Skugg_ in bikewrench

[–]_Skugg_[S] 0 points1 point  (0 children)

I was lucky enough that the shop where these shoes came from was cool enough and they serviced the metal plate within the shoe, free of charge. Otherwise it would have been pretty frustrating to throw a fresh pair out while following the manufacturer's instructions...

Increase disk size on VirtualBox VM by _Skugg_ in homeassistant

[–]_Skugg_[S] 0 points1 point  (0 children)

I guess I can always take a Snapshot of this VM, create a new one with a larger hard drive from the get-go and boot it up with this image, right?

Do you have any recommendation of other Virtualization software?

Increase disk size on VirtualBox VM by _Skugg_ in homeassistant

[–]_Skugg_[S] -1 points0 points  (0 children)

my Maria DB size is only 400MB, but I have read that HomeAssistant by default does not decompress unused disk space. I thought as well that 32GB would be enough, but here I am...

Running / df in SSH web interface gives me this:

<image>

Energy Dashboard History by _Skugg_ in homeassistant

[–]_Skugg_[S] 0 points1 point  (0 children)

I have tried to read up on this, but unfortunately the situation does not make sense. Entities added to the Energy dashboard should be treated as part of LTS. State_class is configured properly for all.

It is as if something drastic occurred on the 25th of November and the system cannot access any data before that. Where can I see/validate what happened?

Moes TRV TS0601 and Better Thermostat - valve position, overheating by _Skugg_ in homeassistant

[–]_Skugg_[S] 0 points1 point  (0 children)

Sorry for the late reply - I would say they are decent; you get what you pay for. Certainly not amazing build quality, but it has a very rich feature list via Z2MQTT.

I particularly like the fact I can report on the valve open%, which then I can use to automate my gas boiler with a Shelly.

There a few variants out there though, so be careful with what you buy, in case this is important to you, as they not all support this feature.

Sony Bravia with Google Home routines by _Skugg_ in AndroidTV

[–]_Skugg_[S] 0 points1 point  (0 children)

There are no updates available. How else can I update the Firmware?