Hi all,
I'm trying to add a custom column but as soon as I click the query gets the 'yellow !' and an error message is returned.
It's a standard youtube tutorial, and I have made it work in the past. The custom column function is; Table.ColumnNames.
It's only the custom column that causes the instant error on the 'query' conditional works fine.
If anyone can help Workbook attached.
Richard.
Last edited by Dicken; 10-26-2021 at 09:34 AM.
Hi,
Not sure I understand. You have
each TableTable
but that should obviously be
each Table
Regards
Hi XOR,
That's the point I'm not as soon as I click custom column I get an error on the query ; on the left pane,
I enter ; TableTable.ColumnNames[Content]), this is selected from the drop down options when Table. is typed in,
I then click ok and get; Expression.Error: The name 'TableTable.ColumnNames' wasn't recognized. Make sure it's spelled correctly.
As I'm not actually spelling anything myself I think that's probably correct. Still stuck.
RD
So just type in "Table" instead of "Table." for the intellisense then autocomplete will work fine.
Regards
Hi XOR,
It started returning the same error for Excel.CurrentWorkbook aslo, so I deleted the whole file and re -downloaded, and it now seems to be returning the correct list of column names. Thanks though as the advice on typing in is bound to come in useful at some point.
I shall mark this as solved, and give rating.
RD
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks