i Hope everyone is aware of excel actions available in power automate desktop and how to access the excel files using them. But we know using the actions default actions, we have to use a number of various actions for performing operations like filtering, searching, updating etc… And this affects the performance of automation (for time conscious peoples ;) only )
But, if we are using the excel as a database, we can execute SQL queries on excel data and perform operations easily.
To learn how, check the video below
Hope this helps.
Happy Automation