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: Name Surname DNI
Data should be inserted/updated into: Sharepoint List: Name (from SQL)Surname (from SQL) DNI (from SQL) Street (data filled in powerapp) Phone number (data filled in powerapp) Email (data filled in powerapp)
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):
Daily data import from SQL to SharepointList this data from Power Apps instead of using SQL making the Power App free
I have some question here:
Is good to have the data replicated in SQL and in Sharepoint?Is this a clean approach?