Hi,
I am trying to extract email addresses from an Excel sheet in order to send an email to that address. However I can't figure out what to enter in Key Value. The value changes every time a new row is added (from MS Forms). I keep getting the error: No row was found with Id (and then the value I enter).
Anyone has an idea to solve this?
Ok, the reason that it creates a for each is that the result is an array with many rows. The way to stop this is to specify which record you want to return by using an index number [0] eg
Hi @MP-68 ,
Please try this.
Step1.Recreate the Send email action.
Step2.Insert below expression in "To" field.
last(outputs('List_rows_present_in_a_table')?['body/value'])?['EmailColumnName']
——————————————————————————————————————————————————
If my answer helps you solve the problem, please accept it as a solution.
Best regards,
Rimmon
Thank you - this works much better. 🙂 However, when I add the action "Send an email", PA automatically creates a "for each" loop - I only want the last row to be read - and only one email sent.
Any ideas?
Hi @MP-68 ,
"Get a row" is used to get specific row according to key value. If you want to send emails to each email address in Email column, you try "list rows present in a table". Then you can select Email column dynamic content in "To" field of "Send email action".
Best regards,
Rimmon
list rows present in a table
This is what my flow looks like and the options I have.
Looks like you might want to rather use the Get rows action as this will return all the rows, for the connector that you are using you are targeting a specific row in your table where the key is the unique identifier.
Hi @MP-68 ,
The key value should be a specific value in a column. The column has different values, so we take the column as key column.
So, you should fill in an email address here to locate a row in the email address column based on this value.
Best regards,
Rimmon
ankit_singhal
5
Super User 2025 Season 1
Michael E. Gernaey
4
Super User 2025 Season 1
David_MA
2
Super User 2025 Season 1