Data from SQL server not showing in SharePoint list

[umistry]

Hi,

I am trying to make a PowerApps to view and edit SharePoint lists. However for one field (Project Name) I am pulling data from a SQL server. 

Project name field exists in SharePoint and in the SQL server. The reason I am pulling data from SQL server is because the SharePoint list does not have all the values. 

When I created the app from the SharePoint list, project name Datacard had a dropdown as default. So I replaced that with combo box from the SQL connection that I established where I can search for the project name.

I made changes to the Update property of the Project Name Datacard to take the selected items from the Combo Box (SQL connection) so that when the form is submitted the Datacard takes values from the Project fields from the SQL connection Combo Box instead of the Dropbox from the SharePoint list. 

ISSUE:

After the form is submitted the data in SharePoint list has no entry for the Project name field. I am not sure what is not working. 

Let me know if you need any other information from me regarding this issue. 

[RandyHayes]

@umistry 

To clarify - are you stating that the SharePoint list entry for that record submitted is empty, or that when you go to edit the record from the list in your app, the combobox is empty?

What is the Items property of your combobox, and what is the Update property you changed on your datacard?

[umistry]

The SharePoint list entry for that record has empty value for Project Name

[RandyHayes]

@umistry 

"and what is the Update property you changed on your datacard?"

[umistry]

"ComBox10.Selected"

 I am using Selected instead of SelectedItems as it throws an error that Record value accepted 

[RandyHayes]

@umistry 

Okay, so then I need a few more details.

1) What is the data type of the project name (I assume that is the underlying field) that you have in this datacard?

2) What is the Items property of the Combobox?

[umistry]

1) Datatype of project name is: Table (as seen in PowerApps) and LookUp (as seen in Sharepoint)

2) Items property of ComboBox is: table_name.project_name

[RandyHayes]

@umistry 

So then your data type in your list is a Lookup column!

Is it set to allow only one selection, or multiple selections?

The Items property of your combobox is not going to work for this.

You will need to change that to table_name and exclude the .project_name

Your Update property will then become:

With(ComBox10.Selected,
    {Id: ID,
     Value: project_name
    }
)

[umistry]

Thanks a lot for your suggestions @RandyHayes . When I added this update statement, it did not show any error however when I am trying to submit the form it shows Server Error: Bad Gateway. Also ID is corresponding to which ID column? The ID in sharepoint list ?

[umistry]

I changed the Update Property and I added Id: id_col_from_sql_db. However the project name that is visible is some other project name. Can you please explain which ID should be used and if it needs to have the same id value as the SharePoint list?