I have an app that use a SQL to fetch some data from SQL and present it in the Power App, then based on this data will be filled some fields and then this will be inserted into the Sharepoint. Meaning that Sharepoint will act as a Database and SQL as a View in Power Apps.
Data comes from: SQL Table fields:
Data should be inserted/updated into: Sharepoint List:
Then we want to avoid using the SQL in Power Apps because this make the app premium. So in order to have this SQL view into Sharepoint we want to Import the data from SQL to Sharepoint in a daily baisis.
The intended workaround is (Power Automate):
I have some question here:
Thanks in advance!
Not sure, if there is a special need for using Sharepoint with SQL. Indeed both are databases and I don't foresee any advantage of using two of them. ( Except if you are storing any documents/files ).
Instead, you can have another table in sql and use it as you are using for SharePoint.
if you are using a SP list to update data along with attachments (Email/docs etc which Sharepoint lists can do), then Will suggest to use a library instead and get the Link . This you can store it in your SQL and use it.
Hope , I answer your query.
Please explain your requirement, if you still need some more clarification.
Hey @Abhilash_Swain thanks for your prompt response. I just updated my question with more details based on the scenario. I think there is all the context, but let me know if you want further information.
As you mentioned, SQL is a premium connector and you use SharePoint as an alternative to avoid the cost.
There is no harm in it using duplicate records at SQL and Sharepoint. It depends on your project design based on requirements and cost.
Your scenario falls under this example
Please give me a Thumbs up if I answered your question and mark it as a solution to help others.
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Join us for two optional days of workshops and a 3-day conference, you can choose from over 130 sessions in multiple tracks and 25 workshops.