cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
bigczee
Level: Powered On

Excel - Get Rows has been removed? What's the alternative?

I have a Flow that I've been using for a couple of months but it recently had an issue with the trigger so I was going to rebuild it.

 

The original flow uses 'get rows' from excel after a file is created in a sharepoint library.  When I go to recreate the flow, 'get rows' is now not listed as an option.  The only options I see are excel for business and excel for one drive.  i believe before I just used excel.

 

When I select excel for business the only options for rows that I see are:

Get a row

List rows present in a table

Update  a row

Add a row to a table

 

Is 'Get a row' the same as 'get rows'?  For get row i have to add a key column and key value, rather than just getting the hwole table.  Does 'list rows present in a table' have similar functionality to 'get rows'?

 

why is 'get rows' gone?  major bummer.

 

 

4 REPLIES 4
Highlighted
Community Support Team
Community Support Team

Re: Excel - Get Rows has been removed? What's the alternative?

Hi @bigczee ,

 

Yes, Excel connector has been filtered out and we are no longer possible to use some of the actions it contained before, like Get Rows, Insert row.

Please use Excel Online connector instead, List rows present in a table action with the same feature as Get Rows action.

 

Also for Excel online connector, if Excel file is stored in OneDrive for Business or SharePoint Library, please use Excel Online (Business). If Excel file is stored in OneDrive for Personal, please use Excel Online (OneDrive).

Please take a try.

 

Best Regards,

Community Support Team _ Barry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
bigczee
Level: Powered On

Re: Excel - Get Rows has been removed? What's the alternative?

thanks for the response!  i can't get 'list rows present in a table' to be dynamic - is this possible?

 

When an excel file is saved in onedrive, i'm having Flow grab a table in the workbook (always table1).  however, the name of the file is a time stamp so the filename is always different.  can list rows handle this?

 

the get rows functionality seemed to be a lot more straightforward and work better - it's a bummer that it has disappeared.  

Community Support Team
Community Support Team

Re: Excel - Get Rows has been removed? What's the alternative?

Hi @bigczee ,

 

I did a test on my side, we could click Enter custom value to configure Table field, but the same method is unable to configure File field.

If we manually enter a file path or use Dynamic content to configure File field, it cannot get the specified file.

Currently we can only select the specified Excel File through File Browse.

 

If you want similar feature to be supported by MS Flow, please consider voting for a similar idea:

https://powerusers.microsoft.com/t5/Flow-Ideas/Dynamic-content-in-File-amp-Table-inputs-Excel-Busine...

 

Best Regards,

Community Support Team _ Barry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Amisoft
Level: Powered On

Re: Excel - Get Rows has been removed? What's the alternative?

Hi, the  same functionality can be achived using "List rows present in a table" (don't forget to format as a table data contained on Excel by selecting data then pressing Ctrl+T)

 

ListRows.JPG

Helpful resources

Announcements
firstImage

New Ranks and Rank Icons in April

Read the announcement for more information!

firstImage

Better Together Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Community Summit North America

The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors
Users online (8,415)