For those who created Flows with Boolean values not wanting ugly True or False as the end result, there is an easy way to convert those to Yes or No. All you have to do is to add an IF function in the following format. When used with Variables, you can select Type as Boolean and then use ... » Learn More about Convert Boolean values True or False to string values Yes or No in Microsoft Flow
Tutorials
How to build an Email Parser in Microsoft Flow (Extract text from email body)
Email Parser is a very useful tool if need to manipulate the information contained in the email body. In this example, I will show you how to build an Email Parser Flow and how to extract text from an email received from PayPal. We will start by creating a new Flow from blank. Go to Microsoft ... » Learn More about How to build an Email Parser in Microsoft Flow (Extract text from email body)
Windows 10 1803 new OEM (or ESP) Partition
So Windows 10 1803 update creates another OEM partition. In my case, the new partition decided to take over one of my existing drive letters, G: that was mapped to a shared network location. This was confusing, because my G drive (4TB) suddenly became empty. Disk Management revealed what the ... » Learn More about Windows 10 1803 new OEM (or ESP) Partition
Unprotect Excel Worksheets without Password
So, you forgot your Worksheet password, but you can still access the Spreadsheet file? The difference between a Spreadsheet and a Worksheet is that an Excel Spreadsheet file contains Worksheets that some people call "tabs". See screenshot below. To Unprotect Worksheet(s) all you need to do ... » Learn More about Unprotect Excel Worksheets without Password
Calculate Ratio Between Two Numbers
Calculate Ratio with GCD In this example, there is a list of screen dimensions, with the first width -- 400 -- in cell B4 and the first height -- 300 --in cell C4. To calculate the ratio for each screen, the formula will use the GCD function, which returns the Greatest Common Divisor, for two or ... » Learn More about Calculate Ratio Between Two Numbers