Unanswered

Trying to add a user to the existing SharePoint group using "Send an HTTP request" and "Parse JSON" actions and getting an error on the next step

(0) Share

Report

Posted on by allnn

I can see that flow successfuly gets the group information I need and parses it. But when I try to use a group ID in the next "POST" Step, I get the following error:
"The execution of template action 'Apply_to_each' failed: the result of the evaluation of 'foreach' expression '@body('Parse_JSON')?['results']' is of type 'Null'. The result must be a valid array."

The code for getting my SP Group information looks like this (below) and I can see it gets data from the parsing and "results" are not empty at all:
----------------------------------------------------------------------------------
{
"d": {
"results": [
{
"__metadata": {
"id": "https://xxx.sharepoint.com/sites/XYZ-EquipmentReservation/_api/Web/SiteGroups/GetById(60)",
"uri": "https://xxx.sharepoint.com/sites/XYZ-EquipmentReservation/_api/Web/SiteGroups/GetById(60)",
"type": "SP.Group"
},
"Id": 60
}
]
}
}

------------------------------------------------

Any ideas or if anyone resolved something similar?

Thank you!

Natalie

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (0)

fchopo 8,003 Moderator on at

Like (0)

Report

Hi @allnn

As I understand, you want to add a user to an existing SharePoint group. First, you get the group information, and what do you do after? Could you share a screenshot of the flow so we can help you?

Regards,

Ferran

Was this reply helpful? Yes No
allnn 4 on at

Like (0)

Report

HI fchopo,

Thank you for getting back to me! The error happens when I try to use the group information in the next step after the "Parse":

Was this reply helpful? Yes No
fchopo 8,003 Moderator on at

Like (0)

Report
Hi @allnn

As the results variable is an array, Power Automate add automatically the apply to each action. In order to access to the id value (to use in the Send HTTP Request) you could use the following expression:

first(body('Parse_JSON')?['results'])?['id']

which reads the first element of the array, and access to the id field. In this way, you can remove the apply-to-each, and use only the "Send HTTP..." using this expression in the ID field value.

Hope it helps!

Ferran

Was this reply helpful? Yes No
allnn 4 on at

Like (0)

Report

Hi fcholo,

Thank you for you suggestion and it looks really on a right way, but unfortunately it didn't work for me. For some reason script things that the 'result' package = 'Null', even though I can see, that it is not. Here is a screenshot with an error and a Parse output:

Was this reply helpful? Yes No