Unanswered

ResponseSwaggerSchemaValidationFailure and multi-selection issue with SharePoint OnPrem

(0) Share

Report

Posted on by kehlerm13

Good morning,

we created a flow, that is triggerd manually and after that it should get the information from required Shearpoint-List-Column named "Members" (type Person or Group) which runs on a Sharepoint-Server onPrem.

If we run the flow we get the following Error:

ResponseSwaggerSchemaValidationFailure

The sharepointonline API returned an invalid response for the OpenApiConnection workflow operation "Get_elements_2". Error details: "The GetItems API operation requires the body / value / 0 / Members property to be of type Object, but it is of type Null."

For testing we changed the required setting of the column to optional. Than the flow run through but did not return the informationen of the multi-selection colum "Members". It only returns all other information - also a informatione from type Person or Group, which has not multi-selection enabled.

We also tried it with the trigger "If a element is created or edited". Here we also get all information except the "Members".

We also tried it with ShaprePoint 365. Here we can get the required information.

But for our requirement we need to get the information of a required, multi-selected Colum on a onPrem SharePoint-List.

Do you have any ideas?

Categories:

Building flows

I have the same question (0)

All responses (8)

Answers (0)

henkenTech 135 on at

Like (0)

Report

Hey there - this sounds a lot like you are trying to retrieve too many complex columns at once.

The connector can only retrieve between 8 and 12 complex columns at once, depending on your SP version. Columns outside of the limit simply get ignored. A complex column is any column that looks up information somewhere else. A person column is one such type (more info). Also note that the system generated columns, such as Created, Created by, etc. all count as well.

To circumvent this issue, create a separate view that only shows the columns you need to work with (max. 12 complex columns). In your "Elemente abrufen" action, you can then select this view to retrieve these columns only and stay within the limit:

In my example, I created a view called "Processing Columns view" to work with a certain set of columns.

Hope this helps. If this is not your issue, please let me know and we can see what else might be amiss.

Max

Was this reply helpful? Yes No
kehlerm13 8 on at

Like (0)

Report

Hi Max,

thank you very much for your detailed answer.

Marcel

We will try your solution but i do not think that this will be the problem because we do only have 2 complex DataTypes in our List. The other DataType is a Person or Group as well but without multi-selection. If the flow runs successfully we get the information from that column.

I will try your solution and get back to you.

Do you maybe have some other ideas?

Was this reply helpful? Yes No
henkenTech 135 on at

Like (0)

Report

Hi again,

I mean I guess you have tried the usual suspects of deleting the action and adding it again? The swagger configuration is added to the action when you select the list to get the items from, so the 'required' option is set in the schema also at that time. Also, if that doesnt work, can you create another new optional multi-person column and check if it retrieves that?

Max

Was this reply helpful? Yes No
kehlerm13 8 on at

Like (0)

Report

Hi Max,

we tested your solution but it didn't work. We get the error, that views are not supportet when using this with the On-Premis Data Gateway.

So we got the similar behaviour:
Multi-selection Colum "Members" is set to require --> Flow fails
Multi-selection Colum "Members" is set to optional --> Flow runs trough but does not return the "Members"
Single-seleciton Colum "Members" is set to optional --> Flow returns one Person as an Object

From my perspektive it looks like a "Parse Object into Array" Problem? What do you think about that? Can you confirm, that it is possible to get multiple "Person or Group" as an Array?

Do you maybe have some additional ideas?

Thanks in advice.

Marcel

edit:
The translation of the german error message is: "Cannot get values. The request for dynamic calls failed" - Sorry for that 😉

Was this reply helpful? Yes No
henkenTech 135 on at

Like (0)

Report

Hi Marcel - kein Problem, ich spreche auch ein bisschen deutsch 😊

It is definitely possible to retrieve multi-select person columns and they are returned as an array by default. So don't think that's the issue. Let me see if I can think of another reason.

Just to make sure we are on the same page: The swagger validation error is no doubt the result of having a column set to mandatory and having items that have nothing in it somewhere (they are null). The issue we are looking at now is why the columns is not returned when you make it not mandatory. One last question: Does the body not contain the column key at all, or is the value a blank array?

Max

Was this reply helpful? Yes No
kehlerm13 8 on at

Like (0)

Report

Hi Max - du sprichst schon sehr gut deutsch 🙂

It is good to hear, that it is possible to retrieve multi-selectet person colums. I've read a few articles where they said, that it is not supported.

Correct. I havn't found the empty values yet but i am looking for that again. Is there a possibility to get an id which item cause the problem. I thought about the ID in the error-message "body/value/0/Members" but i couldn't find a item with the id 0. They starts with 1.

Second issue is the more important one. If the flow runs through i get the following response (one item of it).

There is no colum "Members". If i enable multi-selection for the "Right_owner", which is from type "Person or Group" as well, it also disapear from the result.

Would be great if you can help me.

Was this reply helpful? Yes No
henkenTech 135 on at

Like (0)

Report

Hi Marcel,
Regarding the 'id': in an array, the first item is always item 0, that's why it says [0]. But this has nothing to do with the Id of the item in the SP list.

Could you share some links where you read that it is not supported? Would just be interested if I am missing something. I just tried it with an on premise SP and didn't have any issues, but maybe your setup is different to mine.

Max

Was this reply helpful? Yes No
kehlerm13 8 on at

Like (0)

Report

Hi Max,

thank you for your answer. Ok. I thought, that it is the first entry in the complete body but your explanation makes more sense. Thanks for that. I will have a look for the wrong item.

Here is the article. This is a bit different to our solution because we do not have a coice-field. But i thought that the problem will maybe be the same?
https://powerusers.microsoft.com/t5/Building-Flows/Sharepoint-Choice-Field-with-multiple-selections-or-pick-list/td-p/43298

Marcel

Was this reply helpful? Yes No