MS Forms to Azure MySQL DB

Question

Hi

Hopefully someone can help?

We are building an intranet using SharePoint and some bespoke .net dev work; which is to include an internal training section for staff. Within the training section, staff will be able to self-serve by watching videos and taking tests etc.

Before building this section, we are investigating the best methods to produce the tests, and MS Forms came up as a valid solution for creating the quizzes, but it's getting the data back to the Azure MySQL DB where I need some help/ advice. Ideally, we would like to take the results from ms forms and dump them in a MySQL DB, for them be used in a dashboard created in .net.

I've seen that you can use the MS Power Automate apps (flow) and this also seems like a valid solution too. My question is, as the ms Forms flow is free, but the SQL apps are premium, can you use a per-user plan to run flows or would we need to use the per-flow plan?

The training section is predominately for new recruits and some annual compliance tests, so I'm not sure if the per-flow plan is overkill? Or if using the per-user plan is actually a license option for what we want to achieve?

Thanks in advance for your help.

Thanks

Philip

Answer 1

Hi, @Phil German Welcome to the Microsoft Q&A Platform, and thanks for your query.
Your ask seems to be about pricing for Power automate https://powerautomate.microsoft.com/en-us/pricing/

With related MySQL part in the question, today you can store and pull the data from a power app flow into on premise MySQL database only. We are working on a connector for Power Apps that works with Azure DB for MySQL Flexible Server, but this is planned for a future release. Once the connector is available users can connect to the Azure MySQL database and perform all data operations required by the app.

Please let me know if you have any additional questions.

Regards
Geetha

Please don't forget to click on or upvote button whenever the information provided helps you. Original posters help the community find answers faster by identifying the correct answer.

Answer 2

Thanks @GeethaThatipatri-MSFT