Answered

Multiple Tables and two Data Sources, one view form and one edit form

Like (0) Share

Report

Posted on 9 Mar 2022 02:20:08 by Shashidhar

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

Categories:

Connecting to Data

All responses (5)

Answers (1)

scantr 3 on 07 Dec 2022 at 16:17:35

Like (0)

Report

Re: Multiple Tables and two Data Sources, one view form and one edit form

What would you suggest if the DB has multiple tables and a complex query is required to get all the data?
Shashidhar 31 on 11 Apr 2022 at 05:40:43

Like (0)

Report

Re: Multiple Tables and two Data Sources, one view form and one edit form

Thank you So much @v-yujincui-msft , it worked
Verified answer

v-yujincui-msft on 15 Mar 2022 at 07:50:02

Like (1)

Report

Re: Multiple Tables and two Data Sources, one view form and one edit form

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
Shashidhar 31 on 09 Mar 2022 at 03:33:09

Like (0)

Report

Re: Multiple Tables and two Data Sources, one view form and one edit form

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
90_percent 69 on 09 Mar 2022 at 03:00:43

Like (0)

Report

Re: Multiple Tables and two Data Sources, one view form and one edit form

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.