Escaped characters in your forms response or json data sources can be easily formatted with a simple expression. \”answer\” will become “answer”.
Continue reading...Teams External Guest User Cannot Access Files
Invited an external guest to teams and they cannot access the files? Maybe you need a SharePoint admin to take a look? Let me show you where.
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...FormatDateTime and Formatting a String Date
You’ve got a date for your Power Automate from a source whether that be a list item, dataverse entity attribute or other source and you want to compare it against today’s date or a date in the past/future, what options are available to you to...
Continue reading...Perfectly complete an Excel Invoice Template
You will have probably used the Populate a Microsoft Word Template (Premium) action in Power Automate before but will be saddened to learn that Excel doesn’t offer the same functionality. Via Tables in Excel you can add and update rows in Excel but it can...
Continue reading...Want to SUM up a List of numbers?
It might suprise you to hear that there is not a SUM function in Power Automate, if you wish to add a list of numbers you must use a variable to store the running total of a sum via apply to each using the add...
Continue reading...Magic Efficient – CSV to JSON
Looking to convert a CSV to JSON in Power Automate and do this efficiently? You’re in luck. This is by far the best method without using an Apply to Each!
Continue reading...