Import real time data from MySQL to SharePoint

%3CLINGO-SUB%20id%3D%22lingo-sub-634576%22%20slang%3D%22en-US%22%3EImport%20real%20time%20data%20from%20MySQL%20to%20SharePoint%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-634576%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3EWe%20have%20recently%20implemented%20share%20point%20in%20our%20org%20and%20want%20to%20start%20building%20workflows%20in%20it.%3C%2FP%3E%3CP%3EBusiness%20Case-%3C%2FP%3E%3CP%3EWe%20have%20forms%20submitted%20by%20our%20customers%20on%20our%20website%20and%20that%20data%20is%20stored%20in%20a%20MySQL%20database.%20I%20want%20that%20data%20to%20be%20auto%20populated%20in%20the%20share%20point%20so%20i%20can%20create%20a%20workflow.%26nbsp%3B%20This%20forms%20have%205%20to%206%20fields%20and%20the%20traffic%20is%20about%2010%20forms%20in%20a%20day.%20I%20want%20to%20get%20that%20data%20in%20the%20share%20point%20on%20a%20near%20real%20time%20basis%20meaning%20couple%20of%20times%20a%20day%20or%20at%20least%20one%20time.%20Could%20some%20one%20suggest%20a%20good%20approach%20for%20this%20and%20we%20also%20might%20have%20similar%20projects%20in%20the%20future.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-634576%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EMicrosoft%20Flow%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-636385%22%20slang%3D%22en-US%22%3ERe%3A%20Import%20real%20time%20data%20from%20MySQL%20to%20SharePoint%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-636385%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F346864%22%20target%3D%22_blank%22%3E%40Uday33%3C%2FA%3E%26nbsp%3Bone%20approach%20would%20be%20to%20use%20the%20MySql%20connector%20for%20Flow%20to%20copy%20data%20from%20the%20DB%20to%20a%20SPO%20list%2C%20see%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fconnectors%2Fmysql%2F%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fconnectors%2Fmysql%2F.%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Hi,

We have recently implemented share point in our org and want to start building workflows in it.

Business Case-

We have forms submitted by our customers on our website and that data is stored in a MySQL database. I want that data to be auto populated in the share point so i can create a workflow.  This forms have 5 to 6 fields and the traffic is about 10 forms in a day. I want to get that data in the share point on a near real time basis meaning couple of times a day or at least one time. Could some one suggest a good approach for this and we also might have similar projects in the future.

1 Reply

@Uday33 one approach would be to use the MySql connector for Flow to copy data from the DB to a SPO list, see https://docs.microsoft.com/en-us/connectors/mysql/.