Hi @AlMohalleb ,
Do you want to
1)display data from sql in first screen?
2)get data from screen1 and use this data to edit data in sharepoint list?
Could you tell me
1)the fields data type in sql that you want to use?
2)the fields data type in sharepoint list that you want to update?
3)you want to use which sql field to update which field in sharepoint list?
4)the controls that you want to display sql data in your sharepoint edit form?
Actually, your issue's key point is data type in two data sources.
Firstly, please notice the supported data type of these two data source:
You need to transfer data in sql to the same data type with the fields in sharepoint list.
Secondly, many data type in sql is not supported in powerapps.
You can not display or use these data type in powerapps.
If a SQL Server data type is not listed in the table above, it is not supported. Examples of unsupported SQL Server data types include: binary(), varbinary(), image, cursor, rowversion, hierarchyid, sql_variant xml, Spatial Geometry Types, Spatial Geography Types, and table.
Here's a doc about this connector:
https://docs.microsoft.com/en-us/connectors/sql/
Thirdly, to GetItem in sql, you need to have primary key in your sql table.
Then, let me make a similar test( if you all meet the requirements that I list above):
1)screen1
insert a gallery to display all items in your sql table, insert a display form to display selected item.
Set the gallery's Items: sqltablename
Set the display form's datasource: sqltablename
Set the display form's Item: Gallery.Selected
2)screen2
insert an edit form to edit item of your sharepoint list
Unlock the fields that you want to get data from sql
Then you just need to change the controls' Default peroperty to (textinput's Default, drop down's Default,combo box's DefaultSelectedItems)
Gallery.Selected.sqlfieldname
Then the control will display the data of sql instead of its original data.
Also, you need to change the datacards' Update property based on the fields' data type.
You do not need to change the submit formula, SubmitForm(Formname) is enough.
Best regards,
