Office 365 & InfoPath Browser Form Limitations - Hilary Stoupa
in

InfoPath Dev

Hilary Stoupa

Office 365 & InfoPath Browser Form Limitations

Since we never know what will or won't work on Office 365 on a given day, I thought I'd outline a few things that we know at this time.

  1. SharePoint Web Services (this includes REST [OData]) are blocked.
  2. Sandboxed forms (forms with code) are slow to load.

 

Comments

 

Maryam said:

Hei,

I have used this link www.infopathdev.com/.../26246.aspx

to submit repeating table to SharePoint 2013 list but when i want to connect to the Lists Web Service and specify the parameters of the UpdateListItems method, I get error.

I used servername/.../lists.asmx

but i get error that the link can not be open.

January 12, 2016 1:15 AM
 

Hilary Stoupa said:

It looks like your link is correct - _vti_bin/lists.asmx. You'll need your SharePoint admin to take a look at the log files, most likely.

January 12, 2016 7:37 AM
 

DC Forms said:

Hilary,

Have you or anyone you are aware of tested to see if the allocation of additional Server Resources to the site collection containing sandboxed forms (specifically qRules) improves performance?

I have not been able to find any specific guidance on what a resource unit is, or more importantly a rough order of magnitude of a unit to sandboxed code. E.g. An InfoPath form with custom code utilized X times an hour would require approximately Y resource units allocated to the site collection. Y would need to be increased based on code complexity, indicated by the site collection hitting a 90% resource threshold.

Reference: support.office.com/.../Manage-SharePoint-Online-server-resource-quotas-for-sandboxed-solutions-90e4eaaa-899a-48d6-b850-f272366bf8cc

Darian.

February 9, 2016 8:48 AM
 

Hilary Stoupa said:

Hey Darian:

No - I've never found anything specific about resource units, which is very frustrating. I know I've tried allocation additional resources for qRules forms in the past in Office 365 but if I recall correctly, it didn't help performance at all.

H.

February 9, 2016 2:59 PM
 

Sheila said:

Hi Hilary,

I'm hoping you can clear something up for me. Everything I have read says that I cannot utilize the UserProfileServices for InfoPath in O365, yet your link at the top of this page takes me to an article that says that the following calls ARE supported and UserProfileService/GetUserProfileByName is one of them. Do you think you could help clear this up for me? I desperately need to pull in the current user, email, preferred name and manager if possible. It all works correctly in InfoPath 2013 of course but as soon as I move it over to the SP Online environment, no go.

Thanks!

January 19, 2017 10:17 AM
 

Hilary Stoupa said:

Yup - this blog post was written in 10/2015. Since then, MS has modified Office 365 and the user profile service is supported.

However, you probably need to set the user name field and run the query for your user profile service, instead of just running the query on load. Have you tried that?

Generally, I put the query & data fields on the form (while working out what I need to do) and add a button to execute the query. Publish to Office 365, and try the query. Make sure the profile property names are the same as in Filler [Preview] - they may not be. :)

January 19, 2017 10:31 AM

About Hilary Stoupa

I wandered into development after working as a business process analyst for a global manufacturing company. I create InfoPath solutions for our clients as well as work as a developer on company tools that extend InfoPath. I've also been instrumental in creating the InfoPath Master Class training provided by Qdabra.

Copyright © 2003-2019 Qdabra Software. All rights reserved.
View our Terms of Use.