After doing some research (and since I am not allowed to change the "Number of Actions per Postback" and "Maximum size of form session state" values), I think a solution might be to change my Sharepoint list data connection into a REST connection.
So, I created a REST connection to the list which has the data I need to populate variuos drop-down menus.
Now, I want to fetch and filter data for various drop-down menus based on the choice made in the previuous drop-down menus.
This is what I made:
- I created an Action Rule on my first Dropdown menu that Change REST URL to https://mysite.com/sites/myteamsite/_vti_bin/ListData.svc/mycooldatalist?$filter=/dfs:myFields/dfs:dataFields/my:SharePointListItem_RW/my:Dropdown1 and then Query for data using the REST connection;
- I set the second Dropdown menu to "get choices from an external source" and I choosed as data source my REST connection.
Doing so iteratively, I should be able to have various cascading dropdown menus, each one is based on the choice made of the previous one.
Well... this is not working, I fear I'm doing something wrong on step 1. because I get the error: "Could not open: https://mysite.com/sites/myteamsite/_vti_bin/ListData.svc/mycooldatalist?$filter=/dfs:myFields/dfs:dataFields/my:SharePointListItem_RW/my:Dropdown1"
Any ideas?