Unanswered

Using string variable with multiple outputs

(0) Share

Report

Posted on by Ls1

Hi,

I am currently working on a flow that retrieves users from sitegroups. Firstly, I used a HTTP request to get the sitegroups, used Parse JSON on that output and used the Title output to create a variable. Photo 1 shows the overall flow.

Photo 1

Since there are 4 site groups in this test site, these 4 variables are extracted.

Variable 1Variable 2Variable 3Variable 4

Now if I would insert a HTTP request in the apply to each using the Group name as a variable with URI: _api/web/getgroups/getbyname('VarGroupName')/users, I will get the following results.

_api/web/getgroups/getbyname('Test 1')/users

_api/web/getgroups/getbyname('Test 1Test Members')/users

_api/web/getgroups/getbyname('Test 1Test MembersTest Owners')/users

_api/web/getgroups/getbyname('Test 1Test MembersTest OwnersTest Visitors')/users

This photo shows the third result of above mentioned outputHTTP 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 one of each of these variables is used.

Thanks in advance

Categories:

Building flows

I have the same question (0)

All responses (7)

Answers (1)

Verified answer

MattWeston365 1,701 on at

Like (1)

Report

Re: Using string variable with multiple outputs

Hi @Ls1 if you use the "Set variable" action instead of the "Append" action then you will only get one value in the variable at any one time.

Was this reply helpful? Yes No
Ls1 18 on at

Like (0)

Report

Re: Using string variable with multiple outputs

Wow, I've tried that before, but it didn't work and now suddenly it works?

Thanks though!

Was this reply helpful? Yes No
Ls1 18 on at

Like (0)

Report

Re: Using string variable with multiple outputs

@MattWeston365

I works when I apply this to my test site (with 4 site groups), but when I try to replicate this flow to my actual site (100 site groups) it struggles. Any idea how I can still retrieve this big amount of data?
Actual site

Was this reply helpful? Yes No
MattWeston365 1,701 on at

Like (0)

Report

Re: Using string variable with multiple outputs

When you say it's struggling, is it purely the amount of time it takes to run? What you could try is setting the concurrency on the loop so that it's tackling multiple items in one go. If you click on the ellipsis in the top right of the "Apply to each" and click Settings you'll see an option called concurrency. Flick the toggle, and then you have have up to 50 parallel runs.

That may help you to reduce the run time of your Flow.

Was this reply helpful? Yes No
Ls1 18 on at

Like (0)

Report

Re: Using string variable with multiple outputs

@MattWeston365

Thanks! That solved one of the issues!

Now the weird part is that it doesn't recognize any variables, whilst it is the exact same flow as the test site flow.

Was this reply helpful? Yes No
Ls1 18 on at

Like (0)

Report

Re: Using string variable with multiple outputs

@MattWeston365

Tried to duplicate it again and now it works. Thanks for your help, you're a life saver!

Was this reply helpful? Yes No
MattWeston365 1,701 on at

Like (1)

Report

Re: Using string variable with multiple outputs

Haha the Force is with us 🙂 Have a good day

Was this reply helpful? Yes No