Unanswered

Power apps and using the cloud for data source

(0) Share

Report

Posted on by zajacjos

120

Is Microsoft Azure the only server to use for a data(Such as for part numbers, quantity, manufacturer) for power apps? I have an inventory app with information that gets stored on a physical server. My boss wants me to move the server to the cloud and I have to get some quotes on pricing but was not sure if power apps lets you use the other cloud servers

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Sort by

mmollet 3,187 on at

Like (0)

Report
Copy link

Link copied!

You can use many different methods via Power Apps from an excel document in onedrive/sharepoint to a sharepoint lists to an SQL Server. The thing that will make the difference is how big is your data and do you want to spend money on the solution or do it for free. SharePoint is a great starting point to see if you like it. SQL Server is a premium connector so will cost to use.

SQL Connector
Other Cloud Storage
SharePoint

Was this reply helpful? Yes No
zajacjos 120 on at

Like (0)

Report
Copy link

Link copied!

We were previously using a free developer version of SQL do you know something that can replace that can generate reports?

Was this reply helpful? Yes No
mmollet 3,187 on at

Like (0)

Report
Copy link

Link copied!

I mostly use SP for data storage as I have relatively small applications for small companies. That being said I do know you can use the power platform (power bi specifically) to generate reports and graphs etc.

Power Automate can automate emails and messages etc using flows. This can talk to your SP list or your SQL server etc and pull data, manipulate it, and save it after changes. This can also send emails, create files, and so much more.
Power BI can be used to create very colorful and aesthetic graphs and reports.

There are loads of how to videos that are easy to follow on youtube as well!

Sorry I dont have a more direct answer for you! Maybe someone else can step in if they have a better one!

Was this reply helpful? Yes No