The “Get rows” action in Power Automate is used to retrieve a set of rows from a table in a specific database. This action can be used with various data sources that Power Automate supports, such as Excel, SharePoint, SQL Server, and more.

When you use the “Get rows” action, you provide the name of the table from which you want to retrieve the rows. You can also specify filter queries to limit the rows that are returned based on certain criteria.

For example, if you’re working with an Excel spreadsheet, you can use the “Get rows” action to retrieve all rows from a particular worksheet. If you’re working with a SQL Server database, you can use the “Get rows” action to retrieve all rows from a specific table.