when I try to set a field value based on a rule linked to one field , the same rule has been created on foundation form and it works .
Rule insert inside Forms field “Sales Organization” does not set the value into Distribution Chanel Field automatically despite the fact it has been created the reference data connection at Solution level and field Sales Organization which has the origin rule in place.
Field Distribution Chanel must be included automatically once the Sales Organization label field is inserted at form level .
In the form the field Distribution Chanel is not set automatically when field Sales Organization is included
When you are using set field value to fetch data data in another dropdown depending on the value selected in particular drop down that is for example if in my SharePoint list I have sales organisation 1000 and distribution channel against is 01; in my solution I had set a rule when I select from drop down list value 1000 then Distribution channel should automatically retrieve 01 .
1) Write a relevant rule based on requirement; Based on above example below rule can be written.
$form.getExternalValue("Distribution Chanel","aDistribution32Chanel", '@aSales32Organizational32Internal = "'+$form.getValue('/my:myFields/my:MM02/my:MM02_Input/my:Sales_Organization')+'"',true)
2) Along with that what we need to make sure is when we are adding the Data connections "Automatically Retrieve Data" option is checked; If you had already added data connection and forgot to check it you can simple right click on the data connections - Edit - Then Check the relevant box.