Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Automate - Building Flows
Answered

go trough the table in all excell files

(0) ShareShare
ReportReport
Posted on by

Hi,

 

I had this flow that sends an email based on the table of an excel file. Is there a way to cicle trough all the files in the folder?

Let's say i have 3 files but with different emails, can i loop trough each one, retrieve email adress and send the email?

 

Thanks

 

mnog_0-1669634978141.png

 

  • MN-24070630-0 Profile Picture
    on at
    Re: go trough the table in all excell files

    Thanks! Works fine.

  • Verified answer
    v-liwei-msft Profile Picture
    on at
    Re: go trough the table in all excell files

    Hi @mnog 

    Could you please tell me:

    Are email addresses saved in every sheet in every excel file?
    Do you want to iterate over all files and get the mails in the table?
    You have to make sure that the tables have the same name in these files (so you can manually enter the table name in List row present in a table)
    Make sure the tables have the same structure (e.g. mail columns must have the same column names)
    I made a test for your reference:

    vliweimsft_0-1669688383768.png

    vliweimsft_1-1669688398831.png

     

    vliweimsft_2-1669688410091.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

Michael Gernaey – Community Spotlight

We are honored to recognize Michael Gernaey as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard >