Problem with Power Automate Desktop latest versions 2.54.188.25066

(0) Share

Report

Posted on by HiteshChavda1086

In an older version, I used the following method to get and filter data from a table:

%CustomersalesCVExcelData[GLCodeLoopRowNumber][3]%

Where:

Table: CustomersalesCVExcelData

Row: GLCodeLoopRowNumber

Column: 3

I then concatenated three values into one variable using the following format:

%CustomersalesCVExcelData[GLCodeLoopRowNumber][3] + CustomersalesCVExcelData[GLCodeLoopRowNumber][15] + CustomersalesCVExcelData[GLCodeLoopRowNumber][16]%

However, in the new version of Power Automate Desktop, when I try to run this logic, the values are not being returned correctly, and I’m getting no output.

I have tried using the same syntax, but it's not producing any result.

Error/Issue: I am not receiving any values as expected.

My question is: How can I write this in the new version of Power Automate Desktop?

Categories:

Power Automate Desktop

I have the same question (0)

All responses (4)

Answers (1)

Verified answer

VishnuReddy1997 2,656 Super User 2025 Season 2 on at

Like (1)

Report

Hi @CU05091604-0,

Alternative: Using Looping and Variables

------------------------------------------------------
If needed, you can also loop through CustomersalesCVExcelData and extract values dynamically using

For Each:

Use For Each loop to iterate through CustomersalesCVExcelData.

Inside the loop:

Extract row: CurrentRow = %CurrentItem%

Get values: Value1 = %CurrentRow[3]%, Value2 = %CurrentRow[15]%, Value3 = %CurrentRow[16]%

Concatenate: FinalString = %Value1 & Value2 & Value3%

(Note:- if you got your solution you can mark as solution and gives kudos)

Thanks & Regards
Vishnu Reddy

Was this reply helpful? Yes No
HiteshChavda1086 7 on at

Like (0)

Report

@VishnuReddy1997 thank you for your response. However, I need to know how to write this using the latest method.
Yes, I am using a loop, but it’s not working.

Was this reply helpful? Yes No
ronaldwalcott 3,847 Super User 2025 Season 2 on at

Like (0)

Report

Have you confirmed that CustomersalesCVExcelDatais accessing the table?

Was this reply helpful? Yes No
HiteshChavda1086 7 on at

Like (0)

Report

@ronaldwalcott yes, =CustomersalesCVExcelDatais accessing the table

Was this reply helpful? Yes No