Submit Form not working on dynamic data source

[akario]

I have datasource from excel serveral tables.
and I datasource of from as dynamic table link to dropdown.

but when I save data by SubmitForm(Form1). It's not working.

[shailendra74]

Hi @akario 

Is the Edit Form mapped on a single table for insert/update or how is it.

If its Edit Form, can you check the DataField & Update Properties of the DataCard.

Thanks.

[v-yutliu-msft]

Hi @akario ,

Please check:

1)whether the excel file was opening when you submitted the form?

2)did you set the right property to the dropdown?    (DropDown1.Selected.fieldname)

Do you have any error message?

Could you show your screenshoots or the settings of the form?

Best regards,

Community Support Team _ Phoebe Liu

[akario]

Show error message below

"There was a problem saving your changes. The data source may be invalid"

Due to I assigned table with below fx
Set(TBSc,Switch( LabelTable.Text,"Sb01",Tb01,"Sb02",Tb02,...)

and then I have set Data Source of EditForm1 as TBSc

once I run SubmitForm(EditForm1) 
the message above occure

[akario · Accepted solution]

Oops! sorry it's working fine

able to submit form now.

After I changed to assigned table with Set(tb,switch(...))

Previously I have assigned table by store multi tables in Collection.