First Item in For Each Loop

(0) Share

Report

Posted on by Tomka5050

Hello,

i have started to test Power Automate Desktop to fill out a web form based on an Excel spreadsheet.

I am trying to receive the data from cell A2 (the first item in the First Name column).

I have tried several syntaxes but none of them worked. You can find attached one of it.

I have also tried the following:

%CurrentItem['First Item']%

The flow copied it as text to the website.

I would like to understand how is it possible to iterate through a table in Power Automate Desktop.

Thank you in advance!

Tamás

Categories:

Power Automate Desktop

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Verified answer

Deenuji_Loganathan_ 6,255 Moderator on at

Like (1)

Report
Copy link

Link copied!

@tomka50501,

It appears you've established your flow using Power Fx, which is why this error is appearing. Please recreate your flow by disabling Power Fx. Your error should disappear automatically.

In case if you want to try in Power Fx way then below is the syntax for the same.
Code Syntax:
=CurrentItem.'Customer Name'

Thanks,
Deenu

-----------------------------------------------------------------------------------------------------------------------
If I have answered your question, please mark it as the preferred solution. If you like my response, please give it a Thumbs Up. Thank you.

Was this reply helpful? Yes No
WillSG 352 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi @tomka50501 I hope you are doing well.

Here below you will find the snipped code that hopefully will help you with the process that you want to automate.

When it comes to a For Each action, the output would be CurrenItem, however this Current item will contain all the information from the first row, then second row and so on.

So to get the First Name you don’t have to use %CurrentItem[First Name]%, you have to use %CurrentItem[0]%

Why Zero? Because zero is the first number from left to right, the assigned value to Zero is the First Name.

See the image below as well for reference.

Here is the snipped code:

SET ExcelFile TO $'''D:\\User\\wsanchez\\Course RPA\\First Item in For Each Loop\\TestData.xlsx'''
SET Website TO $'''http://enterhungary.gov.hu/eh/register'''
Excel.LaunchExcel.LaunchAndOpenUnderExistingProcess Path: ExcelFile Visible: True ReadOnly: False Instance=> ExcelInstance
Excel.ReadFromExcel.ReadCells Instance: ExcelInstance StartColumn: $'''A''' StartRow: 1 EndColumn: $'''E''' EndRow: 3 ReadAsText: False FirstLineIsHeader: True RangeValue=> ExcelData
Excel.CloseExcel.Close Instance: ExcelInstance
LOOP FOREACH CurrentItem IN ExcelData
Display.ShowMessageDialog.ShowMessage Message: $'''First Name: %CurrentItem[0]%
Last Name: %CurrentItem[1]%
Phone: %CurrentItem[2]%
Birtdate: %CurrentItem[3]%
Email: %CurrentItem[4]%''' Icon: Display.Icon.None Buttons: Display.Buttons.OK DefaultButton: Display.DefaultButton.Button1 IsTopMost: True ButtonPressed=> ButtonPressed
END

Please let me know if it works, happy automation!,

If I have addressed your inquiry successfully, kindly consider marking my response as the preferred solution. If you found my assistance helpful, a 'Thumbs Up' would be greatly appreciated.

Additionally, I offer specialized consultancy and development services leveraging PAD. If you're interested in exploring these services further, feel free to DM me, and we can initiate a discussion.

Kind regards,

Will SG
Managing Director & Automation Lead
RAMS CR (Recruitment & Automation)
LinkedIn Profile

Was this reply helpful? Yes No
MichaelAnnis 5,727 Moderator on at

Like (0)

Report
Copy link

Link copied!

You can use indexes, starting with 0 or you can use the title row in parenthesis.

[0] = ['First Name']

You had 'First Item' which doesn't exist.

Was this reply helpful? Yes No