Unanswered

Best way to build a string (Looping through results)?

(0) Share

Report

Posted on by bbrazeau

Current process is:

Get dataset which contains a few hundred entites.

Loop over each record in dataset
 Set VariableTemp = OutputVariable
 Set OutputVariable = concatentate(VariableTemp, "<br />", PropertyX)

Write OutputVariable to file

Problem is, the above method takes a long time. I have a 600 record dataset and processing takes 6 minutes to run the loop step. Another process does the same 2 step loop runs through 18,000 records and takes over 2 hours.

If there is a better way to build a string please let me know. The current method works, but I'd prefer to do something much less resource intensive.

I have the same question (0)

All responses (3)

Answers (0)

v-bacao-msft on at

Like (0)

Report

Re: Best way to build a string (Looping through results)?

Hi @bbrazeau ,

The process you describe seems to be a relatively straightforward method and there are no extra steps.

You could share screenshots of Flow configuration, including some details, and maybe we can try to optimize this process.

Best Regards,

Was this reply helpful? Yes No
bbrazeau 63 on at

Like (0)

Report

Re: Best way to build a string (Looping through results)?

Here are some screen shots - I can provide more if you like. This particual one isn't quite the same as another I was looking at, but it is behaving much worse so here goes.

A scope contains the loop that is taking quite a long time.
Duration of a run
There are 18k rows, each append is a blank row and a single string of about 50-75 chars

The Flow step - I included the hover overs so you can see the actual text.

Details of loop

Let me know if there is anything else I can provide. I can spin up a copy (that doesn't send files) if you have ideas to test.

Was this reply helpful? Yes No
bbrazeau 63 on at

Like (0)

Report

Re: Best way to build a string (Looping through results)?

Hi @v-bacao-msft , not sure if you saw the reply. Still having poor performance when looping over a result set and building output.

Any other info I can get?

Was this reply helpful? Yes No