Loop through Excel files in sharepoint folder and import into SQL
I have a Sharepoint folder that a user will periodically add files into. the names will not always be the same and the number of files wont be the same. I am looping through the excel files - that works
I try to convert the contents of the file to a table. it works if i select the file name when building the flow but it wont work when i use a variable containing the path and file name of the excel file.
How do i get the Excel - 'Create table' action to work with a dynamic file name?
If this reply helped you to solve the issue, please mark the post as Accepted Solution. Marking this post as Accepted Solution, will help many other users to use this post to solve same or similar issue without re-posting the issue in the group. Saves a lot of time for everyone.