Data Connections

Re: Infopath 2013 publishing to SPOnline: what are the data connections that work?

Hilary Stoupa — Mon, 21 Aug 2017 15:36:53 GMT

Glad you got it sorted out & thanks for posting what you learned. :)

Re: Infopath 2013 publishing to SPOnline: what are the data connections that work?

suxxxann — Mon, 21 Aug 2017 09:27:07 GMT

ok, I was able to remove the error message by deleting some other connections I created that were not right

Re: Infopath 2013 publishing to SPOnline: what are the data connections that work?

suxxxann — Mon, 21 Aug 2017 08:54:24 GMT

Adding to what I wrote before, I did manage to get something out of it with GetCommonManager. The result is that I see the userid of the manager of the person logged in in the SPO only format i:0#.f|membership|name.lastname@domain.com which is fine.

My problem is that when opening the form I get an error message

Warning

An error occurred querying a data source.

Click OK to resume filling out the form. You may want to check your form data for errors.

An error occurred while trying to connect to a Web service.

An entry has been added to the Windows event log of the server.

Log ID:5566

Correlation ID:bb62119e-d010-4000-2eca-a66dfb73c62d

An error occurred while trying to connect to a Web service.

An entry has been added to the Windows event log of the server.

Log ID:5566

Correlation ID:bb62119e-d010-4000-2eca-a66dfb73c62d

Not sure that with this correlation error Microsoft can help, anybody know what is the reason for the error?

If I click ok and the form displays correctly.

Infopath 2013 publishing to SPOnline: what are the data connections that work?

suxxxann — Mon, 21 Aug 2017 07:34:44 GMT

I am attempting to identify users that open up a certain form.

I was able to use the account ID for the user and I wanted to show a value such as the permission allocated to the user (for example 'Design', 'Full control' etc) or the sharepoint group he belongs to.

I have tried with the data connection SOAP called

GetUserMembership

GetUserCollectionFromGRoup

GetgroupcollectionfromUser

Getrolesandpermissionsforcurrentuser

getusercollectionfromsite

getusermembership

and I was not able to get anything useful, either they were giving me errors (control binding is not supported) or they were giving me info I cannot use (such as the AD group).

Can someone tell me if there is a comprehensive list of the above functions to be able to understand what else I could try or what I am doing wrong? or someone to tell me the exact procedure to make appear the SP permission or the SP Group.

Also is someone listing how many of the above commands do not work in SPonline?