General

Re: Csacading drop-down in repeating section

Martoepi4 — Thu, 04 Jan 2018 16:05:18 GMT

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

Re: Csacading drop-down in repeating section

Hilary Stoupa — Thu, 04 Jan 2018 15:44:58 GMT

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.

Re: Csacading drop-down in repeating section

Martoepi4 — Thu, 04 Jan 2018 15:37:43 GMT

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?

Re: Csacading drop-down in repeating section

Martoepi4 — Thu, 04 Jan 2018 12:42:05 GMT

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

Happy new 2018, best wishes

Re: Csacading drop-down in repeating section

Hilary Stoupa — Tue, 02 Jan 2018 15:28:26 GMT

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

Re: Csacading drop-down in repeating section

Martoepi4 — Fri, 29 Dec 2017 12:46:12 GMT

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

Re: Csacading drop-down in repeating section

Hilary Stoupa — Thu, 21 Dec 2017 15:32:33 GMT

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

Re: Csacading drop-down in repeating section

Martoepi4 — Wed, 20 Dec 2017 09:01:00 GMT

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.

Correlation ID:1353389e-e0bf-0000-01cf-09d092901abb

Any ideas how to fix it? Thank you!

Re: Csacading drop-down in repeating section

Hilary Stoupa — Mon, 18 Dec 2017 15:35:26 GMT

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. :)

Csacading drop-down in repeating section

Martoepi4 — Mon, 18 Dec 2017 09:01:18 GMT

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.