Advice Needed: Enhancing Data Verification System with User-Friendly Interface and Database Integration
I’m currently working on improving our system for verifying and updating physician and clinic information in our database. Currently, our workflow involves the following steps:
- Data Entry via MS Forms: We fill out physician info via MS Forms and submit their details.
- Automation with Power Automate: Submissions trigger a Power Automate flow that updates our SQL Server database and emails our leadership team about new or updated entries.
- Approval and Processing: Updates are then processed and, if necessary, go through an approval process via MS Approvals.
While this system works for data entry, it's not proactive in maintaining up-to-date information. We send out empty forms that physicians fill from scratch, which is time-consuming and not user-friendly.
What I Want to Achieve:
- Pre-filled Data Forms: Allow physicians to select their names from a list, view the information we currently hold in a user-friendly format, and make updates as needed.
- Seamless Updates and Notifications: If updates are made, these should trigger a Power Automate flow to email and notify our leadership team, possibly go through an approval process (like MS Approvals), and subsequently update the SQL database record.
The Challenge:
- We have a tool for data entry (MS Forms) but lack a straightforward method or workflow to retrieve and display current information from the database for user verification and updates.
Questions for the Community:
- Has anyone implemented a similar system that integrates data retrieval with user updates in a user-friendly interface?
- What tools or platforms would you recommend that can seamlessly integrate with SQL Server and Power Automate for such a functionality?
I'm looking for any advice, tool recommendations, or insights that could help streamline this process and make it more efficient. Thank you in advance for your help!