cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Splaterpea79
Regular Visitor

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?

1 REPLY 1
rsaikrishna
Dual Super User
Dual Super User

@Splaterpea79 

 

Check this blog on reading Excel file name dynamically:

https://manueltgomes.com/microsoft/powerautomate/how-to-access-dynamic-path-excel/

 

I hope this will help you.

 

Regards

Krishna Rachakonda

If this reply helped you to solve the issue, please mark the post as Accepted SolutionMarking 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.

Helpful resources

Announcements
Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

User Group Leader Meeting January 768x460.png

Calling all User Group Leaders!

Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.

Top Solution Authors
Top Kudoed Authors
Users online (1,594)