InfoPath Dev

Hello - first post here and new to InfoPath...

I'm looking for ideas with examples on how to populate a drop down list field on my InfoPath 2013 form from a single line of text column in a SharePoint 2013 list when another text column in that row contains the word "List"? The columns with these values are in the same row. I have a data connection (secondary) to the SharePoint list set up and the text column contains "A;B;C;D;E" (for this example, to keep it simple). The delimiter for the choices is the semi-colon.

So, in the SharePoint list I have
single line of text named Value1 containing "A;B;C;D;E"
single line of text named Field_Type1 containing "List"

I would like to populate the drop down list on my InfoPath form to have the choices:
A
B
C
D
E

My thoughts are to somehow populate a repeating field (that the user won't see) in the form's main schema from the list's values and then use the repeating field to populate the drop down list. Is this possible? I am using a Form Library and I can use VB code behind if it can't be done in rules only, or is much simpler in code.

Hope I have explained it well enough. Looking forward to your replies!

I attached an example.

Thank you! Shows exactly what I need to do.

Patrick,

Is having a repeating table necessary for this to work? I don't have one in my form, but I have duplicated everything else in your sample. When I preview mine, I only get the first item in the delimited text string to appear in the drop down list box.Curiously, I deleted the repeating table from the form in your example and it still populates the drop down list box just fine. I don't understand why your sample still works and mine (that never had a RT) doesn't.

If the RT is necessary for the way you set your example up, can it also be accomplished in a way that doesn't use a repeating table?

Thanks.

Yes, you need a properly repeating structure.

Adding one with default values should resolve your issue.

Please take a quick look at my attached form. I have tried to duplicate what you have done, but I can only get 1 row to extract into both the repeating table and drop down list. Hopefully, you can tell me what I'm missing?

Thanks!

That's because you don't have any default values for your rows.

Go into Data->Default Values. Expand group1 and select group2 and choose the dropdown on the right and add a bunch of rows. Preview again. Works now. :)

Awesome! I wouldn't have found that. I was incorrectly thinking the convert rules did the row adding.

Hi, I have been trying to figure out how to do this exact thing and this is the first post i've found that is my problem exactly!

Unfortunately though, I have InfoPath 2010, and it will not open any of your all's attachments (says I need a newer version of InfoPath).

Would someone mind saving the latest ConvertDelimited.xsn that was posted by Patrick as an InfoPath 2010 compatible form and then uploading it so that I may download it (I assume just File --> Save As)?

Thanks so much to whoever can do this for me!

You bet - here's a 2010 version. File > Save As then right click and select Design. :)

Thanks for the response! I just right clicked on the file attached to your post and saved it to my desktop, but it still says the same message when I try to open it, in either Design mode or Filler mode.

That's odd. Here's another try - hopefully this time I managed to really save it as 2010.

That one did it! Thanks so much!!

I copied your example to the T but only one row will populate from the repeating table. I tried to type this into the ID field value but it would not accept it. I ended up having to click Edit Xpath in order to get the formula to take. I'm thinking this is the problem area. Please help when you have time. Thank you

Nevermind :) All I had to do was read. Thank you!