cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Ls1
Level: Powered On

One string variable with multipe values

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.

FOTO.JPGPhoto 1: Complete flow

The following photo's show the four outputs from [apply to each - append to string variable]

output 1.JPGVariable 1Ouptut 2.JPGVariable 2Output 3.JPGVariable 3Test 4.JPGVariable 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 3.JPGHTTP 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!

 

1 REPLY 1
Super User
Super User

Re: One string variable with multipe values

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

Helpful resources

Announcements
firstImage

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

firstImage

Coming Soon: T-shirt Design Contest

Keep your eyes open for our upcoming T-shirt design contest!

firstImage

Incoming: New and improved badges!

Look out for new contribution recognition badges coming SOON!

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Top Solution Authors
Top Kudoed Authors
Users online (5,819)