Power Automate Desktop doesn't directly support accessing specific cell ranges like "columns 7-9" in a single action. You'll need to iterate through the columns you want. Here's how you can achieve this using a loop:
Method: Using a For Each Row loop and conditional logic within.
Get Table Data: First, use the "Get Table Data" action to retrieve all the data from your table into a variable (let's call it tableData).
For Each Row: Use the "For Each Row" loop to iterate through each row of the tableData.
Check Row Number: Inside the loop, use a "Condition" action to check if the current row number is 84. You can access the row number using the Row Number dynamic content within the loop.
Get Cell Values (if Row 84): If the condition (row number equals 84) is true, then use three separate "Get Cell Value" actions to retrieve the values from columns 7, 8, and 9. For each action:
tableData variable.Row Number dynamic content (which will be 84).column7Value, column8Value, column9Value).Combine Values (Optional): If you need to combine these three values into a single string, you can use a "Compose" action to concatenate them as needed (e.g., column7Value & ", " & column8Value & ", " & column9Value).
Power Automate Desktop Flow (Conceptual):
[Get Table Data] ---> tableData
|
V
[For Each Row in tableData]
|
V
[Condition: Row Number equals 84]
|----True----> [Get Cell Value (Row: Row Number, Column: 7)] ---> column7Value
| |
| V
| [Get Cell Value (Row: Row Number, Column: 8)] ---> column8Value
| |
| V
| [Get Cell Value (Row: Row Number, Column: 9)] ---> column9Value
| |
| V (Optional)
| [Compose: column7Value & ", " & column8Value & ", " & column9Value] ---> combinedValue
|----False----> (Continue to the next row)
Remember to replace placeholders like tableData, column7Value, column8Value, column9Value, and combinedValue with your actual variable names. This method ensures you only process row 84 and efficiently extracts the data you need without unnecessary iterations.