Forum Discussion
HaimOz
Jun 19, 2020Copper Contributor
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