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