Skip to main content

Notifications

Power Automate - Using Connectors
Answered

Connecting SQL Server with Microsoft Form

(0) ShareShare
ReportReport
Posted on by

Hi,

 

I'm in middle to research how connecting SQL Server with Microsoft Form, because if we build application from scratch we don't have time yet. This is small project but still have powerful impact in our internal project. 

 

We have a data contain id, name, address, and status. "status" field in our table is flag with desc if 1 is registered and 0 is unregistered.

 

We provide this data from our pool data, so this is mean we collect the data with manual practice. We transfer to excel. In the middle of our research, we want this data transfer to SQL Server and build flow to connect with Microsoft Form. We want create registration for those eligible person who exist in our data as long as their "status" is 0. Basically We want fetch personal data from our data transfer. So the person is legal when take registration.

 

In our flow, we want create group registration form with max 3 field name, this is mandatory. And after they completed submit data for registration, Microsoft Form will trigger to update "status" flag in SQL Server from 0 to 1. This mean, when 1 person submitted, they not eligible to take again registration.

 

This is possible? please help

  • Verified answer
    v-litu-msft Profile Picture
    v-litu-msft on at
    Re: Connecting SQL Server with Microsoft Form

    Hi @agnanzakariya,

     

    You could create a Flow with a trigger "When a new response is submitted", then use the Filter query in Get rows action of SQL connector, ID eq 'dynamic content get from Form'. It will return an array of rows if it found the ID, then use Condition action to determine the status whether it equals '0', if it is, updates or add a row into SQL, or send a notification to user registration failed.Annotation 2020-05-28 102612.jpg

     

    Best Regards,
    Community Support Team _ Lin Tu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,636

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,942

Leaderboard

Featured topics