Power Platform Community Forum Thread Details

Hi guys,

I trying to create an automation to fill the web form using the data from excel but encountering an error, here's my setups:

Step 1: Launch Chrome

Launch mode: Launch new Instance

Variables produced: %Browser%

Step 2: Launch Excel (Open the from existing document)

Variables produced: %ExcelInstance%

Step 3: Read from Excel worksheet

I have turned on : Get cell contents as text

Variables produced: %ExcelData%

My Data Table look something like this: https://archive.org/embed/snag-57ef-805

Step 4: Focus text field

I just picked from the UI element position where I want my data to be filled

Step 5: Populate text field on web page

UI element: Im using the UI element from step 4

Text: %ExcelData['Column1']%

When I ran the automation I got this error: VariableExcelData' doesn't have a property 'Column1'

My ExcelData table is fine, and Column1 shows the data that I want to fill on the web.

How can I fix this?

Any suggestion is much appreciated

Categories:

This is driving me crazy - Web Filling from Excel (Power Automate Desktop)