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...
Continue reading...DamoBird365
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...
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...
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...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...
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...
Continue reading...