SOLVED

Problem triggering on a on-premise list that has a lookup field

%3CLINGO-SUB%20id%3D%22lingo-sub-1735913%22%20slang%3D%22en-US%22%3EProblem%20triggering%20on%20a%20on-premise%20list%20that%20has%20a%20lookup%20field%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1735913%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20on-premise%20SharePoint%20site%20and%20am%20trying%20to%20migrate%20my%20Sharepoint%20Designer%202010%20Workflow%20to%20Microsoft%20Power%20Automate%20and%20am%20encountering%20a%20problem%20on%20the%20trigger.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20list%20has%20a%20lookup%20field%20called%20LogID%20that%20is%20a%20lookup%20to%20another%20list%20on%20my%20site.%26nbsp%3B%20%26nbsp%3BWhen%20the%20Flow%20triggers%2C%20I%20get%20an%20error%20%22Could%20not%20retrieve%20values.%26nbsp%3B%20The%20dynamic%20invocation%20request%20failed%20with%20error%3A%20%7B%22Message%22%3A%22Views%20are%20not%20supported%20when%20using%20this%20with%20the%20On-Premises%20Data%20Gateway%22%7D%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20detailed%20error%20message%20says%3A%3C%2FP%3E%3CP%3E%7B%22status%22%3A%20400%2C%20%22message%22%3A%20%22The%20field%20'LogID'%20is%20not%20supported%20in%20query.%26nbsp%3B%20The%20lookup%20list%20does%20not%20exist%22%7D%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Screenshot%202020-10-01%20094440.png%22%20style%3D%22width%3A%20611px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F223398i0922DAC66F6DB245%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22Screenshot%202020-10-01%20094440.png%22%20alt%3D%22Screenshot%202020-10-01%20094440.png%22%20%2F%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Screenshot%202020-10-01%20094511.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F223399i6F2C4C0F713A53A7%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22Screenshot%202020-10-01%20094511.png%22%20alt%3D%22Screenshot%202020-10-01%20094511.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1735913%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EMicrosoft%20Flow%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EPowerApps%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1743727%22%20slang%3D%22de-DE%22%3ESubject%3A%20Problem%20triggering%20on%20an%20on-premise%20list%20that%20has%20a%20lookup%20field%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1743727%22%20slang%3D%22de-DE%22%3E%3CP%3EHey%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F563488%22%20target%3D%22_blank%22%3E%40eshen31%2C%3C%2FA%3E%20so%20what's%20your%20question%3F%20I%20guess%2C%20your%20LogID%20is%20the%20main%20error%20on%20this%20view%20issue.%20Can%20you%20trigger%20the%20flow%20without%20a%20certain%20view%3F%20Greets%2C%20Eva.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1746142%22%20slang%3D%22en-US%22%3EBetreff%3A%20Problem%20triggering%20on%20a%20on-premise%20list%20that%20has%20a%20lookup%20field%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1746142%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F153902%22%20target%3D%22_blank%22%3E%40Eva%20Vogel%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMy%20initial%20concern%20was%20that%20Power%20Automate%20Flow%20had%20problems%20triggering%20on%20a%20SharePoint%20list%20that%20had%20a%20lookup%20to%20another%20list%20using%20a%20Data%20Gateway%20to%20an%20on-premise%20site.%26nbsp%3B%20I%20was%20asking%20if%20others%20had%20seen%20the%20problem.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHowever%2C%20I%20was%20able%20to%20successfully%20create%20a%20Power%20Automate%20Flow%20to%20trigger%20on%20a%20list%20with%20a%20lookup%20using%20a%20Data%20Gateway%20for%20a%20different%20on-premise%20SharePoint%20site.%26nbsp%3B%20So%20I%20suspect%20the%20account%20associated%20with%20the%20problematic%20Data%20Gateway%20does%20not%20have%20permissions%20to%20access%20the%20SharePoint%20list%20that%20is%20being%20looked%20up.%26nbsp%3B%20%26nbsp%3BI'm%20working%20a%20client%20who%20is%20the%20one%20that%20created%20the%20Power%20Automate%20Flow%20so%20I%20need%20to%20hear%20back%20from%20her%20if%20it%20is%20indeed%20a%20permission%20problem.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Contributor

I have a on-premise SharePoint site and am trying to migrate my Sharepoint Designer 2010 Workflow to Microsoft Power Automate and am encountering a problem on the trigger.  

 

The list has a lookup field called LogID that is a lookup to another list on my site.   When the Flow triggers, I get an error "Could not retrieve values.  The dynamic invocation request failed with error: {"Message":"Views are not supported when using this with the On-Premises Data Gateway"}

 

The detailed error message says:

{"status": 400, "message": "The field 'LogID' is not supported in query.  The lookup list does not exist"}

 

Screenshot 2020-10-01 094440.pngScreenshot 2020-10-01 094511.png

5 Replies
Highlighted

Hey @eshen31 , so whats your question? I guess, your LogID is the main error on this view issue. Can you trigger the flow without a certain view? Greets, Eva.

Highlighted

@Eva Vogel 

My initial concern was that Power Automate Flow had problems triggering on a SharePoint list that had a lookup to another list using a Data Gateway to an on-premise site.  I was asking if others had seen the problem.

 

However, I was able to successfully create a Power Automate Flow to trigger on a list with a lookup using a Data Gateway for a different on-premise SharePoint site.  So I suspect the account associated with the problematic Data Gateway does not have permissions to access the SharePoint list that is being looked up.   I'm working a client who is the one that created the Power Automate Flow so I need to hear back from her if it is indeed a permission problem.

 

Highlighted

Hello @eshen31 ,

if there is a permission problem and you are the author of the flow and of the SharePoint List, you can work with 2 other actions in cooperation: 

1) stop sharing  - this action deletes all permissions

2) grant access - this action sets the combination of permissions you would like to install.

 

This is a perfect way to deal with inconsistent sharing situations with lists and libraries, when it is unclear who actually gets what to see...

If it works, give a LIKE,

 

Greets, Eva.

Highlighted
Thanks for the advice. Once my client confirms it's a permission problem, I'll have her grant access. It was intentional to have the lookup list have unique permissions. There is information there that they only wanted a subset of users to have access.
Highlighted
Best Response confirmed by eshen31 (Occasional Contributor)
Solution
I confirmed it was a permission issue. Once I gave the account used for the gateway permission was given permission to the lookup list, the flow worked.