@tlangford while you can do cascading lookups (as you've found), there is currently no functionality that will "auto-populate" the default value of the second control based on the first control. Best workaround for this would be making the second control required so as to not miss any data entry. 

We can also put together a feature enhancement request for the Data Lookup control, but I want to make sure that I've got a good understanding of desired functionality so I do have a couple questions:

• Should this only be "auto-populated" if there is just one value available, or should there always be a default value that is "auto-populated" when configured?
  
  
  
  
  
  • If the second, is there a prefered way that you would like to see that in the configuration panel? Given that the designer won't know values at design time (they will be populated at run time), could potentially do something like "value index" instead of "value text", but depending on sorting even that might change. 
  
  
  
  
  
  

Would love to get your thoughts.

Thanks!

Hi @butlerj,

Thanks for the feedback.

Ideally, what I'd like to be able to do (and from what I have seen from other competitor eforms solutions), in the scenario I presented, for the second form control (which would be dependant on the first data source form control), is the ability to use a number or text form control or a drop-down form control.

For the numeric or text form control, I'd like to see this return only a single value based on the selection from the first data source form control.

For the drop-down form control, I'd like to see this return multiple values based on the selection from the first data source form control and these would be displayed as values in the drop-down to be able to select from. So it would be great for this functinoality to be intuitive enough based on the type of form control used in conjunction with the data source.

Perhaps the conditions currently available in the data source form control could be moved out to a separate tab altogether in the forms designer along side the rules tab - perhaps called seomthing like "lookup rules"?

Thanks.

@tlangford awesome! Super appreciate that feedback.

We have been thinking about how to make rules easier within form controls, so I'll definitely pass this along to our forms product team and see if we can add it along with some of the other ideas we have been kicking around.

Hi @tlangford,

At the moment the data lookup control in primarily used for a choice control at the moment. We are looking to expand this functionality whereby you will be able to query for a whole object and use parts of that object as you described.

However, there may be a way to get what youre after if I understand your requirements correctly. I have created a video on how I would solve this - hope this is helpful to you.

Cheers,

Euan

Hi @EuanGamble,

Thank you for taking the time to explain that functinalty - what you've demonstrated there is exactly what I need to achieve!

Thanks again.

Tim

Hi @tlangford,

Glad you found that useful. We are currently working on returning a data query as an object, which will make this a lot more powerful in the future, but hopefully, the example below will keep you going until we get this out.

Cheers,
Euan

Hi. Is there a way to populate multiple controls on a NWC form with data from a SharePoint Online list item

Hi @Andrew87,

This is a planned feature.

Cheers,
Euan

Hi @EuanGamble,
When can we expect to populate several controls via a lookup ?
For the moment, we have to maintain a concatenated value in the SharePoint list, which is a shame.
I would love to be able to populate several labels depending on the last dropdown of a cascading. 

Hi @allan,

So we have begun rolling out some new functionality that will continue to evolve over the next few months called 'External Data'. This allows you to call a data source from NWC and use the data. At the moment it is only available in the Label control, but this will extend to other areas of the form designer.

Cheers,

Euan