Inserting new created sharepoint list items into an Azure DB

(0) Share

Report

Posted on by gazzo1967

1,151

HI All

I have a scenario which my organisation wants to send Powerapp data to Sharepoint and SQL DB.

They want to keep the features of using Sharepoint list such as Person/Group lookup etc but once the data has been submitted i need to copy the same information into a table on the SQL DB

I am fine when it comes to using sharepoit lists but SQL DB is new to me.

I have researched but can't find mush in the way of this functionality.

Any help would be great

Thanks Gary

Categories:

General topics

All responses (6)

Answers (0)

Sort by

gazzo1967 1,151 on at

Like
a
(0)

Report
Copy link

Link copied!

is really as simple as
When item created Insert row?
manuelstgomes 6,643 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @gazzo1967

We need to set expectations first.

SharePoint Lists have some concepts that can be translated to database concepts. For example, some items in a list can be easily created into a table (string, numbers, etc.). Lookups can be translated roughly to relationships between tables, so if you want a "People Lookup," you need to create a reference to a table "People."

Does this make sense?

So to get data into an Azure SQL Database can be quite simple or pain in the behind depending on how well your SharePoint list are translatable to SQL.

Can you provide a sample of the SharePoint list so that I can help you further?

If you can't try the following:
Create a stored procedure that inserts data into the table(s) that you want to save the data.
Create a simple flow that calls that stored procedure once an item is created (you can use the modified to update the results)

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
Cheers
Manuel
gazzo1967 1,151 on at

Like
a
(0)

Report
Copy link

Link copied!

@manuelstgomes
I assume that the people/group takes its information from the sharepoint user list?
i also have fields that populate via choice fields and one lookup
I kind of understand that i have to have a primary and a foriegn key to create the relationship.
This is not going to simple is it lol?

Gary
gazzo1967 1,151 on at

Like
a
(0)

Report
Copy link

Link copied!

@manuelstgomes
i know this would be a really 'hack' way to do it but would it not work by exporting to excel then sending to SQL?
v-bacao-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @gazzo1967 ,

Perhaps you can consider only recording key information in SQL DB.

For example, the Person field stored in the SharePoint list, you can consider inserting the Person email only in the SQL DB, because this is the unique info, but the most critical information, you can use it to do a lot of subsequent operations.

Best Regards,
manuelstgomes 6,643 on at

Like
a
(0)

Report
Copy link

Link copied!

@Gaz_E sure if you prefer that could work. I don't recommend it because there's an extra step without any additional gain. Try moving it directly to the database. The flow is quite simple; you'd get a much more clean flow. My recommendation:
1. Make a list of the SharePoint's fields and types.
2. Check if you can make them all into strings, numbers, and dates.
3. If you can, dump everything as-is into the database in one fast and quick step :).

If you have to add more stuff to SharePoint, then it's just a question of adding that field to the database and map it in the flow. Simple and clean..

@v-bacao-msft has a point. Store only information that you need. You can fetch for the rest of the information later if you need it.