Power Automate has some cool out-of-the-box features to read data from Excel files. But if you want to read this data using these actions, the data needs to be formatted as an actual table in the file and not a flat range – but don’t you worry, Office Scripts got you covered! With Office scripts …
Suppose we have a table with a measure such as Sum of sales amount, and we would like to give the user the ability to change the way the amounts are shown, using a slicer. The blue slicer in above example allows the user to change the Sum of sales amounts to be displayed as: …
Create a slicer to change amounts to millions & thousands Read More »
Use an excel table to modify your SQL query If you regularly run queries to any database in your workplace, chances are you have encountered a user request like this: We can use Excel to query the database and get the information requested, but you will have to manually write the WHERE conditions that include …
When we connect to a folder to combine all the files, Power Query creates a “Query” called “Sample File”, which is used as example to process each file, the results will depend on the columns that exist in this file. But what happens when any of the files have less columns than others? In the …
Combining files with Power Query is great but what happens when some unformatted files have less columns?
We wanted to post a small entry about this topic and explain in a very quick way, terms that may be new to some of the daily excel users.
