Did you know that you can automatically create dynamic charts (Pie / Column / Bar) using data in Excel by using Office Scripts and Power Automate? These charts can be created and returned as images to Power Automate and then used in any document of...
Continue reading...PowerAutomate
How To Parse any CSV to JSON Array
Learn how to dynamically parse any CSV file to a JSON Array. This Power Automate Flow will handle all shaped and sized CSVs. Copes with both Windows and Unix encoded files too. Useful concepts.
Continue reading...Amazing – saving an attachment to a custom folder or site
Save regular email attachments to SharePoint locations (folders or sites) based on the Subject or File Name using Power Automate Cloud Flows.
Continue reading...Retrieve Array of SharePoint List Choices via Cloud Flow
Have you ever had the need to retrieve an array of Choices for a SharePoint column? There is a little known REST call to the SharePoint API which will allow you to retrieve such information and format in an array to use later in your...
Continue reading...If, Else If, Else in Power Automate Simplified
You know the logic, if a logical expression is met, perform an action or expression, else if it matches another expression follow that outcome, otherwise do the fall back option. How do you create this in Power Automate? Well, you could use the switch action...
Continue reading...Easily address escaped characters in Forms Response
Escaped characters in your forms response or json data sources can be easily formatted with a simple expression. \”answer\” will become “answer”.
Continue reading...Expose SharePoint Data to the Web with HTTP API
Make available files on your SharePoint Document Library to your website via the PowerAutomate HTTP API.
Continue reading...One to one relationship between data in Flow
You’ve retrieved relational data from non relational datasources and you want to create a relationship for your Power Automate. In my example below I have used tables in Excel and a List in SharePoint where the records share a common primary unique ID and then...
Continue reading...Easily Send Email – Mail Merge with Attachments
Do you perform a weekly or monthly mail merge and have a requirement to send your customers a unique attachment like an invoice or personalised letter? I am going to show you how you can perform this process using Power Automate. If you have a...
Continue reading...Parse A CSV To JSON Array Quickly
It’s an age-old problem, you have a CSV file that you want to parse into a JSON Array and you want a single quick and easy solution to tackle the common problem. I have a solution for you to consider without using the Premium Connectors....
Continue reading...