InfoPath Dev

Hello All,

This is my first post here, I've learned a lot in that forum many thanks!

I need to make cascading drop down based on that information prepared in separate list in SP "Cities_Offices"
Those dropdowns will be in Repeating Section! 

Paris	London	Brussels	Madrid	Milano	Amsterdam	Rome	Berlin	Oslo	Stockholm	Copenhagen	Lisbon
1	1	1	1	1	1	1	1	1	1	1	1
2	2	2	2	2	2	2	2	2	2	2	2
3	3	3	3	3	3	3	3	3	3	3	3
4	4	4	4	4	4	4	4	4	4	4	4
5	5	5	5	5	5	5	5	5	5	5	5
6	6	6		6	6	6	6	6	6	6	6
7	7	7		7	7	7	7	7	7	7	7
8	8	8		8	8	8	8	8	8	8	8
9	9	9		9	9	9	9	9	9	9	9
10	10	10		10	10	10	10	10	10		10
11	11	11		11	11	11	11	11	11		11
	12	12		12	12	12	12	12	12		12
	13	13		13	13	13	13	13	13		13
	14	14		14	14	14	14	14	14		14
	15	15		15	15	15	15	15	15		15
	16	16		16	16	16	16	16	16		16
					17	17	17	17	17		17
					18	18		18	18		18
						19		19	19		19
						20		20	20		20
						21		21	21		21
						22		22	22		22
						23		23	23		23
						24		24	24		24
								25	25		25
								26	26		26
								27			27
								28			28
								29			29
								30			30
								31			31
								32			32
								33			33
								34			34
											35
											36

It should work with 2 drop fields ("City" and "Office №") when I select the "Country" to give me the numbers below it as options in the second dropdown  "Office №"

 Sorry for asking something already asked but I read so much about different solutions that I get lost and probably doing something wrong. 

 

Hi - if you can attach a copy of your form with the list data connection and the Country dropdown configured, I can help you with this. You can add an attachment under the Options tab in a reply. :)

 Hello Hilary, I have managed to do it creating a table with repeating cities + option "Show only entries with unique display names"
But now I'm facing another problem, trying to extract the data from 4 columns with numbers in 4 fields, depending on 3 drop down selection. 

I've made 3 filter conditions all 3 searching for equals in main matching with external information in SP list, all working in InfoPath preview but when I upload it in SP it returns error when try to add new item:

The form could not be displayed because default values or rules are taking too long to evaluate. To correct this, simplify the expressions or reduce the size of the data sets that they depend on.

Any ideas how to fix it? Thank you! 

Is your SharePoint server on-prem or Office 365 (SharePoint Online)?

 I think 365 but please tell me how to check to be sure (sorry for stupid questions these are mine first steps)

Does the URL have sharepoint.com in it? :)

 No it doesn't it is on our company domain :)

Happy new 2018, best wishes 

 i thing I got an idea, so I have 5 fields to be populated with default values based on 3 others dropdown menus. It is working with 3 filter Conditions until I upload it (probably is to heavy) So I was thinking to use those filter conditions only for one of those 5 fields and then using its id to populate the other 4. Is that possible?

 I am not sure w/out seeing the form - I'm having a hard time understanding how the form is currently designed. But yes, you could give that a try. I really don't see how 3 conditions on a filter could cause this issue in the browser, unless you have some fields with defaults that are firing rules and causing complexity.

 When I use those 3 filters only on one of those 5 fields it is working online, the problem comes when I add them to others