Dropdown List from external source (xls, sharepoint) doesn't save to Sharepoint

[Bevardib]

I ran into an issue:

I have created a canvas app with multiple screens.

On the first screen of the app, I use a drop-down list that takes the values from SharePoint / excel (I tried both, but none of them seem to work...).

The values appear properly at the selection but after hitting the submit button (Patch function) it records everything for the specified SharePoint, except for this particular value for the location, from the drop-down.

Now it is an excel list, formatted as a table, and contains IDs as well.

I have no idea why it doesn't record this record only.

I'd appreciate any suggestions to resolve this.

tnx  

[WarrenBelz]

Hi @Bevardib ,

The Update of the Data Card needs to reflect the output of the Combo Box

ComboBoxName.Selected.xxxx

where xxxx is Value/Result/FieldName for the controls concerned.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications)   Visit my blog Practical Power Apps

[Bevardib]

@WarrenBelz 

I do not use combo box, it is a simple dropdown only. I don't need actually the functions of the combo box.

Below I attach some more details:

"location" is the excel table the dropdown values come from.

 The "update value" looks like this:

[WarrenBelz]

@Bevardib ,

That is a Combo Box and you need

DataCardValue7.Selected.Location

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications)   Visit my blog Practical Power Apps

[Bevardib]

Unfortunately it runs into an error:

Message is : "the Name is invalid, 'Location' is unrecognizable, linked to an element that has been removed previously"

Any suggestions?

[WarrenBelz]

@Bevardib ,

Please see amended post

[Bevardib]

I saw the amended post.

I set the location:

It still gives an error message: "The system expects a 'record type' of value while the formula gives a 'text type' of value.

And still not saving to my SharePoint

[WarrenBelz]

@Bevardib ,

If you are writing back to a Text field then this as the output reference 

DataCardValue1.Selected.location

has to be valid if this (as you posted) is the control settings

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications)   Visit my blog Practical Power Apps