SHIFT-WIKI - Sjoerd Hooft's InFormation Technology
This WIKI is my personal documentation blog. Please enjoy it and feel free to reach out through blue sky if you have a question, remark, improvement or observation. See below for the latest additions, or use the search or tags to browse for content.
Create Email Report with Flow to Report All SharePoint Online List Items
Summary: How to use Microsoft Flow (Power Automate) to create an email report on SharePoint Online list items.
Date: Around 2020
Refactor: 1 March 2025: Checked links and formatting.
It can be very beneficient to create an email report on all items that were created in a SharePoint Online list in the previous month. To do so, I created two flows, one to create the email and another one to intercept that email to store it on sharepoint online as a bonus (and as a evidence case).
Use Flow to Parse Email Body to SharePoint Online List Items
Summary: How to use Microsoft Flow (Power Automate) to parse an email body to a SharePoint Online List.
Date: Around 2020
Refactor: 1 March 2025: Checked links and formatting.
This is one of the more complex things you might want to do with flow. It takes a lot of work, and it is very imported the email you want to parse has a structure so you can put some logic into it.
Use Microsoft Flow for handling Email
Summary: How to use Microsoft Flow (Power Automate) to automatically handle email.
Date: Around 2020
Refactor: 1 March 2025: Checked links and formatting.
On this page you'll see the flows I created for automatic email handling. The following functionality is used:
- Detect a new mail in a shared Office 365 email box
- Check for advanced options in the email like sender address, subject and if the email has an attchment
- Get the attachment and save it in Sharepoint Online
- If the folder dows not exist, create it with a name like year-month format
- Use a condition on the body part of the email
- Save an email on SharePoint Online with the current date in the filename
- Mark the email as red
I used two flows for this.
Fix: X11 Forwarding Font Error
Summary: The fix for a setFont error during a Oracle installation on AIX, done from a Windows box using Cygwin.
Date: 17 June 2009
Refactor: 26 January 2025: Checked links and formatting.
I received this error when trying to install Oracle 10.2g on AIX 5.3. All Oracle requirements were met, so it didn't make sense. Turned out it missed the fonts on my CygWin - X on Windows installation.
Error:
Starting Oracle Universal Installer...
No pre-requisite checks found in oraparam.ini, no system pre-requisite checks will be executed.
Preparing to launch Oracle Universal Installer from /tmp/OraInstall2009-06-17_11-07-38AM. Please wait ...bash-3.2$
Warning: Cannot convert string "-*-lucida-medium-r-*-*-*-*-*-*-*-*-iso8859-1" to type FontStruct
Exception in thread "main" java.lang.InternalError: java/langNullPointerException
at sun.awt.motif.MComponentPeer.pSetFont(Native Method)
at sun.awt.motif.MComponentPeer.setFont(MComponentPeer.java:308)
at sun.awt.motif.MComponentPeer.initialize(MComponentPeer.java:236)
at sun.awt.motif.MComponentPeer.init(MComponentPeer.java:279)
at sun.awt.motif.MWindowPeer.init(MWindowPeer.java:123)
at sun.awt.motif.MFramePeer.<init>(MFramePeer.java:91)
at sun.awt.motif.MToolkit.createFrame(MToolkit.java:301)
at java.awt.Frame.addNotify(Frame.java:502)
at java.awt.Window.pack(Window.java:473)
at oracle.sysman.oio.oioc.OiocOneClickInstaller.createCenterPanel(OiocOneClickInstaller.java:802)
at oracle.sysman.oio.oioc.OiocOneClickInstaller.init(OiocOneClickInstaller.java:409)
at oracle.sysman.oio.oioc.OiocOneClickInstaller.createFrameElements(OiocOneClickInstaller.java:365)
at oracle.sysman.oio.oioc.OiocOneClickInstaller.main(OiocOneClickInstaller.java:2171)
This is how to check if the required fonts are installed:
C:\cygwin\bin>cygcheck -c -d | grep font fontconfig 2.6.0-1 ghostscript-fonts-other 6.0-1 ghostscript-fonts-std 8.11-1 libfontconfig1 2.6.0-1 libfontenc1 1.0.4-2
As you can see, no fonts…
I changed my own howto on installing CygWin - X on Windows, and after also installing the correct fonts it worked, and this is, how the previous command output looks like when the fonts are installed:
C:\cygwin\bin>cygcheck -c -d | grep font font-bh-dpi75 1.0.0-1 font-bh-lucidatypewriter-dpi75 1.0.0-1 font-encodings 1.0.2-1 fontconfig 2.6.0-1 ghostscript-fonts-other 6.0-1 ghostscript-fonts-std 8.11-1 libfontconfig1 2.6.0-1 libfontenc1 1.0.4-2 mkfontdir 1.0.4-1 mkfontscale 1.0.5-1