Hi @Anonymous ,
Could you please share a screenshot about your app's configuration?
Do you bind the Dropdown box to a certain field in your Excel table within the Edit form?
If you remove the normal Text Input box within the field data card in your Edit form, instead, add a Dropdown box inside it, please make sure the Update property of the field data card is set to following:
Dropdown1.Selected.Value
set the Default property of the Dropdown box to following:
ThisItem.FieldName
after that, when you click the "Submit" button, then selected value within the Dropdown box would be saved back to your Excel table.
If you add the Dropdown box out side the Edit form, and you want the selected value within the Dropdown box to be saved back to your Excel Table when you submit your form data, I think the OnSuccess property of the Edit form and Patch function could achieve your needs.
Set the OnSuccess property of the Edit form to following:
Patch(
'Excel Table',
EditForm1.LastSubmit,
{
FieldName: Dropdown1.Selected.Value
}
);
Back()
Set the Default property of the Dropdown box to following:
BrowseGallery1.Selected.FieldName
Note: The FieldName represents the field in your Excel table, which is used to store the Dropdown box selected value.
Best regards,
