Sharepoint & SQL conection

%3CLINGO-SUB%20id%3D%22lingo-sub-1445748%22%20slang%3D%22en-US%22%3ESharepoint%20%26amp%3B%20SQL%20conection%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1445748%22%20slang%3D%22en-US%22%3EHello%20everyone%2C%3CBR%20%2F%3E%3CBR%20%2F%3EDoes%20anybody%20know%20how%20to%20connect%20Sharepoint%20to%20SQL%3F.%20I%20need%20to%20create%20a%20Sharepoint%20form%20to%20register%20selling%20information%20and%20then%20read%2C%20follow%20and%20modify%20it%20in%20SQL%20Server.%3CBR%20%2F%3E%3CBR%20%2F%3EUsually%20I%20use%20Visual%20Studio%20to%20connect%20SQL%20databases%20with%20external%20data%20sources%2C%20but%20I%20dont%20Know%20which%20data%20source%20connection%20I%20must%20use%20and%20where%20I%20can%20get%20the%20connection%20parameters%20from%20Sharepoint.%3CBR%20%2F%3E%3CBR%20%2F%3EPlease%20I%20would%20appreciate%20your%20help!%3CBR%20%2F%3E%3CBR%20%2F%3EThanks!%3CBR%20%2F%3E%3CBR%20%2F%3EBest%20regards%3CBR%20%2F%3EFabricio%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1445748%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ESharePoint%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESQL%202019%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1445764%22%20slang%3D%22en-US%22%3ERe%3A%20Sharepoint%20%26amp%3B%20SQL%20conection%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1445764%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F691213%22%20target%3D%22_blank%22%3E%40Fabricio1081%3C%2FA%3E%26nbsp%3BThere%20are%20SQL%20Server%20triggers%20and%20actions%20in%20Power%20Automate.%20So%20when%20an%20item%20is%20created%20in%20a%20SharePoint%20list%20it%20can%20insert%20a%20row%20into%20SQL%20Server.%20It%20is%20a%20premium%20connector%20though%20so%20will%20cost%20something.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20image-alt%3D%22sqlActions.png%22%20style%3D%22width%3A%20573px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F197044iB4048A705DA62A5F%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22sqlActions.png%22%20alt%3D%22sqlActions.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERob%3CBR%20%2F%3ELos%20Gallardos%3CBR%20%2F%3E%3CFONT%20size%3D%222%22%20color%3D%22%23333399%22%3EMicrosoft%20Power%20Automate%20Community%20Super%20User%3C%2FFONT%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1445798%22%20slang%3D%22en-US%22%3ERe%3A%20Sharepoint%20%26amp%3B%20SQL%20conection%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1445798%22%20slang%3D%22en-US%22%3EThanks%20Rob%2C%3CBR%20%2F%3E%3CBR%20%2F%3EIs%20there%20any%20free%20feature%3F%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1446797%22%20slang%3D%22en-US%22%3ERe%3A%20Sharepoint%20%26amp%3B%20SQL%20conection%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1446797%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F691213%22%20target%3D%22_blank%22%3E%40Fabricio1081%3C%2FA%3E%26nbsp%3Bthere's%20no%20free%20SQL%20connector%20in%20Power%20Automate.%20There%20might%20be%20other%20ways%20to%20do%20what%20you%20want%20but%20I'm%20afraid%20I'm%20not%20the%20one%20to%20give%20you%20an%20answer%20on%20that.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERob%3CBR%20%2F%3ELos%20Gallardos%3CBR%20%2F%3E%3CFONT%20size%3D%222%22%20color%3D%22%23333399%22%3EMicrosoft%20Power%20Automate%20Community%20Super%20User%3C%2FFONT%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor
Hello everyone,

Does anybody know how to connect Sharepoint to SQL?. I need to create a Sharepoint form to register selling information and then read, follow and modify it in SQL Server.

Usually I use Visual Studio to connect SQL databases with external data sources, but I dont Know which data source connection I must use and where I can get the connection parameters from Sharepoint.

Please I would appreciate your help!

Thanks!

Best regards
Fabricio
3 Replies

@Fabricio1081 There are SQL Server triggers and actions in Power Automate. So when an item is created in a SharePoint list it can insert a row into SQL Server. It is a premium connector though so will cost something.

 

sqlActions.png

 

Rob
Los Gallardos
Microsoft Power Automate Community Super User

Thanks Rob,

Is there any free feature?

@Fabricio1081 there's no free SQL connector in Power Automate. There might be other ways to do what you want but I'm afraid I'm not the one to give you an answer on that.

 

Rob
Los Gallardos
Microsoft Power Automate Community Super User