Answered

Getting Error 'Column or property not found'

(0) Share

Report

Posted on by R-Der

I have an excel file where two cells are merged row-wise and acts as a column title. This column has only 0s and 1s as row values. I am trying PAD to identify if the cell value is '0' and delete the complete row if true.

I have tested it on a simple excel file and the flow that I have works on it.

2021-09-10 (1).png 2021-09-10 (2).png

However, with the actual file, it's not working as the title is a merged cell, I'm getting the 'Column or property 'ColumnTitle' not found' error. WhatsApp Image 2021-09-10 at 01.39.06.jpeg

Categories:

Power Automate Desktop

I have the same question (0)

All responses (4)

Answers (1)

Sort by

MichaelAnnis 5,727 Moderator on at

Like (1)

Report
Copy link

Link copied!

Add this before it breaks:

Get %ExcelData.Columns% and see if [Klinik] is where you expect it to be numerically. If it is off, I recommend doing this in ExcelVBA for better accuracy.

Would it hurt your data if you were to unmerge all cells? This might be another option, to unmerge before reading the data.

Was this reply helpful? Yes No
R-Der 13 on at

Like (0)

Report
Copy link

Link copied!

I have already tried unmerging and set the title on row 8 (as the numeric values start from row 9), but it starts with deleting the title row, and the process gets confused and deletes first rows disregarding the numeric value on it. Then the process stops after deleting 5/6 rows.
I did try to start the reading process from row 9 directly with the numeric values but I had to set the specific column where it should read from and that requires the title of the column. Can I just write the Excel column name 'AV' instead of the title, if so then what should be the syntax for that.

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

Like (1)

Report
Copy link

Link copied!

You should be able to tell it "Read From Excel" Row: CurrentItem Column: 48

Was this reply helpful? Yes No
Verified answer

R-Der 13 on at

Like (0)

Report
Copy link

Link copied!

Thank you, I was not paying any attention to the variable status before. It was not a merged cells issue. I set the reading area wrong.
It functions correctly now. Only the rows with 0 under the certain column are deleted.

Was this reply helpful? Yes No