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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / doubts about variables
Power Automate
Unanswered

doubts about variables

(0) ShareShare
ReportReport
Posted on by 34

I have to store 100 different data in 100 variables, the variables have the same name and one more number, for example variable_1, variable_2, variable_3 up to 100, instead of having to put the 100 variables and assign a value to each one I can not do somehow in a loop that will change the number of the variable and assign me the value that touches me, for example:

 

Loop{

variable_[number of variable that increases by 1 in 1]

assign the value of that variable

}

 

so that I don't have to do it one by one.

 

Thank you very much

I have the same question (0)
  • MichaelAnnis Profile Picture
    5,727 Moderator on at

    Unfortunately, you cannot create variables after you have pressed "run".  I know it seems logical, but most automation languages have this in place as a control.

     

    The best workaround is to write all your variables to an Excel file, and then you can easily look them back up when you need them.

     

    Hope this helps,

     

    Mike  

  • momolopu Profile Picture
    34 on at

    can variable names be collected from an excel file, would it be valid?

  • MichaelAnnis Profile Picture
    5,727 Moderator on at

    You cannot create a variable from an excel data.  What you can do is list all the variables you want to reference in column A and list their values in column B.  Then, you have an input field in D1 and a vlookup field in E1 that finds the output value of the variable input into D1.

     

    Within the bot, the bot has free reign to create as many variables as it wants to, putting the variable in column A and the variable output in column B.  Any time the bot needs to call the variable, it can go out to Excel, write to D1, read from E1 and use that read to continue on.

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

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Valantis Profile Picture

Valantis 419

#2
Vish WR Profile Picture

Vish WR 314

#3
David_MA Profile Picture

David_MA 260 Super User 2026 Season 1

Last 30 days Overall leaderboard