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 / how to add values pres...
Power Automate
Unanswered

how to add values present in excel using power automation

(0) ShareShare
ReportReport
Posted on by 4

Hi all,

 

I have an excel file in the source folder which contains numbers from 1 to 100 I want to add those numbers and save the output to another excel file present in the destination folder by using power automation can it be possible?

 

Categories:
I have the same question (0)
  • Sundeep_Malik Profile Picture
    6,501 on at

    Hey @Khalifa009 

    Yes this is possible in power automate. Before dealing with excel in power automate, just make the data in excel as tables. Click on the 1st cell of the excel sheet and click on format as table.

    Sundeep_Malik_0-1665557239728.png

    After this, go to power automate. Give a trigger of your choice, instant or recurrence your choice.

    Then create a integer variable. Then use list rows in a table.

    Sundeep_Malik_1-1665557365306.png

     

    After this use apply to each action and pass the values you are getting from above action.

    Then use increment variable action and in the value add the following formula: 

    int(items('Apply_to_each')?['ColumnName'])

    In column name add the the name of your column which has all the numbers.

     

    Sundeep_Malik_2-1665557445667.png

    After this you can use add a row into table action or update a row action to save the added value in the new excel sheet.

     

    Sundeep_Malik_3-1665557578085.png

     

    Or

     

    Sundeep_Malik_4-1665557600480.png

     

     

  • Khalifa009 Profile Picture
    4 on at

    Hi @Sundeep_Malik 

     

    I have tried your flow but not getting output to my new excel file

     

    error.PNGerror1.PNG

  • Sundeep_Malik Profile Picture
    6,501 on at

    @Khalifa009 

    Did you make a column in the 2nd excel sheet??

    You will have to make a column first, then make it a table. 

    After that when you add the action, you will see that column and in that pass the value of the variable.

  • Khalifa009 Profile Picture
    4 on at

    Hi @Sundeep_Malik 

     

    Thanks for the help got the proper output but I want to ask if I can perform the same on the XLSM macro file.

  • Sundeep_Malik Profile Picture
    6,501 on at

    @takolota 

    Is the above possible?

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 Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
11manish Profile Picture

11manish 233

#2
David_MA Profile Picture

David_MA 217 Super User 2026 Season 1

#3
Valantis Profile Picture

Valantis 190

Last 30 days Overall leaderboard