Share
ReportHi,
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
All responses (
Answers (
262
