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
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.
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.