Unanswered

MS Forms to SQL DB to Email Help

(0) Share

Report

Posted on by fromdecember

I'm trying to think through a possible idea and see what is possible. I would like to create a flow that takes inputs from MS Forms, sends an email to confirm the information, write a entry to Azure DevOps with due date, write a new entry into a SQL DB, then if possible which I don't think it is, send an email on the due date or when the SQL DB has been changed.

The idea is for leasing products for a specific time and for notifications to take place, as well as entries in DevOps and a DB for records sake.

I have done MS Forms to DevOps with an email before, as well as MS Forms to a SQL DB (using a gateway, but I can't remember how to set it up).

Any tips or help or what's possible?

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (0)

RobElliott 10,323 Super User 2025 Season 2 on at

Like (0)

Report

@fromdecember "send an email on the due date or when the SQL DB has been changed" - that would need to be 2 separate flows.

Rob
Los Gallardos
Principal Consultant, SharePoint, Forms and Power Platform, WSP Global (and classic 1967 Morris Traveller driver)

Was this reply helpful? Yes No
fromdecember 2 on at

Like (0)

Report

If it's possible to send an email on the due date, I'd prefer just doing that one and letting the DB just be there to keep records as to when the form was submitted and when the date will expire. How would the flow look to send an automatic email on the "due date"?

Was this reply helpful? Yes No