Data Connections

Re: Possible to have "get choices from an external data source" with CAML and repeating section?

magickarle — Thu, 04 Feb 2016 16:27:06 GMT

Thank you.

I do not mind having then all as drop down.

But I am wondering if I am handling it the right way.
So summarize:
The top non repeating controls are bind to the main controls form?
Their values are coming from a SharePoint list called Matrix.

The bottom section contain repeating controls bind to the CAML?
Their values are coming as well from the Matrix SharePoint list.

I would like to have a submit button that would submit the form data to a sharepoint list (and depending if the user added a row in the repeating section, would submit twice, or 3, 4 5 times. Depending if the user inserted 2,3,4,5... rows.
Each rows contains different data and different columns.

Re: Possible to have "get choices from an external data source" with CAML and repeating section?

Hilary Stoupa — Fri, 29 Jan 2016 23:44:31 GMT

Well, you can right click the text control and select Change Control and change it to a drop down - but then ALL your CAML fields will be drop downs and you'll have to do something tricky to only get the options you want to display in each one. Probably easier to use form fields and then set your CAML values. You can modify the manifest file to filter a rule's target or in your CAML XML you could add some extra attributes for helpers. Take a look at the attached sample for what I mean - save the form locally, right click and select design to open in design mode.

Possible to have "get choices from an external data source" with CAML and repeating section?

magickarle — Fri, 22 Jan 2016 12:58:38 GMT

Greetings.
First, thanks for taking the time to look at this post.
Second, I am sorry if this question has already been answered (but I did search for days now) so it must have been buried somewhere I didn't dig in yet.

Here what I am trying to do:
Have a form with:
Top: Non-repeating with:
'Employee status','Request Status','Client','Work Group','Name','PEIN'
Those are CAML fields.

Bottom repeating:
'Platform','SubPlatform','Access Group','Access Type','Platform ID','SN'
Those are standard infopath Input Controls

I want the 'Employee status','Request Status' to be Drop-Down lists so user can choose predefined values (coming from a Sharepoint list)
Same for 'Platform','SubPlatform','Access Group','Access Type'.

My problem is the CAML XML.
I do not know how to assign or bound the drop-down to them.
By default, if I drag the CAML fields on the forms, they have to be filled manually by user.

Thanks for pointing me in the right direction.