Hi,
I am trying to retrieve users in site groups from a Sharepoint site. Firslty I am retrieving al the site groups through a HTTP request, put that output in a Parse Json, and then turning the names of the site group in a variable. Photo 1 shows the overall flow.
Photo 1: Complete flow
The following photo's show the four outputs from [apply to each - append to string variable]
Variable 1
Variable 2
Variable 3
Variable 4
If I would insert a HTTP request with the following URI: _api/web/sitegroups/getbyname('VarGroupName')/users I will get the following 4 outputs (with an error ofcourse):
_api/web/sitegroups/getbyname('Test 1')/users
_api/web/sitegroups/getbyname('Test 1Test Members')/users
_api/web/sitegroups/getbyname('Test 1Test MembersTest Owners')/users
_api/web/sitegroups/getbyname('Test 1Test MembersTest Owners Test Visitors')/users
Here is a photo of the 3rd result.
HTTP output 3
Now I know this is due to the Append to string variable input, but does anyone know how I can make sure that only one of each variable is filled in individually?
Thanks in advance!
when you do an append you should put a separator in.
So something like text1;text2;text3
Then in the in the apply to each feed is with
split(....)
where the ... is the variable that is set to text1;text2;text3
Now you will get 3 items
Text1 and text2 and text3
User | Count |
---|---|
89 | |
41 | |
23 | |
20 | |
16 |
User | Count |
---|---|
130 | |
51 | |
48 | |
36 | |
26 |