Power Automate - Power Automate Desktop

Problem with Power Automate Desktop latest versions 2.54.188.25066

Like (0) Share

Report

Posted on 28 Mar 2025 06:08:01 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:

Licensing

Process Advisor

All responses (4)

Answers (0)

HiteshChavda1086 4 on 28 Mar 2025 at 07:21:12

Like (0)

Report

Problem with Power Automate Desktop latest versions 2.54.188.25066

@ronaldwalcott yes, =CustomersalesCVExcelDatais accessing the table
ronaldwalcott 1,763 on 28 Mar 2025 at 06:56:49

Like (0)

Report

Problem with Power Automate Desktop latest versions 2.54.188.25066

Have you confirmed that CustomersalesCVExcelDatais accessing the table?
HiteshChavda1086 4 on 28 Mar 2025 at 06:52:41

Like (0)

Report

Problem with Power Automate Desktop latest versions 2.54.188.25066

@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.
Suggested answer

VishnuReddy1997 2,297 Super User 2025 Season 1 on 28 Mar 2025 at 06:19:06

Like (0)

Report

Problem with Power Automate Desktop latest versions 2.54.188.25066

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