Skip to main content

Notifications

Announcements

Welcome to the Power Platform Communities
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate - Building Flows / One Button, 70 Files, ...
Power Automate - Building Flows
Answered

One Button, 70 Files, Dynamic Content?

(0) ShareShare
ReportReport
Posted on by Community Power Pla...

Hi! 

 

We have a team which manages data in 70 different files (one file per region). Each file is structured the same and stored in the same directory. What I want to do is add a button to each file which would perform the following action when clicked: 

 

Compose email to <dynamic input email from cell B2> with <text from cell b4> as the email body. 

 

I've explored forms but can't figure out how to embed the form. I've explored the http route but don't want to create 70 buttons - just one button that works for 70 different files. Help?

  • Community Power Platform Member Profile Picture
    Community Power Pla... on at
    Re: One Button, 70 Files, Dynamic Content?

    Thanks! It was worth a shot.

  • Verified answer
    AnthonyAmador Profile Picture
    AnthonyAmador 2,553 Super User 2025 Season 1 on at
    Re: One Button, 70 Files, Dynamic Content?

    Hi @Anonymous 

     

    You can use the "For a selected row" trigger from the Excel connector and retrieve the information from there, but you must create one flow per file as you have to select the file and table in the trigger. Now, I don't see a way to make a button that works for all the files without an input, because the flow must know which file to reference.  

     

    I was also thinking of a flow that loops through all the files and add a condition based on the name of the file, however as I said before you are going to need an initial input.

     

    Hope this helps. 

    Kind regards.

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

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

News and Announcements

Welcome to the Power Platform Communities

Quick Links

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June 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 > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 497 Super User 2025 Season 1

#2
David_MA Profile Picture

David_MA 436 Super User 2025 Season 1

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 244 Super User 2025 Season 1

Last month Overall leaderboard

Featured topics

Start and wait for an approval action

Product updates

Microsoft Power Platform Community release plans