Answered

Update Data Table Item - Row Index

(0) Share

Report

Posted on by hum313

I have a flow where I am loading an excel spreadsheet into a data table variable %ExcelData%. There are a total of 15 columns with the last one containing empty cells. In my flow, I have If/Else conditions in place where based on an image or lack of image, an action is taken. Specifically, for the Else, for the %CurrentItem% I want to write to the data table in the empty Column. I have been getting stuck on the syntax for the row index so it is writing to the data table for the current item in the specified column. I've tried a couple different things but get the error for row index should be an integer.

Categories:

Power Automate Desktop

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Verified answer

CU16071609-1 6,255 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
@hum313

You can follow the below approach:

Guide:
Step 1: Launch Excel and Open a Specific File
Launch Excel and open the file EmpDetails.xlsx located in C:\Boot\.
Step 2: Read All Cells from the Excel File
Read all the data from the Excel file into a variable called ExcelData.
Step 3: Initialize a Counter
Set a counter variable to 0.
Step 4: Loop Through Each Item in the Excel Data
Loop through each row in the ExcelData.
Step 5: Check for Empty Cells in the First Column
If the cell in the first column (column A) of the current row is empty, update it with the value Already Acquired.
Step 6: Increment the Counter
Increment the counter by 1.

Code:

Excel.LaunchExcel.LaunchAndOpenUnderExistingProcess Path: $'''C:\\Boot\\EmpDetails.xlsx''' Visible: True ReadOnly: False Instance=> ExcelInstance Excel.ReadFromExcel.ReadAllCells Instance: ExcelInstance ReadAsText: False FirstLineIsHeader: False RangeValue=> ExcelData SET Counter TO 0 LOOP FOREACH CurrentItem IN ExcelData IF IsEmpty(CurrentItem[0]) THEN Variables.ModifyDataTableItem DataTable: ExcelData ColumnNameOrIndex: $'''A''' RowIndex: Counter Value: $'''Already Acquired''' END SET Counter TO Counter + 1 END

How to copy/paste the above code into your power automate desktop?

Thanks,
Deenuji Loganathan 👩‍💻
Automation Evangelist 🤖
Follow me on LinkedIn 👥

-------------------------------------------------------------------------------------------------------------
If I've helped solve your query, kindly mark my response as the solution ✔ and give it a thumbs up!👍 Your feedback supports future seekers 🚀

Was this reply helpful? Yes No
hum313 8 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you for the input! That's not exactly how this will work so i'm not sure how to apply it for what I need, my apologies.

In column O for each item, depending on the If/Else condition for an Image, there will be one of three entries made in the cell. Once I can get this one sorted out, i'll be able to get the other two in place.

High level, If an image exists, there will be a set of steps to take within the flow....else update the data table item in Column O with the provided value, click a button, and move on to the next item in the data table and go through the flow again.

Was this reply helpful? Yes No
hum313 8 on at

Like
a
(0)

Report
Copy link

Link copied!

I was able to resolve it using what you provided so thank you!

Was this reply helpful? Yes No