SharePoint Integration

Re: Field reset after submit

lwenzel90 — Thu, 10 Aug 2017 18:58:31 GMT

I have a solution that works with many fields we had just hoped that we could use a list to make it more easily updatable for our non tech professionals but this will be a solution until we find another I suppose. Hilary I can not thank you enough for all the help that you have given me! Thank you so much for making your knowledge available!

Re: Field reset after submit

Hilary Stoupa — Thu, 10 Aug 2017 18:41:14 GMT

Fiddler came back with the not so helpful "Server was unable to process request. ---> Object reference not set to an instance of an object.". Do you have an earlier copy of the form that still will publish as browser enabled? You may want to compare that with your latest. I continue to think that you may have to just use default data in the form instead of a list, and even that may be problematic with 150 items.

Re: Field reset after submit

lwenzel90 — Thu, 10 Aug 2017 18:03:46 GMT

Thank you I would appreciate it!

Re: Field reset after submit

Hilary Stoupa — Wed, 09 Aug 2017 15:13:57 GMT

I just realized you are publishing to Office 365 - so that takes REST out of the equation. I'll try to publish to my O365 site while running Fiddler to see if I can see why you are getting an error, but you may just not be able to do this leveraging a list. You may just have to use default data after all.

Re: Field reset after submit

lwenzel90 — Wed, 09 Aug 2017 12:12:16 GMT

I am getting an error now that will not allow me to use the form without infopath filler.

Re: Field reset after submit

Hilary Stoupa — Tue, 08 Aug 2017 19:48:31 GMT

I'm surprised by the infinite loop error - because if we are just setting ID by default then it sets its own items, I don't think we'd get a looping error. As to the initial error - that isn't one I've run into before. You may be able to switch to a REST connection to just retrieve the selected department, and add a second REST connection to return the "default" items.

Re: Field reset after submit

lwenzel90 — Tue, 08 Aug 2017 12:40:41 GMT

Please anyone feel free to give any advice about either of my errors or about my current form thanks! :)

Re: Field reset after submit

lwenzel90 — Mon, 07 Aug 2017 14:21:35 GMT

Thank you for this form Hilary and sorry for the delayed response. I have been out of the office for a while but I do not have the best news to report. Okay so I think this was a good step in the right direction for this form the departments are now being queried based on the list of values that are pull from my secondary source SP list, but more problems seem to keep appearing as time goes on...

I am getting the error "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." when I open the form after publishing. The number of items in the list are around 150 in total.

I also get an error when selecting the largest department query that the form needs (selecting 80 entries at a time). The error that I get when doing this in preview mode is:

"An error occurred in the form's rules or code. The number of rule actions or the number of calls to the OnAfterChange event for a single update in the data exceeded the maximum limit.

The rules or code may be causing an infinite loop. To prevent this, ensure that the rule action or event handler does not update the data which causes the same rule action or event handler to execute."

Questions

Is this too much for SharePoint to handle with a query?

Could it be a possible logic error with the setting of values using the ID?

Also each department can have any amount of different items being queried at a time is this a problem?

Any help that can be passed along would be greatly appreciated! :)

Re: Field reset after submit

Hilary Stoupa — Wed, 02 Aug 2017 22:21:31 GMT

Well. Let's see if this works? I modified the default on the ID field to (hopefully) only include items that match on department OR have Default for department... Again, working totally blind here, so this could be all kinds of wrong. :)

Re: Field reset after submit

Hilary Stoupa — Wed, 02 Aug 2017 15:15:01 GMT

I just realized we can't use Department as a query field because it is repeating. I have an idea for how to make this work tho ... I'll post later w/ another copy of your form. I think what I need to do is change the default for ID to only include items that either match on department or have the value of default as a department. Then you only have data that should be displayed in the form copied into the main DS. :)

Re: Field reset after submit

lwenzel90 — Wed, 02 Aug 2017 13:18:38 GMT

Does that mean I need to create another list with only the default options or just another data connection possibly with a filter of some kind?

Re: Field reset after submit

Hilary Stoupa — Tue, 01 Aug 2017 21:12:47 GMT

I would query for only the list items that matched on department, then have a second connection that only returned items where the department = default.... I think that might work. I'll try to modify the form I sent to take care of the first part of that, but it will be tomorrow afternoon before I have time. :)

Re: Field reset after submit

lwenzel90 — Tue, 01 Aug 2017 19:52:41 GMT

I am sorry but I am still confused. I am not sure how to get the departments from the secondary data source. I would need to have the information as a repeating data field and I am a novice to this. But to answer your question about list items, there are about 140 in the list.

Re: Field reset after submit

Hilary Stoupa — Tue, 01 Aug 2017 19:09:52 GMT

Yeah, you may need to just add the department field to the same place in the main data source - but how may items are in your SharePoint list? A lot? In which case it may be better to just query for the specific department to populate the order section, then have the same fields in another group (called options or something) and use another connection to the same list to just get back the default items....

Re: Field reset after submit

lwenzel90 — Tue, 01 Aug 2017 12:41:57 GMT

Thank you for the fast response! The desired outcome is to have each food item check a repeating field of departments associated with it and then compare that to the main department field on the form. If the fields match it will show an item if not it will hide it. The department field also can hold multiple values per department, as to say the departments at my work place have overlapping items and over 20 departments are unique with the options they have. There are also a group of items that are used in every department that I have given the value of "Default". The picture below shows the information as presented in the sharepoint list. I am not sure if the optional field you created will be able to what is required of this form. Is there a way to set a repeating fields data from the secondary data source similar to what you did with fields such as item, price, quantity, etc? I think it is necessary to have the department values for each item in the form.