SQL Server to SQL Server Flow

[ToddAtLSUHSC]

At my company, our asset tracking team sends out a Word doc to each computer user that contains a computer model and serial number. If that computer is in the possession of the user, the employee indicates that it is in their possession, signs the document and sends it back to the coordinator. If it is not, the employee indicates that it is not in their possession.

We would like for the response and updates to be autmated via Flow if possible. It does not necessarily need to create a Word doc. The body of an email would suffice.

The preliminary data is loaded to a SQL Server table, and I am able to create emails based on this data. The tricky part is how do I (if it is possible) create yes/no buttons or links that would update the database depending on which one chosen. If I do a "send email with options", you can only send a maximum of 50 emails at a time ( in parallel I think is the proper term) We have 2000+ assets to  track, so this would not be very effective.

Any advice or help would be appreciated.

Thanks!

[v-zhos-msft]

Hi @ToddAtLSUHSC ,

Sorry I can't understand your scenario clearly.

You send emails to the users based on the data in a SQL Server table.

Then you want to update the SQL Server table with the response from the users, right?

Could you please share an example of the response?

The response is a table or just string text in the email body?

Which field of the SQL Server table do you want to update?

I think we need more details to help you.

Best Regards,

Community Support Team _ Zhongys

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[sergeluca]

Probably the best option is to create an approval flow. The flow sends an approval to the user  with the question : "do you own the computer" <approve><reject>

If the user click "approve" then the document./email will be sent to the user

KInd regards

Serge Luca aka "Doctor Flow"