This tutorial describes the “For a selected row” action in Power Automate.

It can very easily start a flow and work in it, using data from the line it was started from.

What to set in Power Automate

A file and a table must be defined:

And then define what happens with the information from row. In this case, it fills the body of the email, using, for example, html (but it can really be whatewer Power Automate can do…).

What to set in Excel

In Excel (it can be online or classic desktop Excel) you just turn on the automation panel and start the flow. It will work with the row you you selected. If you have multiple rows selected, it will run for all of them.

The result (for example email generated from Excel row) can be like this: