List files in folder and then Get Tables

(0) Share

Report

Posted on by ALPetersen

I have a connector based on "FileSystem" which i am using to "List files in folder". This part works fine.

This action will find one or more Excel files on runtime.

For each Excel-file found, I would like PA to list tables in the Excel-file - but I can't figure out how the parameters of the "Get tables" action should be filled out. I mean - it is easy to find out how this should be done if the files were on a OneDrive location, but they are not. They are on an old-fashioned filedrive.

Any suggestions ?

Picture 1: an overview of my flow

Picture 2: the "Get tables" action, to which my problem is related

bb.jpg

aa.jpg

All responses (1)

Answers (1)

Verified answer

wskinnermctc 6,517 Super User 2025 Season 1 on at

Like (1)

Report

Re: List files in folder and then Get Tables

Get Tables will not work. The Excel Connector will not function outside of OneDrive or SharePoint. See the information about the Excel connector below.

https://learn.microsoft.com/en-us/connectors/excelonlinebusiness/

https://learn.microsoft.com/en-us/connectors/excelonline/