Sometimes strings in Power Automate need to be reformatted so that the first letter of each word is capitalized. This is know as "Proper Case". There is no function built in to perform this common task. PowerApps does have this function so I expect … [Continue reading] about How to create Proper Case Strings in Power Automate
Publish SharePoint data on a public website with Power Automate
In this post I am going to demonstrate how to collect data from a SharePoint list using Power Automate and publish it in a jQuery grid on any website. Many businesses store data in data sources that are easily accessible by Power Automate that might … [Continue reading] about Publish SharePoint data on a public website with Power Automate
Add st, nd, rd and th (ordinal) suffix to a number in Power Automate
Sometimes you need to create an ordinal number for use in an email or similar situation. Power Apps does not have any support for this type of number formatting but it can be created quite easily with an expression. The rules are as follows: st … [Continue reading] about Add st, nd, rd and th (ordinal) suffix to a number in Power Automate
Working with locked documents in Power Automate Flows
If you are updating the status of a document in a Microsoft Power Automate flow that someone is already using, you will get this error: and it will return a HTTP Status code of 400: Below is a method that waits for the file to be free and … [Continue reading] about Working with locked documents in Power Automate Flows
Easily convert Excel Dates to usable Power Automate Dates
When you use the "List rows present in a Table" action in Power Automate to get data from Excel that contains dates, you might be surprised to see that the data in the date column is actually an integer and not a date. Take a look at this Excel … [Continue reading] about Easily convert Excel Dates to usable Power Automate Dates