Power Automate Convert SharePoint List or Excel Columns to a Single-Dimensional Array Using Power Automate
I couldn't quickly find a method to convert a table (object array) retrieved from SPO (SharePoint Online) or Excel into ...
Excel
Power Automate 
Power Automate Comparing Methods to Export Data from Power Automate to Excel: Office Scripts Recommended
I'm often asked about methods to export data from Power Automate to Excel, so here are my notes on this topic.What We Wa...
Power Automate Power Automate Best Practice: Using Office Scripts for Fast Excel Data Processing
I was asked to quickly retrieve large amounts of data from Excel, so I implemented a solution using Office Scripts.Perfo...
Power Automate The Ultimate Guide to Power Automate Excel’s ‘List Rows Present in a Table’: Delegation, Filters, and Row Limits
I was curious about the detailed behavior of the "List Rows Present in a Table" action that retrieves multiple data (row...
Power Automate How to Manipulate Excel Files in Microsoft Teams Private Channels with Power Automate
Since I received a question about how to manipulate files in private channels, I'm sharing these notes.What We Want to A...
Power Automate Complete Guide to Excel Sheet Operations in Power Automate: Add, Delete, Rename, Copy, and Move
I've been asked about detailed Excel operations frequently lately, so here are some notes.Office Script Office Script is...
Power Automate Complete Guide to Power Automate Excel Online (Business) Actions: How to Manipulate Excel Files in Flow
I needed to manipulate Excel files stored in SharePoint document libraries, so I researched the available Excel actions....
Power Apps How to turn Word, Excel and Power Point previews into Power Apps canvas apps.
I found this article interesting and tried it out.Advance preparationSave sample files in the SharePoint document librar...