That O365 Guru from Cape Town (#NadirKamdar)

Excel Office Scripts allow you to automate and format Excel workbooks through code, similar to macros, but designed for the cloud. In this step-by-step guide, we’ll start from the basics of creating and recording an Office Script, then integrate scripts with Power Automate to generate a well-designed Excel document stored in SharePoint. By the end, you’ll know how to go from a simple recorded script to an advanced workflow that creates dynamic Excel reports with ease. What are Office Scripts and Why Use Them? Office Scripts in Excel are a powerful automation feature that let you record or write scripts (in TypeScript/JavaScript) to perform repetitive tasks. They operate much like traditional Excel macros, but work in the cloud (Excel for Web and modern Excel desktop):contentReference[oaicite:0]{index=0}. This means your Excel files can live in SharePoint or OneDrive and still run automated scripts, enabling new scenarios that VBA macros (which only run in desktop Excel) cannot:conten...

Why Consider SVG in PowerApps? SVG (Scalable Vector Graphics) images offer several advantages over standard image formats like PNG or JPEG, making them ideal for PowerApps: Infinite Scalability: SVGs are vector-based, so they remain crisp at any size. You can resize an icon or graphic without any loss of quality – no more blurry images on high-resolution displays [1] . This is perfect for apps that need to look good on everything from phones to large monitors. Small File Sizes: SVGs are essentially XML instructions for drawing shapes, not pixel-by-pixel data. This typically leads to smaller file sizes and faster load times compared to bitmap images [2] . A lighter app means better performance for your users. Transparency and Styling: SVG supports transparent backgrounds (unlike JPEG) [3] , so your icons can blend seamlessly with any theme or color. Moreover, because SVGs are code, you can edit their colors or shapes via ...