posts
Using OpenAI in Excel and Google Sheets
Using OpenAI in Excel and Google Sheets Integrating OpenAI’s GPT models into Excel or Google Sheets can unlock powerful automation and language processing capabilities. This blog post demonstrates how to use OpenAI’s API to translate text in a spreadsheet cell into French using a script.
Google Spreadsheet Apps Script Example The following script uses OpenAI’s GPT-3.5-turbo model to translate the content of a selected cell into French and outputs the result in the adjacent cell.
posts
Converting to Modern YAML Pipeline: Application Lifecycle Management in Azure DevOps for Power Platform
Converting to Modern YAML Pipeline: Application Lifecycle Management in Azure DevOps for Power Platform There are loads of posts explaining Application Lifecycle Management for the Power Platform using Azure DevOps most using the graphical classical pipeline. The latest post I read on this is Application Lifecycle Management for the Power Platform using Azure DevOps by Luise Freese which is brilliant.
Please read article covering difference between YAML and Classic UI to explain why you may want the modern YAML pipeline.
posts
Working with psm1 Files in PowerShell
Working with PowerShell Script Module Files:psm1 Have you ever utilized a psm1 file to create reusable functions across multiple ps1 files? If so, you might have encountered the frustration of edits not reflecting immediately due to module caching.
I recently faced this issue when updating a psm1 file; despite making changes, the updates didn’t take effect immediately. The issue stemmed from module caching.
The only solution I found to load the updated psm1 file was to terminate the PowerShell session and start a new one.