Unanswered

One Button, 70 Files, Dynamic Content?

(0) Share

Report

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?

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

AnthonyAmador 2,553 Moderator on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Thanks! It was worth a shot.

Was this reply helpful? Yes No