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.
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.
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.
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:
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)
Features releasing from October 2020 through March 2021
We are excited to announce the launch of Power Virtual Agents Community. Check it out now!
We've updated and improved the layout and uploading format of the Power Automate Cookbook!
Fill out a quick form to claim your user group badge now!