"A" colleague name is storing the table when X is colleague is responding to email

[Powersuite]

My flow sends an email to the list of credit card users with yes and no options. It is working fine and the users are able to click yes or no.

The email has to be sent on behalf of "A" colleague, so I made him as connection and he is in list of credit card users email list so the flow sends him an email but he ignores it because he has no card and his response is not required.

I have created a excel table and storing the yes/no answer there. Now my problem is someone's response is storing with that "A" colleague name. I have checked with him, he is not responding to the automated email.

How to check who is responding because "A" colleague name is storing the table when X is colleague is responding, Any ideas/ thoughts on how to fix this?

Thanks,

[hongdet]

Hi @Powersuite ,

It really depends how the table are getting updated. The "update a row" action should have a Key Column and Value to be matched before it can be updated. 

So the question now is, what is the Key Column and Value you have selected?

By providing a screenshot of your current flow would help us to understand and better assist. 

BR,
hongdet

_________________________________________________________

If I have answered your question, please mark your post as SOLVED.

Solved questions helps users in the future who may have the same issue or question quickly find a resolution via search.

If you liked my response, please consider giving it a THUMBS UP. Thank you!

[Powersuite]

Thanks for your reply. Please see the attached screenshot

When the response is submitted by user it stores the result in the table

How to check who is responding because "A" colleague name is storing the table when X is colleague is responding.

Thanks,

[hongdet]

Hi @Powersuite, 

Your flow is showing how row are being added. Do you mind showing the part where it's actually updating the row?

I'm assuming you might not have a Key Value (or unique value) for the flow to locate the actual record that you would like it to update. 

BR,
hongdet

_________________________________________________________

If I have answered your question, please mark your post as SOLVED.

Solved questions helps users in the future who may have the same issue or question quickly find a resolution via search.

If you liked my response, please consider giving it a THUMBS UP. Thank you!

[hongdet]

Hi @Powersuite, 

Your flow is showing how row are being added. Do you mind showing the part where it's actually updating the row?

I'm assuming you might not have a Key Value (or unique value) for the flow to locate the actual record that you would like it to update. 

BR,
hongdet

_________________________________________________________

If I have answered your question, please mark your post as SOLVED.

Solved questions helps users in the future who may have the same issue or question quickly find a resolution via search.

If you liked my response, please consider giving it a THUMBS UP. Thank you!

[Powersuite]

Please ignore the connection error, this flow sends on behalf of "A" colleague, will fix the connection.

[v-liwei-msft · Accepted solution]

Hi @Powersuite 

You should select the email address returned by Send email with options in the response from of add a row into a table instead of the user displayname in SharePoint. 

If you want to add a name instead of an email, you can use Search for users (V2) and enter the email returned by Send email with options to get the name.

Best Regards,

Levi