Unanswered

"Variable 'ExcelData' doesn't have a property 'Column1'.

(0) Share

Report

Posted on by jfkbbb

Hey everyone,

I am trying to learn how to fill out online forms using Excel data. I've received this error message and can't figure out how to fix it.

Any ideas? Thank you!

Categories:

Power Automate Desktop

I have the same question (0)

All responses (14)

Answers (0)

Sort by

fraenK 2,125 on at

Like (0)

Report
Copy link

Link copied!

What's the error message?

Was this reply helpful? Yes No
jfkbbb 6 on at

Like (0)

Report
Copy link

Link copied!

Hello.

the message is: "Variable 'ExcelData' doesn't have a property 'Column1'.

Was this reply helpful? Yes No
fraenK 2,125 on at

Like (0)

Report
Copy link

Link copied!

Do you have a table column with that name/header in your Excel file? Has your Excel file/table headers?

Was this reply helpful? Yes No
jfkbbb 6 on at

Like (0)

Report
Copy link

Link copied!

I do not. I do have a column name “Title”, which I also tried and it did not work. Am I suppose to set some kind of variable?

Was this reply helpful? Yes No
fraenK 2,125 on at

Like (2)

Report
Copy link

Link copied!

Did you enable headers in the Read from Excel action?

Was this reply helpful? Yes No
burque505 398 on at

Like (2)

Report
Copy link

Link copied!

@jfkbbb, just for clarity you should see a screen like this when you extract values from a range of cells. The screenshot shows what @fraenK is referring to, I believe (i.e., first row has column names).

Was this reply helpful? Yes No
jfkbbb 6 on at

Like (0)

Report
Copy link

Link copied!

^^^Yeah, that setting is enabled. I am honestly not sure what's causing the error.

Was this reply helpful? Yes No
fraenK 2,125 on at

Like (1)

Report
Copy link

Link copied!

You should be able to see the content of the current item data row variable in the variable panel on the right during execution

Was this reply helpful? Yes No
ramiix 2 on at

Like (0)

Report
Copy link

Link copied!

I'm also facing the same issue any one from the team please fix this issue . I was trying to copy file from one location to another using excel but I could not loop through two lists.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (2)

Report
Copy link

Link copied!

Hello @ramiix

What kind of problem is happening to you?

Use the following format to refer to specific element in a Datatable:
%Datatable[RowIndex][ColumnIndex]%
%Datatable[RowIndex]['ColumnName']%

For example,
%ExcelData[2][0]%
%ExcelData[2]['Column1']%

Was this reply helpful? Yes No