Skip to main content

Notifications

Power Automate - Building Flows
Answered

Listing multiple excel files in folder from one drive for business to update the data in share point list

(0) ShareShare
ReportReport
Posted on by 75

Hello, 

 

I have created the workflow to read a single file from OneDrive for business and update the data in Share Point list.

I am enhancing the same to read multiple files from the same folder of one drive (All file with same structure and columns , only the data is different). 

 

So added the below steps in my flow to do the same, But it fails when listing the files in the folder. Can you please advise what I am doing wrong here. 

 

It throws an error "No table was found with the name 'Table1'. But the table is present in the file its reading. And there is only one file in the folder now for testing. The loop fails in very first iteration itself.

 

Note : When I read the same file directly without list files in folder steps- it works perfect and Table1 is recognized in the flow . 

 

Sivaperumal31_0-1677460507782.png

 

 

Thank you.

  • Sivaperumal31 Profile Picture
    Sivaperumal31 75 on at
    Re: Listing multiple excel files in folder from one drive for business to update the data in share point list

    HI @v-liwei-msft , 

    Duly Noted, Thanks for letting me know the etiquette of seeking help from the community. If I am unable to figure it out on my own , I will start the fresh topic for new issue.

     

    Appreciate your previous response which helped me solved the problem. Marked it as solution.

     

    Thank you. 

  • v-liwei-msft Profile Picture
    v-liwei-msft on at
    Re: Listing multiple excel files in folder from one drive for business to update the data in share point list

    Hi @Sivaperumal31 

      

    We really understand that you have more than one issue need to be solved today and we are surely happy to help you with those, but to better focus on the new problem and ensure the service quality, we would advise you to create another ticket on the issue.

    It can also help us to get the case better recorded and let Microsoft know what you have been through clearly. Thank you so much for your understanding. 

     

    Best Regards,

    Levi

     

  • Sivaperumal31 Profile Picture
    Sivaperumal31 75 on at
    Re: Listing multiple excel files in folder from one drive for business to update the data in share point list

    Thank you @v-liwei-msft , That did the magic. 

     

    Can I also ask another question?

    How Can I mark the file if its already read and updated in share point list, So that it wont be picked up later when I run the flow again after adding the new file in folder?  

     

    In case of SharePoint library, I shall add the column for updating the status of file and control the flow to pick up only the new files based on status, I am not sure how I can do the same for files in OneDrive for business.

  • Verified answer
    v-liwei-msft Profile Picture
    v-liwei-msft on at
    Re: Listing multiple excel files in folder from one drive for business to update the data in share point list

    Hi @Sivaperumal31 

     

    Please try dynamic content id instead of Path:

    vliweimsft_0-1677464861777.png

     

    Best Regards,

    Levi

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,445

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,741

Leaderboard