Home

Infopath not loading data

%3CLINGO-SUB%20id%3D%22lingo-sub-1242692%22%20slang%3D%22en-US%22%3EInfopath%20not%20loading%20data%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1242692%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20migrating%20a%20SP%202013%20on%20premise%20site%20to%20the%20SP%20online.%20I%20have%20a%20class%20list%20and%20a%20registration%20list.%20To%20register%20for%20a%20class%20you%20select%20the%20class%20on%20the%20class%20list%2C%20it%20opens%20an%20infopath%20form%20with%20the%20class%20information.%20The%20form%20also%20contains%20a%20hyperlink%20derived%20from%20a%20calculated%20column%20in%20the%20class%20table.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3DCONCATENATE(%22%3CA%20href%3D%22https%3A%2F%2Fsp.mydomain.edu%2Ftools%2FPAS%2FLists%2FRegistration%2FNewForm.aspx%3FCourse%3D%26quot%3B%2C%5BClass%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsp.mydomain.edu%2Ftools%2FPAS%2FLists%2FRegistration%2FNewForm.aspx%3FCourse%3D%22%2C%5BClass%3C%2FA%3E%20ID%5D%2C%22%26amp%3BSource%3D%3CA%20href%3D%22https%3A%2F%2Fsp.mydomain.edu%2Ftools%2FPAS%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsp.mydomain.edu%2Ftools%2FPAS%3C%2FA%3E%22)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESo%20a%20normal%20link%20would%20look%20like%20this%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fsp.mydomain.edu%2Ftools%2FPAS%2FLists%2FRegistration%2FNewForm.aspx%3FEvent%3D46%26amp%3BSource%3Dhttps%3A%2F%2Fsp.mydomain.edu%2Ftools%2FPAS%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsp.mydomain.edu%2Ftools%2FPAS%2FLists%2FRegistration%2FNewForm.aspx%3FEvent%3D46%26amp%3BSource%3Dhttps%3A%2F%2Fsp.mydomain.edu%2Ftools%2FPAS%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAs%20you%20see%2C%20it%20opens%20the%20infopath%20form%20published%20to%20the%20registration%20list%20and%20populates%20the%20form%20with%20the%20data%20from%20the%20current%20Class%20ID%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThis%20was%20a%20very%20easy%20solution%20on%20premise%20but%20it%20doesn't%20work%20at%20all%20in%20the%20cloud.%20the%20registration%20form%20opens%20empty.%20I'm%20not%20sure%20how%20I%20would%20do%20this%20in%20SharePoint%20online%20any%20suggestions%20would%20be%20great.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EKen%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1242692%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1243704%22%20slang%3D%22en-US%22%3ERe%3A%20Infopath%20not%20loading%20data%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1243704%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Ken%20(%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F415242%22%20target%3D%22_blank%22%3E%40sterbella%3C%2FA%3E)%26nbsp%3Bmy%20suggestion%20is%20to%20not%20to%20try%20to%20use%20Infopath%20at%20all%20as%20it's%20going%20to%20be%20retired%20and%20has%20been%20replaced%20by%20Power%20Apps%20which%20will%20enable%20you%20to%20achieve%20your%20requirements%20quite%20easily%20%26amp%3B%20quickly.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERob%3CBR%20%2F%3ELos%20Gallardos%3CBR%20%2F%3E%3CFONT%20size%3D%222%22%20color%3D%22%233366FF%22%3EMicrosoft%20Power%20Automate%20Community%20Super%20User%3C%2FFONT%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1244141%22%20slang%3D%22en-US%22%3ERe%3A%20Infopath%20not%20loading%20data%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1244141%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F174092%22%20target%3D%22_blank%22%3E%40Rob%20Elliott%3C%2FA%3E%26nbsp%3B%20I%20get%20it%2C%20and%20thats%20what%20we're%20doing%20for%20all%20net%20new%20requests%20but%20it's%20not%20something%20I%20want%20to%20do%20with%20every%20form%20on%20every%20site%20as%20they%20are%20migrated%20as%20that%20would%20just%20add%20to%20much%20time%20to%20the%20project.%20Also%2C%20we%20have%20many%20infopath%20forms%20publishing%20to%20xml%20forms%20libraries%20and%20for%20the%20more%20complicated%20data%20layouts%2C%20switching%20them%20to%20Power%20Apps%20is%20going%20to%20be%20an%20undertaking.%20What%20I'm%20trying%20to%20do%20is%20supported%20right%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EKen%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1244783%22%20slang%3D%22en-US%22%3ERe%3A%20Infopath%20not%20loading%20data%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1244783%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F415242%22%20target%3D%22_blank%22%3E%40sterbella%3C%2FA%3E%26nbsp%3BSorry%20I%20don't%20know%20the%20answer%20to%20that%2C%20I'm%20not%20an%20Infopath%20expert%20-%20we%20jumped%20straight%20to%20Power%20Apps.%20Hopefully%20someone%20else%20here%20will%20be%20able%20to%20help.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERob%3CBR%20%2F%3ELos%20Gallardos%3CBR%20%2F%3E%3CFONT%20size%3D%222%22%20color%3D%22%23003366%22%3EMicrosoft%20Power%20Automate%20Community%20Super%20User%3C%2FFONT%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Contributor

I am migrating a SP 2013 on premise site to the SP online. I have a class list and a registration list. To register for a class you select the class on the class list, it opens an infopath form with the class information. The form also contains a hyperlink derived from a calculated column in the class table.

 

=CONCATENATE("https://sp.mydomain.edu/tools/PAS/Lists/Registration/NewForm.aspx?Course=",[Class ID],"&Source=https://sp.mydomain.edu/tools/PAS")

 

So a normal link would look like this:

 

https://sp.mydomain.edu/tools/PAS/Lists/Registration/NewForm.aspx?Course =46&Source=https://sp.mydom...

 

As you see, it opens the infopath form published to the registration list and populates the form with the data from the current Class ID

 

This was a very easy solution on premise but it doesn't work at all in the cloud. the registration form opens empty. I'm not sure how I would do this in SharePoint online any suggestions would be great.

 

Ken

 

 

3 Replies
Highlighted

Hi Ken (@sterbella) my suggestion is to not to try to use Infopath at all as it's going to be retired and has been replaced by Power Apps which will enable you to achieve your requirements quite easily & quickly.

 

Rob
Los Gallardos
Microsoft Power Automate Community Super User

Highlighted

@Rob Elliott  I get it, and thats what we're doing for all net new requests but it's not something I want to do with every form on every site as they are migrated as that would just add to much time to the project. Also, we have many infopath forms publishing to xml forms libraries and for the more complicated data layouts, switching them to Power Apps is going to be an undertaking. What I'm trying to do is supported right?

 

Ken

Highlighted

@sterbella Sorry I don't know the answer to that, I'm not an Infopath expert - we jumped straight to Power Apps. Hopefully someone else here will be able to help.

 

Rob
Los Gallardos
Microsoft Power Automate Community Super User