web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate Excel Variable

Power Automate

Suggested Answer

Excel Variable

(1) Share

Report

Report

Posted on by FC-06081904-0

2

After counting the rows in an Excel file, cell C2 contains the total. How can I turn this into a variable for a for each loop? Thanks!

Categories:

Power Automate Desktop

All responses Img

All responses (2)

Answers Img

Answers (0)

Sort by

Suggested answer

CU16071609-1 6,255 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
Hi FC-06081904-0,

You can read the C2 value using "Read from Excel" action and assign into variable then you can use that variable in the for each loop.

Flow screenshot:

PAD code(Copy and paste the below code into your power automate desktop flows):
Excel.LaunchExcel.LaunchAndOpenUnderExistingProcess Path: $'''C:\\Deenu\\Book1.xlsx''' Visible: True ReadOnly: False Instance=> ExcelInstance Excel.ReadFromExcel.ReadNamedCell Instance: ExcelInstance CellName: $'''C2''' ReadAsText: False TrimEmptyCells: False RangeValue=> ExcelData SET TotalRows TO ExcelData[0][0]

Thanks,

Deenu
Suggested answer

mathiaskjeldsen 224 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi

Automating Excel tasks are quite heavily supported in Power Automate Desktop. You're situation would require you to assign the cell to a variable by using Set Variable action. If you need a visual representation of it, I've done something quite similar here: Automate Excel finance tasks with Power Automate Desktop.

Best regards

Mathias Kjeldsen

---
If this has helped solve your problem, please mark it as an helpful answer.

Connect with me on social platforms by using the links below.
YouTube: https://www.youtube.com/@matkjeldsen
LinkedIn: https://www.linkedin.com/in/mathiaskjeldsen/

Join the conversation