It’s the same approach in both situations when you need multiple filters, no matter if it’s only ore or more rows. It can be a single filter, or multiple filters, as many as you need.

The main filter in the ‘List rows…’, the others in the ‘Filter array’. That means adding the ‘Filter array’ action to filter the rows further.

Since the ‘List rows…’ action supports only one filter, you must add the other filters later. Get one or more rows using multiple filters

But it won’t fail if there’re no rows fitting the condition. It won’t be enough if there’re multiple filters involved.Īlso, as mentioned before, you can’t use column names with spaces in the Filter Query. to skip empty rows or import only some tasks to Planner. It’s fine if you want to filter by a single column, e.g. Unfortunately, this Filter Query supports only a single filter. The supported filters are ‘eq’, ‘ne’, ‘contains’, ‘startswith’ and ‘endswith’. This action won’t only return multiple rows, but you can also use more complex filters than just ‘eq’. If you want to get multiple rows, you must use the ‘List rows present in a table’ action. On the other side, if there isn’t any row that fits the filter, the action will fail! Get multiple rows using a single filter This is something the ‘List rows…’ action won’t accept. Column eq 'Value'Īs you can see in the example, if you work with ‘Get a row’, the column name can contain spaces. The operator is always ‘eq’ (is equal to). You can imagine the ‘Key Column’ as the left side of the filter, and the ‘Key Value’ as the right side. But it is a Filter Query, only looking a bit different. Instead of the Filter Query it has the ‘Key Column’ and ‘Key Value’ fields. Get a single row using a single filterĪs already mentioned, if you’re looking for a single row, you can use the ‘Get a row’ action. If you need to add the table I recommend Damien’s article. Note: the data in your Excel file must be in a table, otherwise you can’t process it with Power Automate. How do you then get the desired row(s) using these actions? Similarly, the ‘List rows…’ action won’t allow you to use multiple filters either, even though it can return multiple rows. It has ‘Key Column’ and ‘Key Value’ fields, which allow only one filter and might be a bit confusing.

While the ‘List rows…’ looks similar to the SharePoint ‘Get items’ action, ‘Get a row’ filter looks a bit different. But each of the actions has its limitations. You can get a single row with the ‘Get a row’ action, or you can get more of them using the ‘List rows present in a table’. Power Automate gives you two options how to extract data from an Excel file. “Should I use ‘Get a row’ or ‘List rows present in a table’ to get a specific row from Excel in my Power Automate flow? I can’t get neither of them to work!”

Excel how many rows in a table