Problem with Sharepoint GetItems

(0) Share

Report

Posted on by zerberos1985ke

Hello,

I want to use the Sharepoint GetItems-Connector.

Now, when I select a Shraepoint list, I get the following error message:

Failed to retrieve dynamic outputs. As a result, this operation's outputs might not be visible in subsequent actions. Error details: The dynamic operation request to API 'sharepointonline' operation 'GetTable' failed with status code 'BadRequest'. This may indicate invalid input parameters. Error response: { "status": 400, "message": "The required field \"XXXX\" data type is not supported\r\nclientRequestId: de6c89c9-5468-4d66-84e2-af687d54a161\r\nserviceRequestId: de6c89c9-5468-4d66-84e2-af687d54a161" }

The Field XXX is a Lookup Column.

All responses (3)

Answers (0)

v-yetonggu-msft on at

Like (0)

Report

Re: Problem with Sharepoint GetItems

Hi @zerberos1985ke ,

1)Please switch to classic designer.

2)Click 'Enter custom value'.

3)Enter the name manually.

Best Regards,

Sunshine Gu
zerberos1985ke 2 on at

Like (0)

Report

Re: Problem with Sharepoint GetItems

The message appears as soon as I select the list:
v-yetonggu-msft on at

Like (0)

Report
Re: Problem with Sharepoint GetItems

Hi @zerberos1985ke ,

About the method of filtering the 'lookup' column in the 'Get items' control.

I did a test for your reference.

In my scenario:

My SharePoint List1:

My SharePoint List2:

My Flow:

lookupcolumnname/referencecolumnname eq ''

Best Regards,

Sunshine Gu