Should CRUD operations on a simple SQL list be done in SharePoint Lists or in PowerApps ?

%3CLINGO-SUB%20id%3D%22lingo-sub-301035%22%20slang%3D%22en-US%22%3EShould%20CRUD%20operations%20on%20a%20simple%20SQL%20list%20be%20done%20in%20SharePoint%20Lists%20or%20in%20PowerApps%20%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-301035%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20list%20of%20about%20500%20items%20in%20a%20single%20table%20in%20SQL.%20We%20manually%20change%20the%20SQL%20list%20now%20within%20SQL.%20But%20what%20would%20be%20best%20now%20that%20we%20have%20Office%20365%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20it%20best%20to%20use%20an%20EXTERNAL%20CONNECTION%20with%20a%20sharepoint%20list%20to%20edit%20%3F%26nbsp%3B%20OR%20create%20a%20power%20apps%20and%20connect%20that%20to%20SQL%20%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20SharePoint%20route%20seems%20more%20difficult%20to%20set%20up%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-301035%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-301549%22%20slang%3D%22en-US%22%3ERe%3A%20Should%20CRUD%20operations%20on%20a%20simple%20SQL%20list%20be%20done%20in%20SharePoint%20Lists%20or%20in%20PowerApps%20%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-301549%22%20slang%3D%22en-US%22%3E%3CP%3EIt%20in%20on%20prem%20but%20we%20would%20connect%20through%20the%20gateway%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-301137%22%20slang%3D%22en-US%22%3ERe%3A%20Should%20CRUD%20operations%20on%20a%20simple%20SQL%20list%20be%20done%20in%20SharePoint%20Lists%20or%20in%20PowerApps%20%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-301137%22%20slang%3D%22en-US%22%3EDepends%20if%20your%20sql%20is%20azure%20sql%20or%20onprem%20SQL%3F%3C%2FLINGO-BODY%3E
Highlighted
Deleted
Not applicable

I have a list of about 500 items in a single table in SQL. We manually change the SQL list now within SQL. But what would be best now that we have Office 365?

 

Is it best to use an EXTERNAL CONNECTION with a sharepoint list to edit ?  OR create a power apps and connect that to SQL ?

 

The SharePoint route seems more difficult to set up 

2 Replies
Highlighted
Depends if your sql is azure sql or onprem SQL?
Highlighted

It in on prem but we would connect through the gateway