web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Power Automate - Building Flows
Unanswered

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

(0) ShareShare
ReportReport
Posted on by 63

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)
  • v-bacao-msft Profile Picture
    on at
    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,

  • bbrazeau Profile Picture
    63 on at
    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 runDuration of a run

    There are 18k rows, each append is a blank row and a single string of about 50-75 chars

    item.png

     

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

     

    Details of loopDetails 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.

  • bbrazeau Profile Picture
    63 on at
    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?

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Chiara Carbone – Community Spotlight

We are honored to recognize Chiara Carbone as our Community Spotlight for November…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 655 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 371 Moderator

#3
chiaraalina Profile Picture

chiaraalina 276

Last 30 days Overall leaderboard