Hi
So I am building an App, its has two data sources one is SQL and other one is SharePoint list, SQL has 4tables from which I will get the information all are interlinked(relationships exist), based on that information I have data entry form, road block here is I cannot write/Update back the data to SQL server and unknown reason an empty table is also not possible to create in database for edit or adding new record. So my only option to have share point list as my data source to update or add new record.
I cannot make the edit form using both the sql and share point, as i need some of the information from SQL tables to be in Edit form as static.
is there an work around for this, if i chose the gallery source as share point list and fill some fields with SQL data it wont work!, i tried looks ups and all with reference to a view form as well.
Some one please help if there a process to it,
Data "in" SQL tables
Data Update/Edit/Add Share point, Combining both.
Thank you, Sorry for long Question
What would you suggest if the DB has multiple tables and a complex query is required to get all the data?
Thank you So much @v-yujincui-msft , it worked
Hi @Shashidhar ,
Maybe you could try to use the Lookup() function to populate the default value of the fields in the Form.
I have made a test for your reference.
1. Here is my SharePoint list(Data sources for Gallery and Form).
2. Here is my SQL table.
3. Here is my App.
Result Screenshot:
Best Regards,
Charlie Choi
Hello @90_percent
Yes you understood that correctly, but am not using Dataverse, Yes i tried brining to local collection, but here selection will not allow items to pop on the edit form as edit form only take info from one source. i thought there is a work around
I may not be understanding this quite right, but you want to be able to write back to SP with updates, but your form needs to have both SQL and SP information in it?
have you tried bringing the SQL data into a local collection, then displaying it. I do that with a Dataverse table, not sure if it works the same as SQL.
WarrenBelz
89
Most Valuable Professional
MS.Ragavendar
58
Michael E. Gernaey
42
Super User 2025 Season 1