Forum Discussion

HaimOz's avatar
HaimOz
Copper Contributor
Jun 19, 2020

Update SQL table from SharePoint Online (Using a suitable WebPart))

I've created a portal in SPO for my organisation with 2 multiple pages. Here are the relevant 2:

1. Users upload certain files into his/hers dedicated folder (controlled by permissions and enforced by Power Automate).

2. On the second page, I would like to allow my users to update the content of their xlsx file which has been imported into SQL DB by Power Automate (right after they uploaded the file). I thought of creating a WebPart (or equivalent) where I will embed a view of the SQL table (SQL Azure Database), with one specific column for them to update.

I need their updates to be written back immediately to SQL (not expecting concurrent users working on it. so shouldn't be focusing on that).

Using a SP LIST (even external one) is not optional as it's very annoying and not very efficient updating 1 record at a time with the side menu opening every time (imagine a user might have hundreds of records to update, many with the same value - I'd like to offer them bulk update which would be ideal if they can Copy > Paste).

 

Would love to hear your thoughts and suggestions as I've been struggling for couple of weeks now and came out with nothing.

 

Thank you,

No RepliesBe the first to reply

Resources