The field is not supported in a query , the lookup list is in another web

%3CLINGO-SUB%20id%3D%22lingo-sub-140770%22%20slang%3D%22en-US%22%3EThe%20field%20is%20not%20supported%20in%20a%20query%20%2C%20the%20lookup%20list%20is%20in%20another%20web%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-140770%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%0A%3CP%3EI%20have%20a%20site%20collection%20used%20to%20collect%20information%20for%20external%20reporting.%20Each%20quarter%20I%20create%20a%20new%20subsite.%20The%20subsite%20has%20lists%20with%20%26nbsp%3Blookup%20columns%20pointing%20to%20lists%26nbsp%3Bin%20the%20rootweb.%20I%20cannot%20use%20powerapps%20on%20these%26nbsp%3B%20lists.%20I%20get%20an%20error%26nbsp%3B%20The%20field%20is%20not%20supported%20in%20a%20query%20%2C%20the%20lookup%20list%20is%20in%20another%20web.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIs%20this%20on%20the%20radar%20somewhere%3F%20Would%20really%20like%20to%20try%20powerapps!%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EFor%20now%20I'd%20be%20fine%20with%20just%20removing%20those%20lookup%20column%20from%20the%20app.%20is%20that%20possible%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-140770%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EPowerApps%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Frequent Contributor

Hi,

I have a site collection used to collect information for external reporting. Each quarter I create a new subsite. The subsite has lists with  lookup columns pointing to lists in the rootweb. I cannot use powerapps on these  lists. I get an error  The field is not supported in a query , the lookup list is in another web.

 

Is this on the radar somewhere? Would really like to try powerapps!

 

For now I'd be fine with just removing those lookup column from the app. is that possible?

0 Replies