Hi, I'm using Flow to get an Excel SS from a SP library. I have a table in the SS entitled Master and I want to get that data and push it to a SP list. I can get the flow to find the SS in the library and I can the file Meta Data, When I use the file name or ID I get
I dont know if you are aware of, but in the latest deployments, MS Flow team made available the Excel (Business) action library, which includes a function called "List Rows Present in table" or something like that. Thats the action you want to use for reading excel files from a SharePoint document library.