Unanswered

SharePoint List button - When clicked send certain fields in an email for only that selected row. Getting all data instead.

(0) Share

Report

Posted on by hutchison_it

Hi all,

I'm pretty new to Power automate. I have a SharePoint list and added a button to run a Flow which should email specific fields from the row (which button was click) and have it sent in an email

I have it partially working, and my problem is all SharePoint list rows data is being emailed, instead of only the row which had it's button clicked.

I've got the button created in SharePoint and my test Flow is specified in the conditional formatting for button JSON

This is what my Flow currently looks like.

When the SharePoint list button is pressed the Flow runs and i'm sent the email with all row data instead of just the one clicked.

Can anyone suggest what might be wrong?

Thanks.

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

ManishSolanki 15,091 Super User 2025 Season 2 on at

Like (0)

Report
Hi @hutchison_it

Use filter query to fetch the selected item as shown below:

ID eq @{triggerBody()?['entity']?['ID']}

just copy & paste above filter query in the get items action.

If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.

Was this reply helpful? Yes No
hutchison_it 9 on at

Like (0)

Report

Hi @ManishSolanki,

Thank you very much for the quick response and I will report back tonight once tested.

Also, another question if i can. I've heard that it's possible to use a "trigger" on the way the flow is executed so in the SharePoint list when the button is clicked you don't have to go through the multiple steps to "run the flow" on the SharePoint page.

Do you know how this can be accomplished on my example here?

Was this reply helpful? Yes No